$ PGUSER=dbuser \
PGHOST=database.server.com \
PGPASSWORD=secretpassword \
PGDATABASE=mydb \
PGPORT=3211 \
node script.js
const { Client } = require('pg')
const client = new Client(
{
user: 'yicheng',
host: 'localhost',
database: 'mysb',
password: '123456',
port: 5432,
}
)
const { Client } = require('pg')
const client = new Client()
client.connect()
client.query('select * from company;', (err, res) => {
console.log(err ? err.stack : res.rows)
client.end()
})
const { Client } = require('pg')
const client = new Client()
client.connect()
var data = ["000", "bazi", 2, 1, Date.now()];
var queryletter =`INSERT INTO bet_user(ADDRESS, CATEGORY, ODDS, AMOUNT, TIMESTAMP) VALUES ($1, $2, $3, $4, $5)`;
client.query(queryletter, data, (err, res) => {
console.log(err ? err.stack : res.rows)
client.end()
})
如果是直接寫,記得要是value單引號,不然會出現沒有該column name的錯誤
const insertString = `INSERT INTO users (account, password, username) VALUES('${req.body.account}','${req.body.password}','${req.body.account}');`
async function query(exec_query, data, callback) {
const _client = await client.connect();
if (typeof data === "function") {
callback = data;
data = "";
}
await client.query(exec_query, data, (err, res) => {
if (err) return err;
_client.release();
callback(res);
});
}
const pool = new Pool()
pool.query
let values = [(Date.now() + 1000 * 60 * 60 * 8) / 1000.0]
然後 query 使用
to_timestamp($1)
import { Sequelize, Model, DataTypes } from 'sequelize'
const sequelize = new Sequelize('postgres://superuser:example@localhost:5432/hotels') // Example for postgres
class Dog extends Model {}
Dog.init({
name: {
type: DataTypes.STRING,
allowNull: false
},
age: {
type: DataTypes.INTEGER,
allowNull: false
}
}, {
sequelize,
modelName: 'dogs',
timestamps: false
})
const name = 'Roger'
const age = 8
const result = await Dog.create({ name, age })
console.log(result)
Dog.findOne({
where: {name: "Roger"}, // where 條件
attribute: [] //指定回傳欄位
}).then(function(object) {
console.log(object)
if(object) {
console.log("exist")
} else {
console.log("Not exist")
}
})