import { neon } from '@neondatabase/serverless';

// Strip channel_binding — neon HTTP driver doesn't support it
const url = process.env.DATABASE_URL!.replace(/[?&]channel_binding=[^&]*/g, '').replace(/\?&/, '?').replace(/&&/, '&').replace(/[?&]$/, '');
const sql = neon(url);
try {
  const result = await sql`SELECT version()`;
  console.log('OK:', (result[0] as {version:string}).version.slice(0, 60));
  const tables = await sql`SELECT tablename FROM pg_tables WHERE schemaname = 'public' ORDER BY tablename`;
  console.log('tables:', (tables as {tablename:string}[]).map((r) => r.tablename).join(', ') || '(none)');
} catch (err) {
  const e = err as Error;
  console.error('ERROR:', e.message);
}