CROP
CROP copied to clipboard
Deal with "deleted" flag for batches in GrowApp data
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.pyline 493. - Add a query in
queries.pyto filter on this flag.