-
check_circle_outlineMódulo 1 | 5 clases
Introducción a NodeJS
expand_more -
check_circle_outlineMódulo 2 | 4 clases
El Mundo Asíncrono
expand_more -
check_circle_outlineMódulo 3 | 3 clases
Utilidades en NodeJS
expand_more -
check_circle_outlineMódulo 4 | 4 clases
La magia de los Streams
expand_more -
check_circle_outlineMódulo 5 | 2 clases
Servidores Web con ExpressJS
expand_more -
check_circle_outlineMódulo 6 | 4 clases
NodeJS y las Bases de Datos
expand_more -
check_circle_outlineMódulo 7 | 7 clases
API Restful en ExpressJS
expand_more -
check_circle_outlineMódulo 8 | 6 clases
En el medio del Middleware
expand_more -
check_circle_outlineMódulo 9 | 6 clases
Testing en NodeJS
expand_more -
check_circle_outlineMódulo 10 | 3 clases
Seguridad en NodeJS
expand_more -
check_circle_outlineMódulo 11 | 7 clases
Despliegue de Nuestra Aplicación
expand_more
2 comentario(s)
seed Tables.js
const connection = require("../lib/connect");
const createUsersTable = `CREATE TABLE users (
userId INT AUTO_INCREMENT,
username VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
passwordHash VARCHAR(255) NOT NULL,
creationDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updateDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
bio TEXT,
location VARCHAR(255),
PRIMARY KEY (userId)
)`;
const createTweetsTable = `CREATE TABLE tweets (
tweetId INT AUTO_INCREMENT,
userId INT,
content VARCHAR(280),
creationDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (tweetId)
)`;
const insertUsers = `INSERT INTO users (username, email, passwordHash, bio, location)
VALUES
('JohnDoe', 'johndoeexample.com', 'hashedpassword1', 'I love coding', 'New York'),
('JaneDoe', '[email protected]', 'hashedpassword2', 'I love databases', 'San Francisco')`;
const printError = (msg) => (error) => {
error && console.error(msg, error);
};
connection.connect((error) => {
error && console.log("Error connecting to database: ", error);
connection.query(
createUsersTable,
printError("Error creating users table")
);
connection.query(
createTweetsTable,
printError("Error creating tweets table")
);
connection.query(insertUsers, printError("Error inserting users"));
console.log("Creation tables and inserting users done");
connection.end();
});
seedTweets.js
const connection = require(" ../lib/connect");
const insertTweets = `INSER INTO tweets (userId, content)
VALUES
(1, 'This is my first tweet!'),
(1, 'This is my second tweet!'),
(1, 'I love coding'),
(1, 'Node.js is awesome'),
(1, 'Just finished my OpenAI project'),
(2, 'Hello Twitter!'),
(2, 'This is Janell's second tweet!'),
(2, 'I love databases'),
(2, 'MySQL is great'),
(2, 'Just finished a database design project')`;
const printError = (msg) => (error) => {
error && console.error(msg, error);
};
connection.connect((error) => {
error && console.log("Error connecting to database: ", error);
connection.query(insertTweets, printError("Error inserting tweets table"));
console.log("Inserting tweets done");
connection.end();
});
Clase 22