Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const pg = require('pg');
- // =======================================================
- // ***************** CONNECT TO POSTGRESQL ***************
- // =======================================================
- let config = {};
- if (process.env.DATABASE_URL) {
- config.connectionString = process.env.DATABASE_URL;
- } else {
- config.user = 'stephaniewong';
- config.password = '';
- config.database = 'stocky';
- }
- let pool = new pg.Pool(config)
- pool.connect();
- // =======================================================
- // ************** INSERT DATA PACKET QUERIES *************
- // =======================================================
- let insertUserPacket = (packet) => {
- let queryString = 'INSERT INTO MyUsers (user_id, totalSessions) VALUES ($1, $2)';
- let values = [packet.user.user_id, packet.user.totalSessions];
- pool.query(queryString, values, (err, results) => {
- if (err) {
- console.error('ERROR', err);
- } else {
- console.log('Success!!!')
- }
- });
- }
- let insertIndicatorPacket = (packet) => {
- let queryString = 'INSERT INTO Indicators (user_id, indicator, totalViews, average) VALUES ($1, $2, $3, $4)';
- let values = [packet.indicators.user_id, packet.indicators.indicator, packet.indicators.totalViews, packet.indicators.average]
- pool.query(queryString, values, (err, results) => {
- if (err) {
- console.error('ERROR', err);
- } else {
- console.log('Success!!!')
- }
- });
- }
- let insertProfitPacket = (packet) => {
- let queryString = 'INSERT INTO Profits (user_id, currencyPair, profitNumber) VALUES ($1, $2, $3)';
- let values = [packet.profits.user_id, packet.profits.currencyPair, packet.profits.profitNumber]
- pool.query(queryString, values, (err, results) => {
- if (err) {
- console.error('ERROR', err);
- } else {
- console.log('Success!!!')
- }
- });
- }
- module.exports.insertUserPacket = insertUserPacket;
- module.exports.insertIndicatorPacket = insertIndicatorPacket;
- module.exports.insertProfitPacket = insertProfitPacket;
- // SAMPLE DATA BELOW >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
- stocky=# select * from indicators;
- id | user_id | indicator | totalviews | average
- ------+----------+-----------+------------+---------
- 1 | 26127541 | MACD | 192 | 0.35
- 2 | 96343507 | MA | 209 | 0.35
- 3 | 71265387 | MACD | 81 | 0.41
- 4 | 26278365 | EMA | 73 | 0.26
- 5 | 22235688 | MACD | 97 | 0.18
- 6 | 56039792 | MACD | 133 | 0.96
- 7 | 80195485 | MA | 441 | 0.64
- 8 | 74519142 | MA | 195 | 0.43
- 9 | 69249767 | MA | 440 | 2.29
- 10 | 25045289 | MACD | 259 | 0.33
- 11 | 70096807 | MA | 55 | 0.06
- 12 | 43879492 | MACD | 300 | 0.41
- 13 | 10261074 | EMA | 357 | 0.58
- 14 | 67890144 | MACD | 111 | 0.55
- 15 | 36000132 | MACD | 400 | 1.3
- 16 | 18671507 | MA | 250 | 0.62
- 17 | 43103084 | MACD | 138 | 0.63
- 18 | 44765541 | EMA | 360 | 2.95
- 19 | 54120484 | EMA | 152 | 0.52
- 20 | 75780831 | MA | 392 | 0.41
- 21 | 48176117 | MA | 364 | 0.49
- 22 | 15239669 | EMA | 43 | 0.1
- 23 | 80009246 | MA | 417 | 0.84
- 24 | 40373240 | MA | 324 | 1.06
- 25 | 45303397 | EMA | 266 | 0.36
- 26 | 43624413 | MACD | 468 | 1.01
- 27 | 35078677 | MACD | 440 | 0.47
- 28 | 22813025 | MACD | 404 | 0.75
- 29 | 22482625 | MACD | 254 | 0.41
- 30 | 98913453 | MA | 381 | 4.19
- 31 | 85489760 | EMA | 341 | 2.02
- 32 | 10024417 | MACD | 490 | 0.66
- 33 | 71465933 | EMA | 430 | 0.62
- 34 | 39544425 | EMA | 95 | 0.15
- 35 | 55174011 | EMA | 163 | 0.17
- 36 | 40178542 | EMA | 170 | 0.25
- 37 | 17361241 | MA | 469 | 0.73
- 38 | 12071060 | EMA | 104 | 0.14
- 39 | 72470978 | MA | 155 | 0.3
- 40 | 73537425 | EMA | 271 | 0.34
- 41 | 98264677 | MA | 220 | 2.75
- 42 | 68888871 | MACD | 93 | 0.1
- 43 | 44109134 | MA | 165 | 0.7
- 44 | 26272333 | MACD | 114 | 0.58
- 45 | 41996179 | MA | 329 | 0.91
- 46 | 81840753 | MA | 202 | 0.37
- 47 | 78259302 | MA | 229 | 0.3
- 48 | 37413247 | EMA | 29 | 0.08
- 49 | 76114848 | EMA | 491 | 1.42
- 50 | 94946974 | MA | 22 | 0.18
- 51 | 35322809 | MA | 373 | 2.94
- 52 | 46769441 | MACD | 222 | 0.27
- 53 | 10882039 | EMA | 464 | 1.46
- 54 | 38138146 | EMA | 154 | 1.18
- 55 | 34851131 | MACD | 136 | 0.2
- 56 | 77384464 | EMA | 199 | 0.36
- 57 | 31761589 | MACD | 12 | 0.02
- 58 | 74520655 | EMA | 157 | 1.22
- 59 | 23257515 | MA | 460 | 9.2
- 60 | 41418943 | EMA | 435 | 0.91
- 61 | 87781733 | MACD | 137 | 0.52
- 62 | 45211681 | MACD | 373 | 0.43
- 63 | 20692531 | EMA | 160 | 0.29
- 64 | 32277339 | EMA | 367 | 1.93
- 65 | 23330230 | MA | 358 | 0.4
- 66 | 88961232 | MACD | 137 | 0.74
- 67 | 75855038 | MA | 285 | 0.69
- 68 | 93813942 | MACD | 488 | 1.02
- 69 | 99785124 | MACD | 480 | 0.87
- 70 | 89509410 | MA | 51 | 0.12
- 71 | 86145138 | MACD | 218 | 0.74
- 72 | 42730702 | MACD | 291 | 0.3
- 73 | 33932851 | MACD | 30 | 0.04
- 74 | 55132798 | MA | 488 | 0.65
- 75 | 23878264 | EMA | 101 | 0.41
- 76 | 39385718 | EMA | 361 | 0.38
- 77 | 36736943 | MACD | 413 | 0.5
- 78 | 27000929 | MA | 494 | 2.26
- 79 | 81953838 | EMA | 111 | 0.36
- 80 | 33214256 | EMA | 39 | 0.16
- 81 | 86055908 | MACD | 261 | 0.73
- 82 | 10727013 | MACD | 25 | 0.14
- 83 | 94068967 | EMA | 463 | 0.79
- 84 | 81853070 | EMA | 184 | 0.28
- 85 | 26116336 | MACD | 12 | 0.01
- 86 | 77657124 | MA | 371 | 0.5
- 87 | 85437276 | MA | 393 | 0.76
- 88 | 63792564 | MA | 260 | 0.28
- 89 | 44576815 | EMA | 423 | 0.49
- 90 | 68409329 | EMA | 30 | 0.28
- 91 | 69295974 | MA | 102 | 0.4
- 92 | 99459510 | MACD | 469 | 0.71
- 93 | 80664246 | MA | 478 | 3.82
- 94 | 15001384 | MACD | 253 | 0.29
- 95 | 83763855 | MA | 45 | 0.05
- 96 | 61634064 | EMA | 415 | 0.62
- 97 | 67561289 | MA | 433 | 0.6
- 98 | 24020445 | EMA | 208 | 0.31
- 99 | 25200517 | MACD | 280 | 0.37
- 100 | 16075989 | MA | 225 | 0.66
- 101 | 39577549 | MA | 81 | 0.12
- 102 | 85605425 | MACD | 127 | 0.34
- 103 | 28224570 | MA | 119 | 0.16
- 104 | 39647806 | EMA | 293 | 0.56
- 105 | 43862531 | MACD | 498 | 1.6
- 106 | 41568342 | MA | 211 | 0.72
- 107 | 21017836 | EMA | 479 | 0.91
- 108 | 87064774 | MA | 484 | 0.72
- 109 | 47931421 | EMA | 126 | 0.18
- 110 | 17760267 | MACD | 327 | 0.69
- 111 | 72523784 | MACD | 490 | 0.51
- 112 | 75569379 | MA | 300 | 0.38
- 113 | 31804518 | MACD | 146 | 0.23
- 114 | 68920497 | MA | 376 | 0.6
- 115 | 27089700 | MA | 12 | 0.05
- 116 | 86008993 | MA | 162 | 0.58
- 117 | 62499016 | MA | 270 | 1.24
- 118 | 28386102 | EMA | 444 | 4.67
- 119 | 24102766 | EMA | 34 | 0.19
- 120 | 85214782 | MA | 409 | 0.46
- 121 | 55079251 | MA | 401 | 1.67
- 122 | 81187840 | MACD | 140 | 0.24
- 123 | 33492007 | MA | 231 | 0.28
- 124 | 69027212 | EMA | 332 | 0.44
- 125 | 59127614 | EMA | 426 | 0.59
- 126 | 73825751 | EMA | 323 | 0.37
- 127 | 15501502 | MA | 100 | 0.31
- 128 | 95891420 | MA | 368 | 0.78
- 129 | 84367237 | MACD | 363 | 1.58
- 130 | 86419572 | MACD | 479 | 1.79
- 131 | 61789471 | MACD | 260 | 0.57
- 132 | 25431737 | MA | 331 | 2.18
- 133 | 72991891 | EMA | 201 | 0.33
- 134 | 51928528 | MA | 176 | 0.25
- 135 | 11052065 | EMA | 347 | 0.84
- 136 | 38682229 | MA | 260 | 2.36
- 137 | 91048244 | MACD | 343 | 0.94
- 138 | 70482253 | MA | 27 | 0.03
- 139 | 56355604 | MA | 250 | 0.32
- 140 | 50042533 | MA | 336 | 0.54
- 141 | 89489390 | MA | 117 | 0.13
- 142 | 55144980 | MA | 163 | 0.44
- 143 | 31524819 | MA | 10 | 0.02
- 144 | 26463966 | MACD | 84 | 0.25
- 145 | 20612515 | MA | 400 | 0.55
- 146 | 75568018 | MA | 263 | 0.51
- 147 | 96086894 | MA | 103 | 0.11
- 148 | 72158391 | EMA | 101 | 0.21
- 149 | 52642057 | MA | 367 | 0.93
- 150 | 54016580 | EMA | 164 | 0.58
- 151 | 56292227 | MA | 384 | 1.59
- 154 | 31794865 | EMA | 274 | 0.47
- 165 | 11257288 | MA | 285 | 1.9
- 168 | 69576377 | MA | 409 | 0.89
- 172 | 74649778 | MACD | 186 | 1.03
- 179 | 23957759 | MA | 372 | 0.68
Add Comment
Please, Sign In to add comment