Using Sequelize with typescript and express : Import all model files
Typescript , Uncategorized / February 17, 2019

STEP 1    Install Sequelize Install the latest version of Sequelize

Now create your migration script STEP 2  Initialize your project To create an empty project you  need to run init command

This will create seeders, config, migrations and models folders Modify the configuration file in your config folder accordingly   Step 3 Create your model and migration files

This will create Migration files in the migrations folder and model files in the models folder Step 4 Using models with typescript and express When you create multiple tables multiple model files will be created. To use all these model files at once, create a model folder in your project directory, create an index.ts file and include all the files using the fs module and path module of Node.js   The index.ts file will look like this  

The code

finds the model folder which is  outside your server files folder __dirname – Gives the current directory in which the executing file is located

Finds all .js model files inside the models folder

sequelizeconnection.import  import model files.In this case, it imports all model files

Above code adds the model to the model object


ORM & Using Sequelize ORM with Express (Node.js)

Object-relational mapping (ORM, O/RM, and O/R mapping) in computer software is a programming technique for converting data between incompatible type systems in relational databases and object-oriented programming languages(WIKI).ORM converts data between type systems that cannot co-exist. Sequelize is a promise-based ORM (Object relation model) for Node.js. It supports the dialects PostgreSQL, MySQL, SQLite, MSSQL and features solid transaction support, relations, read replication and more. For creating sequelize connection in Express, use the following code. Here we create a connection to ‘user’ database

Now create a folder ‘model’ . For each table in the database we create a model file. In our example, we have a users model users.js

Now Create an index.js file inside the model folder

Now the above code in index.js file helps us use all model files inside our model folder. For understanding more about sequelize, refer How to  handle errors in sequelize query Consider the below example in which we do a CREATE which insert data into  a table





Starting off Node.js web developement in ubuntu/Linux Mint 18 – (ExpressJS,Mysql)

Node.js is an open source server environment which lets us write server side code in javascript. Node.js is asynchronous,single threaded and non-blocking .Node.js has very high memory efficiency which makes it very popular in server side  developement for web/mobile app.In this article we take a look at how to start of web developement in Node.js with Mysql as database. To install Node.js in your linux run the following command in the terminal

After installation run the following command to verify the installation and check the version of Node.js you are having.

  npm(node package manager) is a Node.js package manager that is bundled along with Node.js. npm help us manage Node.js packages efficiently. To initialize our project run the following command in the folder  you want to create the project.

You need to provide a few details like name of your project,version etc which can be skipped.The command will create a package.json file in which you can add the packages you want to  your project. The package.json file will look like this.

Express is a web developement framework for node js.To install Express run the following command in terminal

–save option add the dependency to…

Share this page in social media platforms