Kysely migrations

migrate.sh

#!/usr/bin/env bash

# Ensure script stops when commands fail.
set -e

echo "Migrating database..."

# Ensure the dist directory exists.
mkdir -p ./db/dist
mkdir -p ./db/dist/migrations

# Compile the TypeScript files to JavaScript.
npx tsc --outDir ./db/dist ./db/*.ts --target ESNext --moduleResolution node --module ESNext --esModuleInterop true
npx tsc --outDir ./db/dist/migrations ./db/migrations/*.ts --target ESNext --moduleResolution node --module ESNext --esModuleInterop true

# Run the migrations.
node ./db/dist/migrate.js

# Remove the dist directory.
rm -r ./db/dist

echo "Migrations complete."