import pg from 'pg'
import bcrypt from 'bcryptjs'

const { Client } = pg

const dbUrl = process.env.DATABASE_URL
const email = process.env.SEED_EMAIL ?? 'e2e@example.com'
const password = process.env.SEED_PASSWORD ?? 'e2e-password'

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

const db = new Client({ connectionString: dbUrl })
await db.connect()

const hash = bcrypt.hashSync(password, 10)
const { rows } = await db.query(
  `INSERT INTO users (first_name, last_name, email, encrypted_password, active, updated_at)
   VALUES ($1, $2, $3, $4, true, NOW())
   ON CONFLICT (email) DO UPDATE
     SET encrypted_password = EXCLUDED.encrypted_password,
         active = true,
         updated_at = NOW()
   RETURNING id, email`,
  ['E2E', 'User', email, hash],
)

await db.end()

console.log(`Seeded user: ${rows[0].email} (id ${rows[0].id})`)