Class: AddIndexesToLedgerEntries

Inherits:
Object
  • Object
show all
Defined in:
lib/generators/ledger_accountable/templates/add_indexes_migration.rb

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object 



15
16
17
18
19
20
 
# File 'lib/generators/ledger_accountable/templates/add_indexes_migration.rb', line 15

def down
  remove_index_if_exists :ledger_entries, name: 'index_ledger_entries_on_owner_and_transaction_type'
  remove_index_if_exists :ledger_entries, name: 'index_ledger_entries_on_owner_and_entry_type'
  remove_index_if_exists :ledger_entries, name: 'index_ledger_entries_on_owner_and_created_at_and_id'
  remove_index_if_exists :ledger_entries, name: 'index_ledger_entries_on_item_and_created_at_and_id'
end

#up ⇒ Object 



4
5
6
7
8
9
10
11
12
13
 
# File 'lib/generators/ledger_accountable/templates/add_indexes_migration.rb', line 4

def up
  add_index_unless_exists :ledger_entries, [:owner_type, :owner_id, :transaction_type],
                          name: 'index_ledger_entries_on_owner_and_transaction_type'
  add_index_unless_exists :ledger_entries, [:owner_type, :owner_id, :entry_type],
                          name: 'index_ledger_entries_on_owner_and_entry_type'
  add_index_unless_exists :ledger_entries, [:owner_type, :owner_id, :created_at, :id],
                          name: 'index_ledger_entries_on_owner_and_created_at_and_id'
  add_index_unless_exists :ledger_entries, [:ledger_item_type, :ledger_item_id, :created_at, :id],
                          name: 'index_ledger_entries_on_item_and_created_at_and_id'
end