The ethica ingest pipeline fails if there are no "cull" records. This is due to the SQL snippets assuming that there will be culled records, using piecemeal constructions such as f"""[...] WHERE user_id IN {tuple(culled)} AND [...]""", where culled is an empty list.
There are several such constructions that need to be fixed, and they aren't limited to "cull" records but other similar empty lists.
The ethica ingest pipeline fails if there are no "cull" records. This is due to the SQL snippets assuming that there will be culled records, using piecemeal constructions such as
f"""[...] WHERE user_id IN {tuple(culled)} AND [...]""", whereculledis an empty list.There are several such constructions that need to be fixed, and they aren't limited to "cull" records but other similar empty lists.