| import "dotenv/config"; | |
| import pg from "pg"; | |
| const required = ["DATABASE_HOST", "DATABASE_USER", "DATABASE_PASSWORD"]; | |
| const missing = required.filter((name) => !process.env[name]); | |
| if (missing.length > 0) { | |
| console.error(`Missing required env vars: ${missing.join(", ")}`); | |
| process.exit(1); | |
| } | |
| const client = new pg.Client({ | |
| host: process.env.DATABASE_HOST, | |
| port: Number(process.env.DATABASE_PORT || 5432), | |
| user: process.env.DATABASE_USER, | |
| password: process.env.DATABASE_PASSWORD, | |
| database: process.env.DATABASE_DBNAME || "postgres", | |
| ssl: { rejectUnauthorized: false }, | |
| connectionTimeoutMillis: 8000, | |
| }); | |
| try { | |
| await client.connect(); | |
| const result = await client.query("select current_database() as db, now() as now"); | |
| console.log(result.rows[0]); | |
| } finally { | |
| await client.end(); | |
| } | |