import { argv, cwd, exit } from 'node:process' import { existsSync, readFileSync, writeFileSync } from "node:fs" import { glob } from 'node:fs/promises'; import { connect } from "@tursodatabase/database"; const { default: config } = await (() => { if (!existsSync(`${cwd()}/db.config.js`)) { console.log("No db.config.js found. Using default config") return { default: {} } } return import(`${cwd()}/db.config.js`) })() const availableCommands = ["migrate", "new"] const originalArgs = argv const command = originalArgs.find(val => availableCommands.includes(val)) const createMigrationFile = () => { let migrationName = originalArgs.at(-1) migrationName === "new" ? migrationName = Date.now() : migrationName = `${Date.now()}_${migrationName.toLowerCase().replaceAll(" ", "_")}` writeFileSync(`${config.migrationsDir}/${migrationName}.sql`, "", { encoding: "utf-8" }) } const applyMigrations = async () => { const db = await connect(config.file) const createMigrationsTable = ` CREATE TABLE IF NOT EXISTS schema_migrations ( version TEXT PRIMARY KEY, applied_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP );` await db.prepare(createMigrationsTable).run() const appliedMigrations = (await (await db.prepare("SELECT version FROM schema_migrations")).all()).map((v) => v.version) for await (const file of glob(`${config.migrationsDir}/*.sql`)) { const migrationName = file.split("/").at(-1) if (appliedMigrations.includes(migrationName)) continue; const content = readFileSync(file, { encoding: "utf-8"}) const statements = content.split("---") const transaction = await db.transactionAsync(async (txn) => { for (const statement of statements) { await (await txn.prepare(statement)).run() } await (await txn.prepare(` INSERT INTO schema_migrations (version) VALUES(?) `)).run(migrationName) }) await transaction() } } switch (command) { case "new": createMigrationFile(); break; case "migrate": applyMigrations(); break; default: console.log("Available commands are: " + availableCommands.join(", ")) }