CROP icon indicating copy to clipboard operation
CROP copied to clipboard

Deal with "deleted" flag for batches in GrowApp data

Open nbarlowATI opened this issue 2 years ago • 0 comments

Starting soon, the GrowApp data will have a new column, "deleted", in the "batch" table. We will want to check that any batches we report have this flag as false, and that any batch events we report have the associated batch with this flag as false.

Possible way of dealing with this:

  • We add a "deleted" column to our "batch" column in the CROP database, initially with default value "false".
  • We replace "on_conflict_do_nothing" with "on_conflict_do_update" in ingress_growapp.py line 493.
  • Add a query in queries.py to filter on this flag.

nbarlowATI avatar Jan 10 '23 11:01 nbarlowATI