• Joined on 2019-12-31
pt pushed to folders at pt/pivot_forecast 2020-11-28 03:00:30 -05:00
0415dad1f2 start working on scale route, note encountered issues
pt pushed to folders at pt/pivot_forecast 2020-11-28 02:18:08 -05:00
e33633db5f statr working on a scale route
08aa6ad678 update request body location
Compare 2 commits »
pt pushed to folders at pt/pivot_forecast 2020-11-27 20:40:51 -05:00
c6bf867ffc move functional pieces into their own folders
pt pushed to master at pt/pivot_forecast 2020-11-27 11:41:52 -05:00
a9b1523f93 get rid of old routes and update readme to reflect sql parameterizaion
pt pushed to master at pt/pivot_forecast 2020-11-27 11:32:12 -05:00
83a936d324 include script for self-signed cert
pt pushed to master at pt/node_postgres 2020-11-27 02:55:23 -05:00
9c634ce6d4 update cert script
763307938d script to build self signed certs
25ad266aef include test route, env reference, and self signed certs
8f7f387729 link in additional modules
eff31d5a72 sane format as forecast project
pt created repository pt/node_postgres 2020-11-27 02:54:55 -05:00
pt pushed to master at pt/pivot_forecast 2020-11-27 02:31:39 -05:00
31c6390617 if multiple result sets are involved then res is an array, specificy second result set
pt pushed to master at pt/pivot_forecast 2020-11-27 02:24:25 -05:00
3b3a2f7b39 return count of inserted rows
pt pushed to master at pt/pivot_forecast 2020-11-27 01:35:08 -05:00
bceac1d195 update packages.json, was using old modules and no longer connecting to db. and move parameter extracion sql
pt pushed to master at pt/pivot_forecast 2020-11-26 01:30:48 -05:00
32c7895157 notes on script and add sample env
pt pushed to master at pt/pivot_forecast 2020-11-24 01:34:14 -05:00
3626a2d7e6 status update
pt pushed to master at pt/pivot_forecast 2020-11-24 01:24:12 -05:00
e54e2eb05c push the items from the request body into the variables, and then from there into the sql
078d8294c4 quick notes on what the mappings are for
39a8454b0e name the column after incrementing, put variables in single quotes, move the final filter to another layer
4ed3f11bd8 adjust dates on the sample request
624ffca813 comment the header out
Compare 5 commits »
pt pushed to master at pt/pivot_forecast 2020-11-22 23:16:12 -05:00
994a1027df push arguments into variables and swap out with sql statement position
c16e8939e9 remove duplicates
Compare 2 commits »
pt pushed to master at pt/pivot_forecast 2020-11-17 08:42:41 -05:00
663e5d3de5 adjust the regex to exclude brackets not behaving as expected. req.send to send the sql back as text
pt pushed to master at pt/pivot_forecast 2020-11-12 00:22:03 -05:00
90d62a2bb0 start working on parameterizing the baseline route
pt pushed to master at pt/pivot_forecast 2020-11-12 00:05:21 -05:00
4a04a81241 get the baseline route pulling the sql from a simple curl for testing
2918c4c37a environment stuff
d4d2f48d52 include node project
d399ce61d8 node ignore
Compare 4 commits »
pt pushed to master at pt/pivot_forecast 2020-11-11 23:38:47 -05:00
6358bbae14 pull intedned parameters from sql
pt deleted branch multi_date from pt/pivot_forecast 2020-11-10 01:24:00 -05:00
pt pushed to master at pt/pivot_forecast 2020-11-10 01:23:34 -05:00
30570531ad status update