knex-automigrate

import knex from 'knex'; import { MigrateAuto } from 'knex-automigrate'; import path from 'path'; import fs from 'fs'; // Create a minimal knexfile.js for demonstration const knexfilePath = path.join(process.cwd(), 'knexfile.js'); const knexConfig = ` module.exports = { development: { client: 'sqlite3', connection: { filename: './dev.sqlite3' }, migrations: { directory: './migrations' }, useNullAsDefault: true } }; `; fs.writeFileSync(knexfilePath, knexConfig); // Create a migrations directory and a sample table schema file const migrationsDir = path.join(process.cwd(), 'migrations'); if (!fs.existsSync(migrationsDir)) fs.mkdirSync(migrationsDir); const tableUsersPath = path.join(migrationsDir, 'table_users.js'); const tableUsersSchema = ` exports.auto = function(migrator, knex) { return [ migrator('users', function(table) { table.increments('user_id').unsigned().comment('PK'); table.string('email', 128).notNullable().comment('E-Mail'); table.string('name', 128).notNullable().comment('Name'); table.timestamps(true, true); }) ]; }; `; fs.writeFileSync(tableUsersPath, tableUsersSchema); console.log('knexfile.js and table_users.js created.'); // Programmatic usage example (mimicking CLI behavior) const config = require(knexfilePath).development; const knexInstance = knex(config); async function runAutomigrate() { try { const migrator = new MigrateAuto(knexInstance, config.migrations.directory); await migrator.migrateAuto(); console.log('Automigrate completed successfully.'); } catch (error) { console.error('Automigrate failed:', error); } finally { await knexInstance.destroy(); // Clean up created files/dirs for isolated example fs.unlinkSync(knexfilePath); fs.unlinkSync(tableUsersPath); fs.rmdirSync(migrationsDir); fs.unlinkSync('./dev.sqlite3'); } } runAutomigrate();