FilesExpand file tree

main

/

rdbms-test.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

44 lines (39 loc) · 1.1 KB

main

/

rdbms-test.js

Copy path

Top

File metadata and controls

• Code
• Blame

44 lines (39 loc) · 1.1 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

const express = require('express');

var pg = require('pg');

var format = require('pg-format');

const app = express();

var PGUSER = 'oldsilverboi';

var PGDATABASE = 'oldsilverboi';

var config = {

user: PGUSER, // name of the user account

database: PGDATABASE, // name of the database

max: 10, // max number of clients in the pool

idleTimeoutMillis: 30000 // how long a client is allowed to remain idle before being closed

};

var pool = new pg.Pool(config);

pool.connect(function (err, client, done) {

if (err) console.log(err);

app.listen(3000, function () {

console.log('listening on 3000')

});

const newProduct = `

INSERT INTO

products

(name, category, slogan, description, default_price)

VALUES

('Test', 1, 'thing', 'big thing', '100');

`;

const getProducts = 'SELECT * FROM products';

client.query(newProduct, function (err, result) {

if (err) {

console.log(err);

}

console.log(result);

client.query(getProducts, function (err, result) {

if (err) {

console.log(err);

}

console.log(result.rows[0]);

});

});

});