Changeset 64dc53b for pages/api/postgre

Timestamp:

06/11/22 23:50:19 (2 years ago)

Author:

anastasovv <simon@…>

Branches:

main

Children:

4a1a3ca

Parents:

87614a5

Message:

Code cleanings

File:

• pages/api/postgre/index.js (modified) (2 diffs)

pages/api/postgre/index.js

@@ -9 +9 @@
 const Pool = require('pg').Pool
 const pool = new Pool({
-  connectionString: 'postgres://postgres:postgres@db/postgres'
+  connectionString: `postgres://${process.env.POSTGRES_USER}:${process.env.POSTGRES_PASSWORD}@${process.env.POSTGRES_HOST}/${process.env.POSTGRES_DB}`
 });
 
@@ -22 +22 @@
 // }
 
-// update credits in database
-// setInterval(() => {
-//   sessions.filter(session => Date.now() - session.lastActivity > 5*60*1000).forEach(session => {
-//     pool.query('UPDATE players SET credits = $1 WHERE username = $2', [session.credits, session.username], (error, results) => {
-//       if (error) throw error;
-//     });
-//   });
-// }, 5*60*1000)
 
 export default function handler(req, res) {