Commit Graph

Select branches

Hide Pull Requests

master

nofile

refactor

Mono Color

• 2605a1002f include target forecst table in the api request body nofile Paul Trowbridge 2022-05-13 13:36:23 -0400
• 898593c3a8 put sample data table in separate file and use target table in new table creation Paul Trowbridge 2022-05-13 13:35:50 -0400
• 4ae9a5becd add target table to sql table, and change path of curl json request Paul Trowbridge 2022-05-12 22:59:37 -0400
• 04f774027d pull sql from db instead of local file Paul Trowbridge 2022-05-12 01:33:32 -0400
• 9265777caf comment out https for now master Paul Trowbridge 2022-05-12 00:52:00 -0400
• db3b267657 create local variables in build where and return as newly named refactor Paul Trowbridge 2022-05-12 00:27:31 -0400
• 08cba77728 show the number if impacted rows instead of returning nothing Paul Trowbridge 2022-05-12 00:17:31 -0400
• 9e381f7d78 refactor work Paul Trowbridge 2022-05-06 23:07:42 -0400
• a8a14dda2b dont deposit files Paul Trowbridge 2022-04-28 01:17:08 -0400
• 4128e12848 move scale route sql to setup Paul Trowbridge 2022-04-28 01:13:13 -0400
• d0ea91d985 move folder Paul Trowbridge 2022-04-28 01:10:35 -0400
• 4dd71057f4 move baseline route sql to table only mode Paul Trowbridge 2022-04-28 01:09:26 -0400
• 60f881a535 notes on issues; grant schema usage Paul Trowbridge 2022-04-28 01:04:54 -0400
• 9356081662 only create foreign tables where the foreign key is not a date Paul Trowbridge 2022-04-28 00:51:21 -0400
• a5d9c1d145 update file names Paul Trowbridge 2022-04-27 22:42:35 -0400
• 2f10d46806 a foreign table is built for any func populated even if a date Paul Trowbridge 2022-04-26 22:50:59 -0400
• 0b5ee0bdf3 handled a returned array as opposed to a returned object Paul Trowbridge 2022-04-22 23:35:48 -0400
• 3d9bc487ba upgrade Paul Trowbridge 2022-04-22 01:16:01 -0400
• bde86fd3eb have the insert return rows; also need to deal with multiple result sets in index.js Paul Trowbridge 2022-04-22 01:15:51 -0400
• d47b00b5cd turn on sql execution for scale route, but not working Paul Trowbridge 2022-04-22 00:22:35 -0400
• 2531914387 issues addressed Paul Trowbridge 2022-04-13 01:36:31 -0400
• 9c6ed6b304 baseline functional, but json doesn't look correct in fc.log or the sql Paul Trowbridge 2022-04-13 01:34:54 -0400
• a0fb500f29 rework baseline, previously assumed ordinal position of version and iter columns, also include a log record Paul Trowbridge 2022-04-13 01:17:04 -0400
• 64af23cf04 do a merge instead of an insert Paul Trowbridge 2022-04-13 01:15:40 -0400
• d77b7910d5 notes on issues Paul Trowbridge 2022-04-13 01:15:07 -0400
• 298e2fdc4e notes on column purpose Paul Trowbridge 2022-04-12 23:54:03 -0400
• 80bcb23170 update readme Paul Trowbridge 2022-04-12 23:31:31 -0400
• d35bc49f6f update readme, get rid of old file Paul Trowbridge 2022-04-12 23:29:05 -0400
• 8bda52f770 get rid of clone files; move mapping to readme; rename setup to sequence the operations Paul Trowbridge 2022-04-12 22:58:31 -0400
• d0a4f8324d move perd table to schema setup Paul Trowbridge 2022-04-12 22:54:54 -0400
• a657106bf5 use proper data type for app columns, include master table for app columns Paul Trowbridge 2022-04-12 22:52:42 -0400
• b47630cf61 include files from iter branch; need to be reviewed Paul Trowbridge 2022-04-12 12:48:05 -0400
• 95675428a4 do rounding Paul Trowbridge 2022-04-12 02:30:26 -0400
• d5c2980bb1 isolate price change on no volume adjustment Paul Trowbridge 2022-04-12 02:09:36 -0400
• 0e904c1631 temp price factor Paul Trowbridge 2022-04-12 01:58:52 -0400
• 959d858b10 setup from dcard to test with Paul Trowbridge 2022-04-09 02:29:51 -0400
• 342e0824c5 mising pieces Paul Trowbridge 2022-04-09 02:28:53 -0400
• a29e5e54f3 include application column list Paul Trowbridge 2022-04-09 02:28:00 -0400
• 4f9667b553 build a volume column if it's missing Paul Trowbridge 2022-04-09 02:27:35 -0400
• b17c37788e include forecast name Paul Trowbridge 2022-04-09 02:26:38 -0400
• 8f2a7431bc comment out the raise notice debug items Paul Trowbridge 2022-04-06 23:34:00 -0400
• aa4d6fb7f0 dates can't have foriegn key, need to operate off appcol and func. Paul Trowbridge 2022-04-06 02:32:20 -0400
• 57051675b3 add dynamic target table; dynamically create additional columns if application columns were not defined Paul Trowbridge 2022-04-06 01:52:18 -0400
• 00c8a063cd get rid of temporary output Paul Trowbridge 2022-04-05 23:08:29 -0400
• 1c28831f1e ? Paul Trowbridge 2022-04-05 23:08:06 -0400
• 66813bb156 use the actual column name Paul Trowbridge 2022-04-05 20:58:22 -0400
• c97e92f3bc remove single quotes from open order status since they shoudl be supplied by the request, and couple more quoted identifiers Paul Trowbridge 2022-04-03 01:18:14 -0400
• a859ffa91a create schema and sql table Paul Trowbridge 2022-04-03 00:50:49 -0400
• 53523eb330 get rid of sql table creation here, all column references should be formatted as quote itentifieds format('%I) Paul Trowbridge 2022-04-03 00:49:54 -0400
• d1371bcdce update readme to create more of a checklist Paul Trowbridge 2022-04-03 00:48:29 -0400
• 6462e742d9 fc.sql table is still missing from initial schema setup, shoudl be fc.sql (cmd, t) Paul Trowbridge 2022-04-01 16:29:36 -0400
• 59ffe255cc rename curl Paul Trowbridge 2020-12-12 09:31:20 -0500
• 4cda3c3924 get rid of temporary file to test speed of initial baseline filter Paul Trowbridge 2020-12-12 09:29:06 -0500
• 028bda6c26 start working on integrating logging Paul Trowbridge 2020-12-08 01:30:02 -0500
• 40ccaefbc8 update status Paul Trowbridge 2020-12-08 01:14:52 -0500
• b9a2d9d8fc add version and inter, SQL works fine Paul Trowbridge 2020-12-08 01:13:31 -0500
• 6166e49a23 additional notes on status Paul Trowbridge 2020-12-08 01:06:06 -0500
• ae549c84f1 update readme for current status Paul Trowbridge 2020-12-08 01:02:50 -0500
• 27e65c10a6 change up test scenario, sql is running, need to validate and add version info Paul Trowbridge 2020-12-08 00:59:54 -0500
• 1d6317df1e use target cte to hold targets instead of build sql in node Paul Trowbridge 2020-12-08 00:49:04 -0500
• 33f5453671 move curl output to temp tagged file and exclude them from the project Paul Trowbridge 2020-12-08 00:26:29 -0500
• 78a766cb86 point curl to current directory target Paul Trowbridge 2020-12-08 00:24:29 -0500
• 84c556e40d format for current item Paul Trowbridge 2020-12-07 20:48:56 -0500
• b791aff0af change target paths and files, update readme for current state Paul Trowbridge 2020-12-07 20:44:16 -0500
• 3e94851aea work on getting errors out Paul Trowbridge 2020-12-05 01:19:17 -0500
• cb5a1dc6b5 get scale route roughed in a building sql along with new where clause function Paul Trowbridge 2020-12-05 00:10:47 -0500
• 756aea1385 notes on scale oute Paul Trowbridge 2020-12-02 02:44:12 -0500
• f8b7776f8e build out pricing piece Paul Trowbridge 2020-12-02 02:41:34 -0500
• 10d99668c0 do the volume scale on the basemix Paul Trowbridge 2020-12-02 02:05:40 -0500
• 5adda41727 work on scale; populate meta info into local variables, build column list, create baseline scaling factor Paul Trowbridge 2020-12-02 01:51:15 -0500
• 998413e391 bold larger issues Paul Trowbridge 2020-12-02 01:50:19 -0500
• 0415dad1f2 start working on scale route, note encountered issues Paul Trowbridge 2020-11-28 03:00:23 -0500
• e33633db5f statr working on a scale route Paul Trowbridge 2020-11-28 02:17:53 -0500
• 08aa6ad678 update request body location Paul Trowbridge 2020-11-28 01:33:11 -0500
• c6bf867ffc move functional pieces into their own folders Paul Trowbridge 2020-11-27 20:40:34 -0500
• a9b1523f93 get rid of old routes and update readme to reflect sql parameterizaion Paul Trowbridge 2020-11-27 11:41:47 -0500
• 83a936d324 include script for self-signed cert Paul Trowbridge 2020-11-27 11:32:08 -0500
• 31c6390617 if multiple result sets are involved then res is an array, specificy second result set Paul Trowbridge 2020-11-27 02:31:30 -0500
• 3b3a2f7b39 return count of inserted rows Paul Trowbridge 2020-11-27 02:24:20 -0500
• bceac1d195 update packages.json, was using old modules and no longer connecting to db. and move parameter extracion sql Paul Trowbridge 2020-11-27 01:35:00 -0500
• 32c7895157 notes on script and add sample env Paul Trowbridge 2020-11-26 01:30:40 -0500
• 3626a2d7e6 status update Paul Trowbridge 2020-11-24 01:34:10 -0500
• e54e2eb05c push the items from the request body into the variables, and then from there into the sql Paul Trowbridge 2020-11-24 01:24:06 -0500
• 078d8294c4 quick notes on what the mappings are for Paul Trowbridge 2020-11-24 01:23:02 -0500
• 39a8454b0e name the column after incrementing, put variables in single quotes, move the final filter to another layer Paul Trowbridge 2020-11-24 01:22:46 -0500
• 4ed3f11bd8 adjust dates on the sample request Paul Trowbridge 2020-11-24 01:21:43 -0500
• 624ffca813 comment the header out Paul Trowbridge 2020-11-24 01:21:29 -0500
• 994a1027df push arguments into variables and swap out with sql statement position Paul Trowbridge 2020-11-22 23:15:50 -0500
• c16e8939e9 remove duplicates Paul Trowbridge 2020-11-21 01:51:11 -0500
• 663e5d3de5 adjust the regex to exclude brackets not behaving as expected. req.send to send the sql back as text Paul Trowbridge 2020-11-17 08:42:35 -0500
• 90d62a2bb0 start working on parameterizing the baseline route Paul Trowbridge 2020-11-12 00:22:00 -0500
• 4a04a81241 get the baseline route pulling the sql from a simple curl for testing Paul Trowbridge 2020-11-12 00:05:11 -0500
• 2918c4c37a environment stuff Paul Trowbridge 2020-11-11 23:45:04 -0500
• d4d2f48d52 include node project Paul Trowbridge 2020-11-11 23:39:26 -0500
• d399ce61d8 node ignore Paul Trowbridge 2020-11-11 23:39:10 -0500
• 6358bbae14 pull intedned parameters from sql Paul Trowbridge 2020-11-11 23:38:44 -0500
• 30570531ad status update Paul Trowbridge 2020-11-10 01:23:13 -0500
• a0f78af496 functional but only 10k rows something wrong Paul Trowbridge 2020-11-10 01:12:17 -0500
• 8f877450c4 get rid of named dollar quotes, and setup json array to hold list of date functions Paul Trowbridge 2020-11-10 00:29:57 -0500
• 1deab0fd96 target fc.live as the sales data. splice in the table joins however many date based function there are Paul Trowbridge 2020-11-09 23:45:18 -0500