Commit Graph

  • 7a516d7a24 Merge branch 'j_constr' into key_log Paul Trowbridge 2018-03-13 00:28:04 -0400
  • ac2024de8c include original recs with unique maps Paul Trowbridge 2018-03-10 14:04:51 -0500
  • 484a41a9b3 fix example mapping to exclude filters Paul Trowbridge 2018-03-10 14:03:52 -0500
  • 8e4ba4ef28 Merge branch 'master' into key_log Paul Trowbridge 2018-03-10 02:30:41 -0500
  • 9403e55c73 Merge branch 'master' into j_constr Paul Trowbridge 2018-03-10 02:27:28 -0500
  • 3e970c65e2 2 lines Paul Trowbridge 2018-03-10 02:27:19 -0500
  • 3acfc908b7 resolve merge from master Paul Trowbridge 2018-03-10 02:25:13 -0500
  • e00e682f02 get rid of wmpd Paul Trowbridge 2018-03-10 02:20:55 -0500
  • c4dcb6edc8 resolve merge Paul Trowbridge 2018-03-10 02:16:17 -0500
  • b190a39a8d resolver merge conflict Paul Trowbridge 2018-03-10 02:14:33 -0500
  • b65174a24f Merge branch 'master' into j_constr Paul Trowbridge 2018-03-10 02:09:04 -0500
  • 3ea353a588 get rid of dcard2 Paul Trowbridge 2018-03-10 02:02:38 -0500
  • 15349d2b1a push constraint to seperate column Paul Trowbridge 2018-03-10 01:58:43 -0500
  • 5dd2091752 remove create table Paul Trowbridge 2018-03-10 01:47:26 -0500
  • 15e5001a89 add in the rest of the body Paul Trowbridge 2018-03-10 01:41:39 -0500
  • a1123efa40 add dev file for source import to dynamically run sql Paul Trowbridge 2018-03-10 01:12:18 -0500
  • f07f47ca32
    Update readme.md fleetside72 2018-03-09 11:34:30 -0500
  • b6f14286d1 git rid of WMPD map Paul Trowbridge 2018-03-08 01:54:16 -0500
  • 2555e14b74 contrain element defined, need to determine where to put it on insert Paul Trowbridge 2018-03-08 01:50:57 -0500
  • 38ac338637 only first element of text array was being used for the json key Paul Trowbridge 2018-03-08 01:42:26 -0500
  • cce644740d update srce_set to take a singluar json as argument Paul Trowbridge 2018-03-07 00:44:19 -0500
  • 2242e80e3a Merge branch 'master' of https://github.com/fleetside72/tps_etl Paul Trowbridge 2018-03-06 17:48:55 -0500
  • 0992b00e92 rename and change to json, remove sql Paul Trowbridge 2018-03-06 17:48:28 -0500
  • 0fbde23da5 Merge branch 'master' into key_log Paul Trowbridge 2018-03-06 00:38:06 -0500
  • c00a2ed994
    Merge pull request #14 from fleetside72/update_docs fleetside72 2018-03-06 00:36:50 -0500
  • fb1d1218b3 Merge branch 'update_docs' into key_log Paul Trowbridge 2018-03-06 00:34:55 -0500
  • 0badc9f403 add interaction details Paul Trowbridge 2018-03-06 00:28:37 -0500
  • ff18ce5bd3 simplify readme Paul Trowbridge 2018-03-05 23:34:53 -0500
  • 204afa8643
    Merge pull request #13 from fleetside72/import_error fleetside72 2018-03-05 22:41:54 -0500
  • ea217e9c14 update import function to trap all error at the end Paul Trowbridge 2018-03-05 22:12:31 -0500
  • ad4234967d Merge branch 'master' into key_log Paul Trowbridge 2018-03-05 00:18:37 -0500
  • 41b9aaeb6f
    Merge pull request #11 from fleetside72/map_trigger fleetside72 2018-03-05 00:10:25 -0500
  • 43d5e66b61 include schema dump for new trigger Paul Trowbridge 2018-03-05 00:07:09 -0500
  • cc244ee9f7 initial trigger work Paul Trowbridge 2018-03-04 23:57:59 -0500
  • 80fe3053c3 add some notes on approach Paul Trowbridge 2018-03-03 12:17:22 -0500
  • 52c696f199 list all keys and types Paul Trowbridge 2018-03-03 12:07:05 -0500
  • de2aac8d23 list out columns Paul Trowbridge 2018-03-03 11:52:34 -0500
  • 6556cce5c6
    Merge pull request #5 from fleetside72/map_set fleetside72 2018-03-03 11:50:48 -0500
  • 506cc5ebf5 create function to insert many updates from one json Paul Trowbridge 2018-03-03 11:47:31 -0500
  • 403ff88247 test expanding a single json object to full table Paul Trowbridge 2018-03-03 11:11:20 -0500
  • 19f8c3da3f add function def Paul Trowbridge 2018-03-03 10:51:45 -0500
  • 424341eabc initial cut at function to return unmapped Paul Trowbridge 2018-03-03 10:51:31 -0500
  • 0953705d19
    Merge pull request #4 from fleetside72/type_descr fleetside72 2018-03-03 09:31:29 -0500
  • 2f47875849 add description to schema and include with type creation Paul Trowbridge 2018-03-03 09:24:02 -0500
  • 74fb1b0bba rename file to match function name Paul Trowbridge 2018-03-03 08:54:33 -0500
  • a0941d6478 add table comment, index, and column Paul Trowbridge 2018-03-02 09:37:58 -0500
  • 144e18707a
    Merge pull request #3 from fleetside72/goog fleetside72 2018-03-02 01:03:59 -0500
  • dd0e7ddac9 add scenario to test storing json, exmaple google api Paul Trowbridge 2018-03-02 01:01:46 -0500
  • 78248f54d3 add insert function to sample Paul Trowbridge 2018-03-02 00:16:05 -0500
  • 63f6d7c67a get rid of empty file Paul Trowbridge 2018-03-01 23:51:16 -0500
  • e724d2802d
    Merge pull request #2 from fleetside72/pt fleetside72 2018-03-01 23:40:55 -0500
  • 296ad6da68 add new functions to overview sample document Paul Trowbridge 2018-03-01 23:39:53 -0500
  • 1a0799c785 touch up Paul Trowbridge 2018-03-01 23:35:44 -0500
  • aac83846c0 add function to redo all maps Paul Trowbridge 2018-03-01 23:35:29 -0500
  • ed7174b7bf add map value set function adn rename file Paul Trowbridge 2018-03-01 23:25:26 -0500
  • 3278a0af4d
    Merge pull request #1 from fleetside72/pt fleetside72 2018-03-01 20:40:48 -0500
  • 7a406788da include not on first getting ditinct list of item Paul Trowbridge 2018-03-01 17:23:07 -0500
  • 7f0f415ed3 link to mappings Paul Trowbridge 2018-03-01 17:22:46 -0500
  • de3219aff0 add notes and sorting Paul Trowbridge 2018-03-01 12:23:14 -0500
  • 167264779e add query to return all unique regex results of map Paul Trowbridge 2018-03-01 01:34:26 -0500
  • 314d38ba3c add function to set map Paul Trowbridge 2018-03-01 01:22:59 -0500
  • e137977e94 update srce_set to create associated type Paul Trowbridge 2018-02-27 23:18:50 -0500
  • 5e6af10c0d add to ignore Paul Trowbridge 2018-02-27 22:35:27 -0500
  • 2844ab1bc7 change extension to sql Paul Trowbridge 2018-02-27 21:58:57 -0500
  • c629a8eaf4 add git ignore Paul Trowbridge 2018-02-27 21:50:19 -0500
  • 7a8a5146ef set extensions to sql Paul Trowbridge 2018-02-27 00:18:31 -0500
  • 73db72760d refernce tps schema on UDF and fix bad function reference Paul Trowbridge 2018-02-26 23:58:21 -0500
  • 53b945ab88 add main data import function Paul Trowbridge 2018-02-26 23:45:16 -0500
  • f9f97270aa add deploy to directory Paul Trowbridge 2018-02-26 18:04:27 -0500
  • 3d828b6b55 convert to markdown table Paul Trowbridge 2018-02-26 16:50:34 -0500
  • cfab0746e7 include full sql statements Paul Trowbridge 2018-02-26 15:22:38 -0500
  • b40f3edcda create function jsonb_extract in tps schema Paul Trowbridge 2018-02-23 15:41:30 -0500
  • 4b2851a61d and srce edit function Paul Trowbridge 2018-02-23 15:11:04 -0500
  • 492e393723 only dump tps schema Paul Trowbridge 2018-02-23 14:52:02 -0500
  • 919a18f826 add screen to mapping definition Paul Trowbridge 2018-02-21 00:41:46 -0500
  • 3c0883ef03 update sample definition Paul Trowbridge 2018-02-20 23:36:45 -0500
  • 9709c3e4ad rename directory of sample Paul Trowbridge 2018-02-17 16:39:18 -0500
  • ea9b1ee538 merge c9 dump into master Paul Trowbridge 2018-02-17 14:20:30 -0500
  • 46af19368e merge c9 setup into one Paul Trowbridge 2018-02-17 14:19:49 -0500
  • 6447e445e2 add sample scenario Paul Trowbridge 2018-02-17 13:57:14 -0500
  • 11f5910739 force remap on all srce Paul Trowbridge 2018-02-17 13:56:52 -0500
  • b726c60503 convert o creat function Paul Trowbridge 2018-02-15 22:20:24 -0500
  • d51a327868 add create function scripts Paul Trowbridge 2018-02-08 17:40:23 -0500
  • dc973690cb rename and create function Paul Trowbridge 2018-02-07 17:36:24 -0500
  • 4e1cc79fb4 rename and exclude data component Paul Trowbridge 2018-02-05 23:30:24 -0500
  • 7328e23ae3 drop old map function Paul Trowbridge 2018-02-05 23:21:40 -0500
  • 4b7a7ee4b7 put stuff in folders, delete a couple more Paul Trowbridge 2018-02-05 23:18:27 -0500
  • de095017b1 drop bunch of fiels Paul Trowbridge 2018-02-05 23:04:36 -0500
  • 545ba4e2b5 merge wk Paul Trowbridge 2018-02-05 22:54:26 -0500
  • 9a8a38b11e update readme Paul Trowbridge 2018-02-02 17:34:10 -0500
  • 7976d6b807 add ignore Paul Trowbridge 2018-02-02 09:37:35 -0500
  • c97c3a32e3 Merge branch 'pt' Paul Trowbridge 2017-11-04 09:53:21 -0400
  • 9022affcc7 add some info queries - listing of maps, and items not mapped Paul Trowbridge 2017-11-04 09:52:40 -0400
  • 9323f4cad2 Merge branch 'pt' Paul Trowbridge 2017-11-04 09:33:32 -0400
  • 175b7a38c5 merge wk branch concept of placing the mapping instructions in the regex items themselves Paul Trowbridge 2017-11-04 09:33:16 -0400
  • f6e418c8a0 Merge branch 'pt' Paul Trowbridge 2017-11-04 09:19:27 -0400
  • 706fcd8c9c all gl entries Paul Trowbridge 2017-11-04 09:18:53 -0400
  • 6feb5fb0e9 update item tab to call the newly created function that builds a json from a base json Paul Trowbridge 2017-11-03 01:05:21 -0400
  • a013697a4c add function to build a basic entry with an offset for each item of a header Paul Trowbridge 2017-11-02 23:51:04 -0400
  • 53bc59a4cb add query to give items that have no map but are supposed to be mapped Paul Trowbridge 2017-11-02 15:07:47 -0400