Contoh struktur model:

import { DataTypes } from 'sequelize';
export default (sequelize) => {
  const User = sequelize.define('m_user', {
    id: {
      type: DataTypes.UUID,
      defaultValue: DataTypes.UUIDV4,
      primaryKey: true
    },
    username: {
      type: DataTypes.STRING(100),
      allowNull: false,
      unique: true
    },
    email: DataTypes.STRING(255),
    isActive: {
      type: DataTypes.BOOLEAN,
      defaultValue: true
    }
  }, {
    tableName: 'm_user',
    timestamps: true
  });
  return User;
};

Fungsi standar yang di-generate:

// GET all with pagination & filter
export const getAll = async (req, res) => { ... }

// GET by ID
export const getById = async (req, res) => { ... }

// POST create new
export const create = async (req, res) => { ... }

// PUT update by ID
export const update = async (req, res) => { ... }

// DELETE by ID
export const remove = async (req, res) => { ... }

// POST bulk create
export const bulkCreate = async (req, res) => { ... }

// DELETE bulk
export const bulkDelete = async (req, res) => { ... }

Endpoint standar:

import express from 'express';
import * as controller from '../controllers/userController.js';

const router = express.Router();

router.get('/users', controller.getAll);
router.get('/users/:id', controller.getById);
router.post('/users', controller.create);
router.put('/users/:id', controller.update);
router.delete('/users/:id', controller.remove);
router.post('/users/bulk', controller.bulkCreate);
router.delete('/users/bulk', controller.bulkDelete);

export default router;

Jenis hooks yang tersedia:

export default (User) => {
  // Sebelum create
  User.beforeCreate(async (instance) => {
    // Hash password, generate slug, dll
  });

  // Setelah create
  User.afterCreate(async (instance) => {
    // Send email, log activity, dll
  });

  // Sebelum update
  User.beforeUpdate(async (instance) => {
    // Validasi, track changes, dll
  });

  // Setelah update
  User.afterUpdate(async (instance) => {
    // Update cache, notify, dll
  });

  // Sebelum delete
  User.beforeDestroy(async (instance) => {
    // Check dependencies, backup, dll
  });
};

Contoh helper functions:

// Format response
export const successResponse = (data, message) => ({
  status: 'success',
  message,
  data
});

export const errorResponse = (message, error) => ({
  status: 'error',
  message,
  error: error?.message
});

// Generate unique code
export const generateCode = (prefix) => {
  const date = new Date();
  const timestamp = date.getTime();
  return `${prefix}-${timestamp}`;
};

// Pagination helper
export const paginate = (page, limit) => {
  const offset = (page - 1) * limit;
  return { limit, offset };
};