DEV Community

Cover image for SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL
Munisekhar Udavalapati
Munisekhar Udavalapati

Posted on

SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL

Installing sequelize

npm install --save sequelize

You can also install MySQL. to use this command

npm install --save mysql2

Connecting to the database

javaScript const {Sequelize} =require('sequlize');
const sequelize =new Sequelize('database','username','password',{
host:'localhost',
dialect;
});

Testing the connection

javaScript try{
await sequlize.authenticate();
console.log('Connection success');
}catch(err){
console.error('Unable to connect to the database',err);
}

Model

Models are reprent's table from the database

const Sequelize=require('sequelize');
const sequelize=require('../util/db.js'); //database connection locations
const User=sequelize.define(
 'User', //table name 
  {  
    id:{
     type:Sequlize.INTEGER,
     autoIncrement:true,
     primaryKey:true
     },
     name:{
       type:Sequelize.STRING,
       allowNull: false,
     },
     email:{
        type:Sequelize.STRING,
        allowNull:false,
        unique:true
     }
  }

module.exports=User;
Enter fullscreen mode Exit fullscreen mode

Top comments (4)

Collapse
 
jani_jan_91de7320b39903f6 profile image
Jani jan

"Thanks for sharing this insightful guide! The way you broke down Sequelize's ORM usage with MySQL makes it much easier to understand how to manage SQL queries in a more efficient way. A quick suggestion—while integrating Sequelize, consider exploring API automation and connecting it to platforms like Igram . It opens up possibilities for managing dynamic content updates via SQL, offering an advanced layer of interaction for developers."

Collapse
 
jani_jan_91de7320b39903f6 profile image
Jani jan

Great breakdown on using Sequelize with MySQL, Munisekhar! The examples were super helpful for getting started with SQL in Node.js applications. For those automating financial transaction flows with Sequelize, consider leveraging tools like Spoof Paytm for testing edge cases in payment APIs. It can simulate a variety of scenarios without affecting real transactions, helping ensure the robustness of your application under different conditions. Keep up the great work with these informative posts!

Collapse
 
jani_jan_91de7320b39903f6 profile image
Jani jan

For those diving into SQL with Sequelize as discussed in the thread, the ORM offers powerful functionality for managing MySQL databases with ease. However, a good practice is maintaining root-level control over your database. Tools like SuperSU can complement this, especially for those who want to ensure root access when working on Android systems or emulated environments, facilitating smoother data management.

Some comments may only be visible to logged-in visitors. Sign in to view all comments.