xinghen.work/server/migrate.ts

import { readFile } from 'node:fs/promises'
import { fileURLToPath } from 'node:url'
import { dirname, join } from 'node:path'
import { pool } from './db.js'

const here = dirname(fileURLToPath(import.meta.url))
const sql = await readFile(join(here, 'schema.sql'), 'utf8')
await pool.query(sql)
console.log('Database schema is ready.')
await pool.end()