app-min-ser-nest/scripts/create-db.mjs
2026-10-17 19:40:29 -04:00

43 lines
1.1 KiB
JavaScript

import { config as loadEnv } from 'dotenv';
import { Client } from 'pg';
loadEnv();
const host = process.env.DB_HOST ?? 'localhost';
const port = Number(process.env.DB_PORT ?? 5432);
const user = process.env.DB_USER ?? 'postgres';
const password = process.env.DB_PASSWORD ?? 'postgres';
const database = process.env.DB_NAME ?? 'min_ser';
const maintenance = new Client({
host,
port,
user,
password,
database: 'postgres',
});
try {
console.log(`[db] Verificando "${database}" en ${user}@${host}:${port}...`);
await maintenance.connect();
const result = await maintenance.query('SELECT 1 FROM pg_database WHERE datname = $1', [
database,
]);
if (result.rowCount && result.rowCount > 0) {
console.log(`[db] La base "${database}" ya existe.`);
} else {
const safeName = database.replace(/"/g, '""');
await maintenance.query(`CREATE DATABASE "${safeName}"`);
console.log(`[db] Base "${database}" creada correctamente.`);
}
} catch (error) {
console.error(
'[db] Error:',
error instanceof Error ? error.message : error,
);
process.exitCode = 1;
} finally {
await maintenance.end().catch(() => undefined);
}