dbsetup.js

#!/usr/bin/env node

const { spawn } = require('node:child_process')
const path = require('node:path')
const fs = require('node:fs')

const env = { ...process.env }

;(async() => {
  // place Sqlite3 database on volume
  const source = path.resolve('./dev.db')
  const target = '/data/' + path.basename(source)
  if (!fs.existsSync(source) && fs.existsSync('/data')) fs.symlinkSync(target, source)
  const newDb = !fs.existsSync(target)
  if (newDb && process.env.BUCKET_NAME) {
    await exec(`npx litestream restore -config litestream.yml -if-replica-exists ${target}`)
  }

  // prepare database
  await exec('npx prisma migrate deploy')

  // launch application
  if (process.env.BUCKET_NAME) {
    await exec(`npx litestream replicate -config litestream.yml -exec ${JSON.stringify(process.argv.slice(2).join(' '))}`)
  } else {
    await exec(process.argv.slice(2).join(' '))
  }
})()

function exec(command) {
  const child = spawn(command, { shell: true, stdio: 'inherit', env })
  return new Promise((resolve, reject) => {
    child.on('exit', code => {
      if (code === 0) {
        resolve()
      } else {
        reject(new Error(`${command} failed rc=${code}`))
      }
    })
  })
}