Class: Gitlab::Database::UnidirectionalCopyTrigger
- Inherits:
-
Object
- Object
- Gitlab::Database::UnidirectionalCopyTrigger
- Defined in:
- lib/gitlab/database/unidirectional_copy_trigger.rb
Class Method Summary collapse
Instance Method Summary collapse
- #create(from_column_names, to_column_names, trigger_name: nil) ⇒ Object
- #drop(trigger_name) ⇒ Object
- #name(from_column_names, to_column_names) ⇒ Object
Class Method Details
.on_table(table_name, connection:) ⇒ Object
6 7 8 |
# File 'lib/gitlab/database/unidirectional_copy_trigger.rb', line 6 def self.on_table(table_name, connection:) new(table_name, connection) end |
Instance Method Details
#create(from_column_names, to_column_names, trigger_name: nil) ⇒ Object
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 |
# File 'lib/gitlab/database/unidirectional_copy_trigger.rb', line 16 def create(from_column_names, to_column_names, trigger_name: nil) from_column_names, to_column_names = check_column_names!(from_column_names, to_column_names) trigger_name ||= unchecked_name(from_column_names, to_column_names) assignment_clauses = assignment_clauses_for_columns(from_column_names, to_column_names) connection.execute(<<~SQL) CREATE OR REPLACE FUNCTION #{trigger_name}() RETURNS trigger AS $BODY$ BEGIN #{assignment_clauses}; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE SQL connection.execute(<<~SQL) DROP TRIGGER IF EXISTS #{trigger_name} ON #{quoted_table_name} SQL connection.execute(<<~SQL) CREATE TRIGGER #{trigger_name} BEFORE INSERT OR UPDATE ON #{quoted_table_name} FOR EACH ROW EXECUTE FUNCTION #{trigger_name}() SQL end |
#drop(trigger_name) ⇒ Object
49 50 51 52 |
# File 'lib/gitlab/database/unidirectional_copy_trigger.rb', line 49 def drop(trigger_name) connection.execute("DROP TRIGGER IF EXISTS #{trigger_name} ON #{quoted_table_name}") connection.execute("DROP FUNCTION IF EXISTS #{trigger_name}()") end |
#name(from_column_names, to_column_names) ⇒ Object
10 11 12 13 14 |
# File 'lib/gitlab/database/unidirectional_copy_trigger.rb', line 10 def name(from_column_names, to_column_names) from_column_names, to_column_names = check_column_names!(from_column_names, to_column_names) unchecked_name(from_column_names, to_column_names) end |