import pg from 'pg'

const { Client } = pg

const dbUrl = process.env.DATABASE_URL
if (!dbUrl) {
  console.error('DATABASE_URL is not set')
  process.exit(1)
}

const url = new URL(dbUrl)
const dbName = url.pathname.slice(1)
url.pathname = '/postgres'

const client = new Client({ connectionString: url.toString() })
await client.connect()
await client.query(`CREATE DATABASE "${dbName}"`).catch((err) => {
  if (err.code !== '42P04') throw err // 42P04 = database already exists
})
await client.end()

console.log(`Database "${dbName}" is ready.`)