Learn How To Develop a Landing Page and Collect Sales Leads using ExpressJS/NodeJSInstall NodeJS, ExpressJS, and Generate Application SkeletonBackground on NodeJSIntroduction to app.js and definition of a routerOverview of Application Folders, Run ApplicationYour First Route HandlerHTTP Request SequenceYour First ControllerTutorial source code, programming snippets, Q&A
Your first git commitInstalling NodemonCreate your first form on your landing pageImplement your first POST route
Install Postgres and SequelizeCreate your first model and migrationImplement POST handler saving data to the databaseImplement delete lead routeImplement show lead pageShow a collection of leadsImplement edit, update lead routes
Learn how to divide pug view files into reusable sectionsDevelop your first middleware in ExpressJS, and implement access controlLearn what Ajax is and implement delete route using ajaxLearn how to update landing page looks, and implement a navbarLearn how to implement user sign up and login using PassportJS - Part 1Learn how to implement form validation and re-rendering forms with errorsLearn how to implement user login and sign up using PassportJS - 2Joining Learning ExpressJS Community
Create your first model and migration
Learn how to create your first database model using Sequelize ORM and a migration
Your first migration
Filename: 201901041917-CreateLeadTable.js
'use strict';module.exports = { up: (queryInterface, Sequelize) => { return queryInterface.createTable('Leads', { id: { allowNull: false, primaryKey: true, type: Sequelize.UUID, defaultValue: Sequelize.UUIDV4, }, createdAt: { allowNull: false, type: Sequelize.DATE }, updatedAt: { allowNull: false, type: Sequelize.DATE }, email: { allowNull: false, type: Sequelize.STRING }, }) }, down: (queryInterface, Sequelize) => { return queryInterface.dropTable('Leads'); }};Your first model
Filename: Lead.js
/* jshint indent: 2 */'use strict';module.exports = (sequelize, DataTypes) => { var Lead = sequelize.define('Lead', { id: { type: DataTypes.UUID, defaultValue: DataTypes.UUIDV4, allowNull: false, primaryKey: true }, email: { type: DataTypes.STRING, allowNull: false, }, }); return Lead;};
Join The Discussion
Publish
what is the purpose of this code: return models.sequelize.sync().then(result =>{})? I altered my model and when i initialize the web app this code calls a create table statement defined with columns I removed from my model. I can't figure out how to remove the old columns. Does that make sense?
I've created my first model but only get the following error whenever I try to save an email address (Error: SequelizeValidationError: notNull Violation: Lead.id cannot be null). I've judiciously followed your tutorial, so I'm not sure what's the problem. Thanks for any suggestion.