43 lines
1.1 KiB
JavaScript
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);
|
|
}
|