Commit Graph

45 Commits

Author SHA1 Message Date
Paul Trowbridge 9265777caf comment out https for now 2022-05-12 00:52:00 -04:00
Paul Trowbridge 08cba77728 show the number if impacted rows instead of returning nothing 2022-05-12 00:17:31 -04:00
Paul Trowbridge 9e381f7d78 refactor work 2022-05-06 23:07:42 -04:00
Paul Trowbridge a8a14dda2b dont deposit files 2022-04-28 01:17:08 -04:00
Paul Trowbridge 4128e12848 move scale route sql to setup 2022-04-28 01:13:13 -04:00
Paul Trowbridge d0ea91d985 move folder 2022-04-28 01:10:35 -04:00
Paul Trowbridge 4dd71057f4 move baseline route sql to table only mode 2022-04-28 01:09:26 -04:00
Paul Trowbridge bde86fd3eb have the insert return rows; also need to deal with multiple result sets in index.js 2022-04-22 01:15:51 -04:00
Paul Trowbridge d47b00b5cd turn on sql execution for scale route, but not working 2022-04-22 00:22:35 -04:00
Paul Trowbridge 9c6ed6b304 baseline functional, but json doesn't look correct in fc.log or the sql 2022-04-13 01:34:54 -04:00
Paul Trowbridge a0fb500f29 rework baseline, previously assumed ordinal position of version and iter columns, also include a log record 2022-04-13 01:17:04 -04:00
Paul Trowbridge 80bcb23170 update readme 2022-04-12 23:31:31 -04:00
Paul Trowbridge d35bc49f6f update readme, get rid of old file 2022-04-12 23:29:05 -04:00
Paul Trowbridge 95675428a4 do rounding 2022-04-12 02:30:26 -04:00
Paul Trowbridge d5c2980bb1 isolate price change on no volume adjustment 2022-04-12 02:09:36 -04:00
Paul Trowbridge 0e904c1631 temp price factor 2022-04-12 01:58:52 -04:00
Paul Trowbridge 959d858b10 setup from dcard to test with 2022-04-09 02:29:51 -04:00
Paul Trowbridge 342e0824c5 mising pieces 2022-04-09 02:28:53 -04:00
Paul Trowbridge b17c37788e include forecast name 2022-04-09 02:26:38 -04:00
Paul Trowbridge 8f2a7431bc comment out the raise notice debug items 2022-04-06 23:34:00 -04:00
Paul Trowbridge aa4d6fb7f0 dates can't have foriegn key, need to operate off appcol and func. 2022-04-06 02:32:20 -04:00
Paul Trowbridge 57051675b3 add dynamic target table; dynamically create additional columns if application columns were not defined 2022-04-06 01:52:18 -04:00
Paul Trowbridge 00c8a063cd get rid of temporary output 2022-04-05 23:08:29 -04:00
Paul Trowbridge 66813bb156 use the actual column name 2022-04-05 20:58:22 -04:00
Paul Trowbridge c97e92f3bc remove single quotes from open order status since they shoudl be supplied by the request, and couple more quoted identifiers 2022-04-03 01:18:14 -04:00
Paul Trowbridge 53523eb330 get rid of sql table creation here, all column references should be formatted as quote itentifieds format('%I) 2022-04-03 00:49:54 -04:00
Paul Trowbridge 6462e742d9 fc.sql table is still missing from initial schema setup, shoudl be fc.sql (cmd, t) 2022-04-01 16:29:36 -04:00
Paul Trowbridge 59ffe255cc rename curl 2020-12-12 09:31:20 -05:00
Paul Trowbridge 4cda3c3924 get rid of temporary file to test speed of initial baseline filter 2020-12-12 09:29:06 -05:00
Paul Trowbridge 028bda6c26 start working on integrating logging 2020-12-08 01:30:02 -05:00
Paul Trowbridge b9a2d9d8fc add version and inter, SQL works fine 2020-12-08 01:13:31 -05:00
Paul Trowbridge 27e65c10a6 change up test scenario, sql is running, need to validate and add version info 2020-12-08 00:59:54 -05:00
Paul Trowbridge 1d6317df1e use target cte to hold targets instead of build sql in node 2020-12-08 00:49:04 -05:00
Paul Trowbridge 33f5453671 move curl output to temp tagged file and exclude them from the project 2020-12-08 00:26:29 -05:00
Paul Trowbridge 78a766cb86 point curl to current directory target 2020-12-08 00:24:29 -05:00
Paul Trowbridge b791aff0af change target paths and files, update readme for current state 2020-12-07 20:44:16 -05:00
Paul Trowbridge 3e94851aea work on getting errors out 2020-12-05 01:19:17 -05:00
Paul Trowbridge cb5a1dc6b5 get scale route roughed in a building sql along with new where clause function 2020-12-05 00:10:47 -05:00
Paul Trowbridge f8b7776f8e build out pricing piece 2020-12-02 02:41:34 -05:00
Paul Trowbridge 10d99668c0 do the volume scale on the basemix 2020-12-02 02:05:40 -05:00
Paul Trowbridge 5adda41727 work on scale; populate meta info into local variables, build column list, create baseline scaling factor 2020-12-02 01:51:15 -05:00
Paul Trowbridge 0415dad1f2 start working on scale route, note encountered issues 2020-11-28 03:00:23 -05:00
Paul Trowbridge e33633db5f statr working on a scale route 2020-11-28 02:17:53 -05:00
Paul Trowbridge 08aa6ad678 update request body location 2020-11-28 01:33:11 -05:00
Paul Trowbridge c6bf867ffc move functional pieces into their own folders 2020-11-27 20:40:34 -05:00