Related Topics
React JS
Angular JS
Node JS
const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'postgres'
});
const User = sequelize.define('user', {
firstName: {
type: Sequelize.STRING,
allowNull: false
},
lastName: {
type: Sequelize.STRING,
allowNull: false
},
email: {
type: Sequelize.STRING,
allowNull: false,
unique: true
}
});
// Create the users table in the database
User.sync()
.then(() => console.log('Users table created'))
.catch(error => console.error('Error creating users table:', error));
Once the model is defined, you can use Sequelize methods to interact with the “users” table:
// Create a new user record
User.create({
firstName: 'John',
lastName: 'Doe',
email: 'johndoe@example.com'
})
.then(user => console.log('User created:', user.toJSON()))
.catch(error => console.error('Error creating user:', error));
// Find all users
User.findAll()
.then(users => console.log('All users:', users))
.catch(error => console.error('Error finding users:', error));
const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'mysql'
});
const User = sequelize.define('User', {
id: {
type: DataTypes.INTEGER,
autoIncrement: true,
primaryKey: true
},
name: {
type: DataTypes.STRING,
allowNull: false
},
email: {
type: DataTypes.STRING,
allowNull: false,
unique: true
},
password: {
type: DataTypes.STRING,
allowNull: false
}
});
Once the model schema is defined, you can use it to perform CRUD operations. Here are some examples of how to do that:
Create: To create a new user, you can use the
createmethod:
User.create({
name: 'John Doe',
email: 'johndoe@example.com',
password: 'password123'
}).then(user => {
console.log(user);
}).catch(error => {
console.error(error);
});
Read: To fetch a user from the database, you can use the
findOnemethod:
User.findOne({ where: { email: 'johndoe@example.com' }})
.then(user => {
console.log(user);
})
.catch(error => {
console.error(error);
});
Update: To update an existing user, you can use the
updatemethod:
User.update({ name: 'Jane Doe' }, { where: { email: 'johndoe@example.com' }})
.then(() => {
console.log('User updated');
})
.catch(error => {
console.error(error);
});
Delete: To delete a user, you can use the
destroymethod:
User.destroy({ where: { email: 'johndoe@example.com' }})
.then(() => {
console.log('User deleted');
})
.catch(error => {
console.error(error);
});
You can also use Sequelize to perform more complex queries, such as joins, aggregates, and transactions. Here’s an example of using Sequelize to fetch all users and their associated posts:
User.findAll({
include: [
{
model: Post,
as: 'posts'
}
]
}).then(users => {
console.log(users);
}).catch(error => {
console.error(error);
});
Popular Category
Topics for You
React JS
Angular JS
Go through our study material. Your Job is awaiting.