Module: Waldit::Migration

Defined in:
lib/waldit/migration.rb

Instance Method Summary collapse

Instance Method Details

#add_table_to_waldit(table) ⇒ Object 



39
40
41
42
43
44
45
46
47
48
49
50
 
# File 'lib/waldit/migration.rb', line 39

def add_table_to_waldit(table)
  reversible do |dir|
    dir.up do
      execute "ALTER TABLE #{table} REPLICA IDENTITY FULL"
      execute "ALTER PUBLICATION waldit_publication ADD TABLE #{table}"
    end
    dir.down do
      execute "ALTER PUBLICATION waldit_publication DROP TABLE #{table}"
      execute "ALTER TABLE #{table} REPLICA IDENTITY DEFAULT"
    end
  end
end

#create_waldit_publication ⇒ Object 



32
33
34
35
36
37
 
# File 'lib/waldit/migration.rb', line 32

def create_waldit_publication
  reversible do |dir|
    dir.up { execute "CREATE PUBLICATION waldit_publication" }
    dir.down { execute "DROP PUBLICATION waldit_publication" }
  end
end

#create_waldit_table(name = "waldit") ⇒ 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
 
# File 'lib/waldit/migration.rb', line 5

def create_waldit_table(name = "waldit")
  reversible do |dir|
    dir.up { execute "CREATE TYPE waldit_action AS ENUM ('insert', 'update', 'delete')" }
    dir.down { execute "DROP TYPE waldit_action" }
  end

  create_table name do |t|
    t.column :action, :waldit_action, null: false
    t.string :table_name, null: false
    t.string :primary_key, null: false
    t.bigint :transaction_id, null: false
    t.decimal :lsn, null: false, precision: 20, scale: 0
    t.timestamptz :committed_at
    t.jsonb :context, null: false, default: {}
    t.jsonb :old, null: true
    t.jsonb :new, null: true
    t.jsonb :diff, null: true
    yield t if block_given?
  end

  add_index name, [:table_name, :primary_key, :transaction_id], unique: true
  add_index name, [:transaction_id, :lsn]
  add_index name, [:action, :table_name, :committed_at]
  add_index name, :committed_at
  add_index name, :context, using: :gin, opclass: :jsonb_path_ops
end

#remove_table_from_waldit(table) ⇒ Object 



52
53
54
55
56
57
58
59
60
61
62
63
 
# File 'lib/waldit/migration.rb', line 52

def remove_table_from_waldit(table)
  reversible do |dir|
    dir.up do
      execute "ALTER PUBLICATION waldit_publication DROP TABLE #{table}"
      execute "ALTER TABLE #{table} REPLICA IDENTITY DEFAULT"
    end
    dir.down do
      execute "ALTER TABLE #{table} REPLICA IDENTITY FULL"
      execute "ALTER PUBLICATION waldit_publication ADD TABLE #{table}"
    end
  end
end