Created
July 28, 2022 11:11
-
-
Save ericpkatz/1c80cafed68a9b2e548b0273d92d7bee to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const pg = require('pg'); | |
try { | |
//in secret.js add the following | |
//process.env.DATABASE_URL = 'YOUR_SECURE_REMOTE_CONNECTION_STRING'; | |
//ADD secret.js to your .gitignore for security | |
require('./secret'); | |
} | |
catch(ex){ | |
console.log(ex); | |
} | |
let config = { | |
connectionString: 'YOUR_LOCAL_CONNECTION_STRING' | |
}; | |
if(process.env.DATABASE_URL){ | |
config = { | |
connectionString: process.env.DATABASE_URL, | |
ssl: { | |
rejectUnauthorized: false | |
} | |
}; | |
} | |
const client = new pg.Client(config); | |
client.connect(); | |
const setup = async()=> { | |
let SQL = ` | |
DROP TABLE IF EXISTS users; | |
CREATE TABLE users( | |
id SERIAL PRIMARY KEY, | |
name VARCHAR(10) | |
); | |
`; | |
//create table | |
await client.query(SQL); | |
SQL = `SELECT * FROM users;`; | |
let response = await client.query(SQL); | |
console.log(response.rows); | |
SQL = ` | |
INSERT INTO users(name) VALUES('moe'); | |
INSERT INTO users(name) VALUES('larry'); | |
INSERT INTO users(name) VALUES('curly'); | |
INSERT INTO users(name) VALUES('ethyl'); | |
`; | |
await client.query(SQL); | |
SQL = `SELECT * FROM users;`; | |
response = await client.query(SQL); | |
console.log(response.rows); | |
}; | |
setup(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment