Class: Volt::Migration

Inherits:
Object
  • Object
show all
Defined in:
app/sql/lib/migration.rb

Instance Method Summary collapse

Constructor Details

#initialize(db = nil) ⇒ Migration

Returns a new instance of Migration.



4
5
6
 
# File 'app/sql/lib/migration.rb', line 4

def initialize(db=nil)
  @db ||= Volt.current_app.database.raw_db
end

Instance Method Details

#add_column(table_name, column_name, klasses, options = {}) ⇒ Object 



8
9
10
11
12
13
 
# File 'app/sql/lib/migration.rb', line 8

def add_column(table_name, column_name, klasses, options={})
  sequel_type, sequel_options = Helper.column_type_and_options_for_sequel(klasses, options)
  @db.alter_table(table_name) do
    add_column(column_name, sequel_type, sequel_options)
  end
end

#column_exists?(table_name, column_name) ⇒ Boolean

Returns:

  • (Boolean) 


56
57
58
59
60
61
62
 
# File 'app/sql/lib/migration.rb', line 56

def column_exists?(table_name, column_name)
  if table_exists?(table_name)
    @db[table_name].columns.include?(column_name)
  else
    false
  end
end

#drop_column(table_name, column_name) ⇒ Object 



22
23
24
25
26
 
# File 'app/sql/lib/migration.rb', line 22

def drop_column(table_name, column_name)
  @db.alter_table(table_name) do
    drop_column column_name
  end
end

#rename_column(table_name, from, to, options = {}) ⇒ Object 



15
16
17
18
19
20
 
# File 'app/sql/lib/migration.rb', line 15

def rename_column(table_name, from, to, options={})
  # TODO: add options check
  @db.alter_table(table_name) do
    rename_column from, to
  end
end

#set_column_allow_null(table_name, column_name) ⇒ Object 



34
35
36
37
38
 
# File 'app/sql/lib/migration.rb', line 34

def set_column_allow_null(table_name, column_name)
  @db.alter_table(table_name) do
    set_column_allow_null(column_name)
  end
end

#set_column_default(table_name, column_name, default) ⇒ Object 



46
47
48
49
50
 
# File 'app/sql/lib/migration.rb', line 46

def set_column_default(table_name, column_name, default)
  @db.alter_table(table_name) do
    set_column_default(column_name, default)
  end
end

#set_column_not_null(table_name, column_name) ⇒ Object 



40
41
42
43
44
 
# File 'app/sql/lib/migration.rb', line 40

def set_column_not_null(table_name, column_name)
  @db.alter_table(table_name) do
    set_column_not_null(column_name)
  end
end

#set_column_type(table_name, column_name, type, options = {}) ⇒ Object 



28
29
30
31
32
 
# File 'app/sql/lib/migration.rb', line 28

def set_column_type(table_name, column_name, type, options={})
  @db.alter_table(table_name) do
    set_column_type(column_name, type, options)
  end
end

#table_exists?(table_name) ⇒ Boolean

Returns:

  • (Boolean) 


52
53
54
 
# File 'app/sql/lib/migration.rb', line 52

def table_exists?(table_name)
  @db.tables && @db.tables.include?(table_name)
end