From 0ab2bb8647a08b381ed2eb94f6763aa0ad71668f Mon Sep 17 00:00:00 2001 From: Marius Balteanu Date: Sun, 2 Oct 2022 20:39:06 +0000 Subject: Delete orphaned query and role ids from habtm join table (#36844). git-svn-id: https://svn.redmine.org/redmine/trunk@21893 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- ...55_delete_orphaned_query_and_role_from_queries_roles.rb | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 db/migrate/20221002193055_delete_orphaned_query_and_role_from_queries_roles.rb (limited to 'db') diff --git a/db/migrate/20221002193055_delete_orphaned_query_and_role_from_queries_roles.rb b/db/migrate/20221002193055_delete_orphaned_query_and_role_from_queries_roles.rb new file mode 100644 index 000000000..aa86450a2 --- /dev/null +++ b/db/migrate/20221002193055_delete_orphaned_query_and_role_from_queries_roles.rb @@ -0,0 +1,14 @@ +class DeleteOrphanedQueryAndRoleFromQueriesRoles < ActiveRecord::Migration[6.1] + def self.up + queries_roles = "#{Query.table_name_prefix}queries_roles#{Query.table_name_suffix}" + queries = Query.table_name + roles = Role.table_name + + ActiveRecord::Base.connection.execute "DELETE FROM #{queries_roles} WHERE query_id NOT IN (SELECT DISTINCT(id) FROM #{queries})" + ActiveRecord::Base.connection.execute "DELETE FROM #{queries_roles} WHERE role_id NOT IN (SELECT DISTINCT(id) FROM #{roles})" + end + + def self.down + # no-op + end +end -- cgit v1.2.3