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.
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:
ingress_growapp.pyline 493.queries.pyto filter on this flag.