node.js

Introduction   In this article we will see how to use sequelize-cli for creating table in our database.and how can we setup a relationship between two table using foreignKey using sequelize Project Structure Setup The Node Project Open the console and  type the below cmd to make a new directory.         # mkdir seqlcli Then change to that directory by typing below cmd.         # cd seqlcli Setup Node In Project Now  type the below cmd on console and that will generate the package.json file.       # npm init  It will ask you to provide the basic details related to the package.json file have like name,version,author etc. After the file is initialize we can build our node project. The file will have all the metadata related to our project. Install Packages Now we will install the package which are required for building our application. On console type         # npm install express,body-parser,sequelize,mysql2,sequelize-cli So what th

Prerequisites Node MySql What Is Sequelize? As mentioned on the sequelize site, 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 . It supports Node v6 and above to use ES6 features. 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 Le