Something went wrong. Try again.
Testing building apps with atproto
Something went wrong. Try again.
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273import { 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 = argvconst 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(", "))}