What are some examples of using Sequelize with Node.js?

Can you give me some examples of using Sequelize with Node.js?

Sure! Sequelize is a promise-based ORM for Node.js that supports various SQL dialects. For example, you can define a model like this:

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

const User = sequelize.define('User', {
  username: {
    type: DataTypes.STRING,
    allowNull: false
  },
  password: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

This code sets up a User model with username and password fields.

How do I create a new user using this model?

To create a new user, you can use the create method provided by Sequelize. Here's an example:

User.create({
  username: 'john_doe',
  password: 'securepassword'
}).then(user => {
  console.log('User created:', user);
}).catch(error => {
  console.error('Error creating user:', error);
});

What about querying users from the database?

You can query users using methods like findAll or findOne. For example:

User.findAll().then(users => {
  console.log('All users:', JSON.stringify(users, null, 2));
});