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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
# frozen_string_literal: true
module Gitlab
module Database
class PostgresForeignKey < SharedModel
self.primary_key = :oid
# These values come from the possible confdeltype / confupdtype values in pg_constraint
ACTION_TYPES = {
restrict: 'r',
cascade: 'c',
nullify: 'n',
set_default: 'd',
no_action: 'a'
}.freeze
enum on_delete_action: ACTION_TYPES, _prefix: :on_delete
enum on_update_action: ACTION_TYPES, _prefix: :on_update
scope :by_referenced_table_identifier, ->(identifier) do
unless identifier =~ Database::FULLY_QUALIFIED_IDENTIFIER
raise ArgumentError, "Referenced table name is not fully qualified with a schema: #{identifier}"
end
where(referenced_table_identifier: identifier)
end
scope :by_referenced_table_name, ->(name) { where(referenced_table_name: name) }
scope :by_constrained_table_identifier, ->(identifier) do
unless identifier =~ Database::FULLY_QUALIFIED_IDENTIFIER
raise ArgumentError, "Constrained table name is not fully qualified with a schema: #{identifier}"
end
where(constrained_table_identifier: identifier)
end
scope :by_constrained_table_name, ->(name) { where(constrained_table_name: name) }
scope :by_constrained_table_name_or_identifier, ->(name) do
if name =~ Database::FULLY_QUALIFIED_IDENTIFIER
by_constrained_table_identifier(name)
else
by_constrained_table_name(name)
end
end
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
scope :by_on_update_action, ->(on_update) do
raise ArgumentError, "Invalid on_update action #{on_update}" unless on_update_actions.key?(on_update)
where(on_update_action: on_update)
end
end
end
end
|