@amiii has joined

@amiii

Created at 2022-03-24T14:53:10.243000Z / Updated at 2022-03-24T14:57:10.244000Z

node-postgresでPostgreSQLを操作するには

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()
}

...
Comments(0)
Comment as Guest