1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
# frozen_string_literal: true
module Gitlab
module Database
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
|