node.js

Introduction In this article, we will explore how to use Sequelize-CLI for creating database tables and setting up powerful relationships between multiple tables using foreign keys in Node.js and MySQL. Project Structure |--------- config |--------- config.json |--------- models |--------- index.js |--------- department.js |--------- emp.js |--------- migrations |--------- [timestamp]-create-department.js |--------- [timestamp]-create-emp.js |--------- seeders |--------- app.js |--------- package.json Setup The Node Project Let's begin by initializing our workspace: Open your console and create a new directory: mkdir seqlcli Navigate into that directory: cd seqlcli Initialize the Node.js project by running: npm init This will prompt you for basic project metadata like name, version, and author, generating a package.json file. Install P...

Prerequisites Node.js MySQL What Is Sequelize? Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server. It features solid transaction support, relations, eager and lazy loading, read replication, and more. Sequelize follows SEMVER and supports Node v6 and above to utilize ES6 features. Express and Sequelize Project Structure |--------- config |--------- db.js |--------- controllers |--------- memberController.js |--------- models |--------- member.js |--------- routes |-------- members.js |--------- views |------- partials |------- header.ejs |------- footer.ejs |------ home.ejs |------ edit.ejs |--------- app.js |--------- package.json Project Setup Let's begin by setting up our workspace: Open the console and type mkdir followed by your directory name. ...