<commit_before><commit_msg>Added a migration that cascades a delete of access rights whenever a camera is deleted.<commit_after>Sequel.migration do

  up do
    self.run("alter table access_rights drop constraint access_rights_camera_id_fkey")
    self.run("alter table access_rights add constraint access_rights_camera_id_fkey "\
             "foreign key (camera_id) references cameras(id) on delete cascade")
  end

  down do
    self.run("alter table access_rights drop constraint access_rights_camera_id_fkey")
    self.run("alter table access_rights add constraint access_rights_camera_id_fkey "\
             "foreign key (camera_id) references cameras(id) on delete restrict")
  end

end

{'fraction_non_alphanumeric': 0.0603448275862069, 'fraction_numerical': 0.0, 'mean_word_length': 4.488188976377953, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '370745', 'n_tokens_mistral': 204, 'n_tokens_neox': 188, 'n_words': 63}