• Joined on 2019-12-31
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
pt pushed to multi_date at pt/pivot_forecast 2020-11-10 01:23:17 -05:00
30570531ad status update
pt pushed to master at pt/pivot_forecast 2020-11-10 01:20:22 -05:00
a0f78af496 functional but only 10k rows something wrong
8f877450c4 get rid of named dollar quotes, and setup json array to hold list of date functions
1deab0fd96 target fc.live as the sales data. splice in the table joins however many date based function there are
Compare 3 commits »
pt pushed to master at pt/pivot_forecast 2020-11-10 01:20:07 -05:00
f382d256ed add some notes about the dating conundrum
pt pushed to multi_date at pt/pivot_forecast 2020-11-10 01:12:55 -05:00
a0f78af496 functional but only 10k rows something wrong
8f877450c4 get rid of named dollar quotes, and setup json array to hold list of date functions
1deab0fd96 target fc.live as the sales data. splice in the table joins however many date based function there are
Compare 3 commits »
pt pushed to multi_date at pt/pivot_forecast 2020-11-09 23:21:17 -05:00
f382d256ed add some notes about the dating conundrum
pt pushed to master at pt/pivot_forecast 2020-11-09 23:04:02 -05:00
7e3354824c forgot the commas
pt pushed to master at pt/pivot_forecast 2020-11-09 13:16:20 -05:00
17895dc443 MIT license
pt pushed to master at pt/pivot_forecast 2020-11-08 22:44:29 -05:00
9e37284305 update problems, and remove old files