Skip to content

armgit / fx0

Public Imported from GitHub
0

A lightweight design agent built with libfx. Describe a page and an agent writes it as one HTML file.

TypeScript
1.1 KB
Raw Blame
import { readdir, readFile } from 'node:fs/promises'
import { neon } from '@neondatabase/serverless'

if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is required')
const directory = new URL('../migrations/', import.meta.url)
const files = (await readdir(directory)).filter((name) => /^\d{3}_.+\.sql$/.test(name)).sort()
const sql = neon(process.env.DATABASE_URL)
for (const file of files) {
  try {
    const migration = await readFile(new URL(file, directory), 'utf8')
    // Every statement is idempotent, so reapplying earlier files is safe.
    const statements = migration.split('\n').filter((line) => !line.trimStart().startsWith('--')).join('\n')
      .split(';').map((text) => text.trim()).filter(Boolean)
    // One Neon HTTP transaction per file; never BEGIN/COMMIT on separate connections.
    await sql.transaction(statements.map((text) => sql.query(text)))
    console.log(`${file} applied`)
  } catch {
    // Driver errors may contain connection details; never print them.
    console.error(`${file} failed; verify DATABASE_URL and database permissions`)
    process.exitCode = 1
    break
  }
}