@skweb/sequelize

Sequelize utilities for skweb projects.

Installation

npm install @skweb/sequelize

Usage

const { Database, findAndCountAll } = require('@skweb/sequelize')

const db = new Database({
  dialect: 'mysql',
  host: 'localhost',
  port: 3306,
  username: 'root',
  password: 'password',
  database: 'mydb'
})

// Load models
db.loadModelsDir('./models')
db.associateAllModels()

// Query with pagination
const result = await findAndCountAll(User, req.query, {
  matchKeys: ['status'],
  likeKeys: ['name'],
  searchKeys: ['name', 'email'],
  orderKeys: ['id', 'createdAt']
})

License

MIT