-
Notifications
You must be signed in to change notification settings - Fork 1
/
test.js
93 lines (87 loc) · 2.74 KB
/
test.js
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
var pgp = require('pg-promise')();
var Promise = require('bluebird');
var cn = {
host: 'localhost',
port: 5432,
database: 'eps',
user: 'epsuser',
password: 'epsuser'
};
var db = pgp(cn);
//var insertIntoDB = function (query, options) {
// var query = "select * from eps_test_probability";
// var options = {};
// return new Promise(function (resolve, reject) {
// db.query(query, options)
// .then(function (data) {
// resolve(data);
// }, function (reason) {
// reject(reason);
// })
// .done(function () {
// pgp.end();
// });
// });
//};
//
//var inserted = insertIntoDB("", "");
//inserted.then(function (res) {
// console.log(res[0].user_unique_id);
//});
var dbQuery = function (query, options) {
return new Promise(function (resolve, reject) {
db.query(query, options)
.then(function (data) {
return resolve(data);
}, function (reason) {
return reject(reason);
})
.done(function () {
pgp.end();
});
});
};
dbQuery("select * from eps_tests where test_name=$1", "show_beta_navigation")
.then(function(data){
console.log(data);
});
/////////////////////////////////////////////////
//// This is to show a complete test application;
/////////////////////////////////////////////////
//
//// Loading and initializing the library without options;
//// See also: https://github.com/vitaly-t/pg-promise#initialization-options
//var pgp = require('pg-promise')(/*options*/);
//
//// Database connection details;
//var cn = {
// host: 'localhost', // 'localhost' is the default;
// port: 5432, // 5432 is the default;
// database: 'eps_options',
// user: 'epsuser',
// password: 'epsuser'
//};
//// You can check for all default values in:
//// https://github.com/brianc/node-postgres/blob/master/lib/defaults.js
//
//var db = pgp(cn); // database instance;
//
//db.query("select * from users where active=$1", true)
// .then(function (data) {
// console.log(data); // print data;
// }, function (reason) {
// console.log(reason); // print error;
// })
// .done(function () {
// // If we do not close the connection pool when exiting the application,
// // it may take 30 seconds (poolIdleTimeout) before the process terminates,
// // waiting for the connection to expire in the pool.
//
// // But if you normally just kill the process, then it doesn't matter.
//
// pgp.end(); // closing the connection pool, to exit immediately.
//
// // See also:
// // https://github.com/vitaly-t/pg-promise#library-de-initialization
// });
//