1 files changed, 27 insertions, 0 deletions
diff --git a/lib/gitlab/database/postgres_foreign_key.rb b/lib/gitlab/database/postgres_foreign_key.rb
index 241b6f009f7..d3ede45fe86 100644
--- a/lib/gitlab/database/postgres_foreign_key.rb
+++ b/lib/gitlab/database/postgres_foreign_key.rb
@@ -5,17 +5,44 @@ module Gitlab
     class PostgresForeignKey < SharedModel
       self.primary_key = :oid
 
+      # These values come from the possible confdeltype values in pg_constraint
+      enum on_delete_action: {
+        restrict: 'r',
+        cascade: 'c',
+        nullify: 'n',
+        set_default: 'd',
+        no_action: 'a'
+      }
+
       scope :by_referenced_table_identifier, ->(identifier) do
         raise ArgumentError, "Referenced table name is not fully qualified with a schema: #{identifier}" unless identifier =~ /^\w+\.\w+$/
 
         where(referenced_table_identifier: identifier)
       end
 
+      scope :by_referenced_table_name, ->(name) { where(referenced_table_name: name) }
+
       scope :by_constrained_table_identifier, ->(identifier) do
         raise ArgumentError, "Constrained table name is not fully qualified with a schema: #{identifier}" unless identifier =~ /^\w+\.\w+$/
 
         where(constrained_table_identifier: identifier)
       end
+
+      scope :by_constrained_table_name, ->(name) { where(constrained_table_name: name) }
+
+      scope :not_inherited, -> { where(is_inherited: false) }
+
+      scope :by_name, ->(name) { where(name: name) }
+
+      scope :by_constrained_columns, ->(cols) { where(constrained_columns: Array.wrap(cols)) }
+
+      scope :by_referenced_columns, ->(cols) { where(referenced_columns: Array.wrap(cols)) }
+
+      scope :by_on_delete_action, ->(on_delete) do
+        raise ArgumentError, "Invalid on_delete action #{on_delete}" unless on_delete_actions.key?(on_delete)
+
+        where(on_delete_action: on_delete)
+      end
     end
   end
 end