(config: DatabaseConfig)
| 23 | * Initialize database connection pool |
| 24 | */ |
| 25 | export function initializeDatabase(config: DatabaseConfig): Pool { |
| 26 | if (pool) { |
| 27 | return pool; |
| 28 | } |
| 29 | |
| 30 | pool = new Pool({ |
| 31 | connectionString: config.connectionString, |
| 32 | host: config.host, |
| 33 | port: config.port, |
| 34 | database: config.database, |
| 35 | user: config.user, |
| 36 | password: config.password, |
| 37 | ssl: config.ssl, |
| 38 | max: config.maxPoolSize ?? 20, |
| 39 | min: config.minPoolSize ?? 5, |
| 40 | idleTimeoutMillis: config.idleTimeoutMillis ?? 30000, |
| 41 | connectionTimeoutMillis: config.connectionTimeoutMillis ?? 5000, |
| 42 | allowExitOnIdle: true, |
| 43 | }); |
| 44 | |
| 45 | pool.on("error", (err) => { |
| 46 | console.error("Unexpected database pool error:", err); |
| 47 | poolErrorCallback?.(err); |
| 48 | }); |
| 49 | |
| 50 | console.log("Database connection pool initialized"); |
| 51 | return pool; |
| 52 | } |
| 53 | |
| 54 | /** |
| 55 | * Get database pool instance |
no outgoing calls
no test coverage detected