const http = require('http');
const { Pool } = require('pg');
require('dotenv').config();
let hostname = 'localhost';
let port = 8000;
let server = http.createServer((request, response) => {
response.statusCode = 200;
response.setHeader('Content-Type', 'text/plain');
response.end('');
});
let connectDb = async () => {
try {
const POOL = new Pool({
user: process.env.PGUSER,
host: process.env.PGHOST,
database: process.env.PGDATABASE,
password: process.env.PGPASSWORD,
port: process.env.PGPORT,
});
await POOL.connect();
let response = await POOL.query('SELECT * FROM context');
console.log(response);
await POOL.end();
module.exports = POOL;
} catch (error) {
console.log(error);
}
}
server.listen(port, hostname, () => {
console.log(`Server running at http://${hostname}:${port}/`);
connectDb();
});