Class: AddNumberColumnToRecorderRevisions

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/recorder/templates/add_number_column_to_recorder_revisions.rb

Overview

This migration adds number column to the ‘revisions` table.

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object 



33
34
35
36
37
38
39
40
41
42
43
 
# File 'lib/generators/recorder/templates/add_number_column_to_recorder_revisions.rb', line 33

def down
  execute "    DROP TRIGGER update_recorder_revisions_number;\n  SQL\n\n  execute <<-SQL\n    DROP FUNCTION IF EXISTS get_recorder_revisions_number;\n  SQL\n\n  remove_column :recorder_revisions, :number\nend\n"

#up ⇒ Object 



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
 
# File 'lib/generators/recorder/templates/add_number_column_to_recorder_revisions.rb', line 5

def up
  add_column :recorder_revisions, :number, :integer, null: false, default: 0

  execute "          CREATE OR REPLACE FUNCTION get_recorder_revisions_number()\n            RETURNS trigger AS\n          $BODY$\n          BEGIN\n              SELECT COALESCE(MAX(recorder_revisions.number), 0) + 1\n              INTO NEW.number\n              FROM\n                recorder_revisions\n              WHERE\n                recorder_revisions.item_type = NEW.item_type\n                AND recorder_revisions.item_id = NEW.item_id;\n    \#{\"      \"}\n              RETURN NEW;\n          END;\n          $BODY$ LANGUAGE plpgsql;\n  SQL\n\n  execute <<~SQL\n    CREATE TRIGGER update_recorder_revisions_number\n      BEFORE INSERT ON recorder_revisions FOR EACH ROW\n      EXECUTE PROCEDURE get_recorder_revisions_number();\n  SQL\nend\n"