search

JCKalt / General-Work

Modeling database
0 stars 0 forks source link

Create Spreadsheet for Dean to show Jerry #169

Open JCKalt opened 3 months ago

JCKalt commented 3 months ago

Under $(gg prlx) created src/xfer-live-serial-uid.py which:

  1. Collects and transfers DynamoDB purify-{device_type}-devie data into a single PostGreSQL live_serial_uidtable called live_serial_uid.
  2. It the generates a CSV export of a UNION of two select sets. type == "LIVE" outer joins to the pg table serial_number. type == "INV" represent rows from serial_number that fail to join to the first UNION. These all are missing the UID.