delete_shadow_tables_for_updates.py

import datajoint as dj
from ibl_pipeline.ingest import alyxraw, data
from ibl_pipeline.ingest import action, acquisition


dj.config['safemode'] = False

# delete alyxraw for data.filerecord if exists = 0
print('Deleting alyxraw entries corresponding to file records...')
file_record_fields = alyxraw.AlyxRaw.Field & \
    'fname = "exists"' & 'fvalue = "False"'

for key in file_record_fields:
    (alyxraw.AlyxRaw.Field & key).delete_quick()

# delete water tables and related alyxraw entries
print('Deleting alyxraw entries of shadow weighing and water tables...')
(alyxraw.AlyxRaw & 'model in ("actions.weighing", "actions.waterrestriction", \
     "actions.wateradministration")').delete()

# delete the lab, user, user_history, death_date,
# and caging field of the subject
print('Deleting subject fields lab, user, user_hisotry and death date...')
subject_fields = alyxraw.AlyxRaw.Field & \
    (alyxraw.AlyxRaw & 'model="subjects.subject"') & \
    'fname in ("lab", "death_date", "responsible_user", "json")'
subject_fields.delete_quick()

# delete some shadow membership tables
print('Deleting shadow membership tables...')
action.WaterRestrictionProcedure.delete()
action.WaterRestrictionUser.delete()
acquisition.WaterAdministrationSession.delete()