What are some examples of using ORM in Node.js?

What are some examples of using ORM in Node.js?

ORM, or Object-Relational Mapping, allows you to interact with databases using JavaScript objects. Popular ORMs for Node.js include Sequelize and TypeORM. Would you like to see specific examples?

Yes, please provide an example using Sequelize.

Sure! Here's a simple example using Sequelize:

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:');

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

(async () => {
  await sequelize.sync(); // Creates the table if it doesn't exist
  const user = await User.create({ username: 'john_doe', birthday: new Date(1990, 1, 1) });
  console.log(user.toJSON());
})();

This code defines a User model and creates a new user in the database.

What about an example using TypeORM?

Here's a basic example using TypeORM:

import { Entity, PrimaryGeneratedColumn, Column, createConnection } from 'typeorm';

@Entity()
class User {
  @PrimaryGeneratedColumn()
  id;

  @Column()
  username;

  @Column()
  birthday;
}

createConnection({
  type: 'sqlite',
  database: 'database.sqlite',
  entities: [User],
  synchronize: true,
}).then(async connection => {
  const user = new User();
  user.username = 'jane_doe';
  user.birthday = new Date(1995, 5, 15);
  await connection.manager.save(user);
  console.log('User has been saved:', user);
});

This code defines a User entity and saves a new user to the SQLite database.