import 'dotenv/config';
import bcrypt from 'bcrypt';
import postgres from 'postgres';

const user = process.env.POSTGRES_USER || 'postgres';
const password = process.env.POSTGRES_PASSWORD || '';
const host = process.env.POSTGRES_HOST || 'localhost';
const port = process.env.POSTGRES_PORT || '5432';
const database = process.env.POSTGRES_DB || 'scriba';
const connectionString = password
  ? `postgres://${user}:${password}@${host}:${port}/${database}`
  : `postgres://${user}@${host}:${port}/${database}`;

const sql = postgres(connectionString);

async function main() {
  const hash = await bcrypt.hash('demo123', 10);
  console.log('New hash:', hash);
  
  await sql`UPDATE account SET password = ${hash} WHERE account_id = 'demo@scriba.ai' AND provider_id = 'credential'`;
  console.log('Password updated for demo@scriba.ai');
  
  await sql.end();
}

main().catch(console.error);