sequelize-typescript-migration-lts

import { join } from 'path'; import { Sequelize } from "sequelize-typescript"; import { SequelizeTypescriptMigration, MakeMigrationOptions } from "sequelize-typescript-migration-lts"; const sequelize = new Sequelize({ dialect: 'sqlite', storage: './database.sqlite', models: [join(__dirname, 'models')], // Ensure your models are loaded logging: false, }); // Define a sample model in models/CarBrand.ts // import { Table, Column, Model, DataType, Default } from 'sequelize-typescript'; // @Table // export class CarBrand extends Model<CarBrand> { // @Column // name: string; // @Default(true) // @Column(DataType.BOOLEAN) // isCertified: boolean; // } async function runMigration() { try { const options: MakeMigrationOptions = { outDir: join(__dirname, './migrations'), migrationName: 'initial-schema-setup', preview: false, isTs: true, // Generate TypeScript migration files }; await SequelizeTypescriptMigration.makeMigration(sequelize, options); console.log('Migration generated successfully. Run `npx sequelize-cli db:migrate` to apply.'); } catch (error) { console.error('Error generating migration:', error); } } // In a real application, you'd integrate this with your CLI or startup process. // For demonstration, we directly call it. // Make sure your Sequelize instance is initialized and models are defined before calling this. // For a quick test, you might call `runMigration()` after defining models. // e.g., runMigration();