mirror of
https://github.com/github/codeql.git
synced 2025-12-17 09:13:20 +01:00
39 lines
1.6 KiB
JavaScript
39 lines
1.6 KiB
JavaScript
// Adapted from the documentation of https://github.com/brianc/node-postgres,
|
|
// which is licensed under the MIT license; see file node-postgres-LICENSE.
|
|
const pg = require('pg');
|
|
|
|
// create a config to configure both pooling behavior
|
|
// and client options
|
|
// note: all config is optional and the environment variables
|
|
// will be read if the config is not present
|
|
var config = {
|
|
user: 'foo', //env var: PGUSER
|
|
database: 'my_db', //env var: PGDATABASE
|
|
password: 'secret', //env var: PGPASSWORD
|
|
host: 'localhost', // Server hosting the postgres database
|
|
port: 5432, //env var: PGPORT
|
|
max: 10, // max number of clients in the pool
|
|
idleTimeoutMillis: 30000, // how long a client is allowed to remain idle before being closed
|
|
};
|
|
|
|
//this initializes a connection pool
|
|
//it will keep idle connections open for 30 seconds
|
|
//and set a limit of maximum 10 idle clients
|
|
const pool = new pg.Pool(config);
|
|
|
|
pool.on('error', function (err, client) {
|
|
// if an error is encountered by a client while it sits idle in the pool
|
|
// the pool itself will emit an error event with both the error and
|
|
// the client which emitted the original error
|
|
// this is a rare occurrence but can happen if there is a network partition
|
|
// between your application and the database, the database restarts, etc.
|
|
// and so you might want to handle it and at least log it out
|
|
console.error('idle client error', err.message, err.stack);
|
|
});
|
|
|
|
//export the query method for passing queries to the pool
|
|
module.exports.query = function (text, values, callback) {
|
|
console.log('query:', text, values);
|
|
return pool.query(text, values, callback);
|
|
};
|