npm install pg
const { Pool, Client } = require('pg');
...
if ( chatData !== null ) {
var pool = new Pool();
var res = await pool.query(`CREATE TABLE IF NOT EXISTS chat(
id SERIAL PRIMARY KEY ,
chat_id TEXT ,
username TEXT ,
innerText TEXT ,
badge TEXT ,
symbol TEXT ,
date TEXT ,
timestamp TIMESTAMP ,
outerHTML TEXT ,
dev TEXT
);`)
// res = await pool.query('INSERT INTO chat (chat_id, username, innerText, badge, symbol, date, timestamp, outerHTML) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8 );', ["chatData.chat_id", "chatData.username", "chatData.innerText", "chatData.badge", "chatData.symbol", "chatData.date", new Date().toISOString(), "chatData.outerHTML"])
res = await pool.query(
'INSERT INTO chat (chat_id, username, innerText, badge, symbol, date, timestamp, outerHTML) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8 );',
[ chatData.chat_id, chatData.username, chatData.innerText, chatData.badge, chatData.symbol, chatData.date, chatData.timestamp, chatData.outerHTML ]
)
await pool.end()
}
...