fiiK35j7

1const {Client} = require('pg');
2
3const client = new Client({
4    user: 'postgres',
5    host: 'localhost',
6    database: 'postgres', 
7    password: 'somepassword',
8    port: 5432 
9});
10
11client.connect((err) => {
12    if(err) {
13        console.error('Client connection error', err.stack);
14    }
15    else {
16        console.log('Client connected');
17    }
18});
19
20client.query(`SELECT 'CREATE DATABASE workout WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'workout')\\gexec`, (err, res) => {
21    if(err) {
22        console.error(`Err Create Workout Error: ${err}`); 
23    }
24});
25
26client.end((err) => {
27    if(err) {
28        console.error('Error ending Client', err.stack);
29    }
30    else {
31        console.log('Client connection ended');
32    }
33});
34
35const db = new Client({
36    user: 'postgres',
37    host: 'localhost',
38    database: 'workout',
39    password: 'someotherpassword',
40    port: 5432
41});
42
43db.connect((err) => {
44    if(err) {
45        console.error('db connection error', err.stack);
46    }
47    else {
48        console.log('db connected');
49    }
50});
51
52db.query(`CREATE table IF NOT EXISTS Person
53    (
54		Person_ID SERIAL PRIMARY KEY,
55		First_Name varchar(20) NOT NULL,
56		Last_Name varchar(20) NOT NULL
57    );`);