module Avram::Migrator::StatementHelpers

Included Modules

• Avram::Migrator::IndexStatementHelpers
• Avram::TableFor

Direct including types

• Avram::Migrator::Migration::V1

Defined in:

Macro Summary

• alter(table_name, *, if_exists = false)
• create(table_name, *, if_not_exists = false)

Instance Method Summary

• #create_foreign_key(from : TableName, to : TableName, on_delete : Symbol, column : Symbol | Nil, primary_key = :id)
• #create_function(name : String, body : String, returns : String = "trigger")
• #create_index(table_name : TableName, columns : Columns, unique = false, using = :btree, name : String | Nil | Symbol | Nil = nil)
• #create_sequence(table : TableName, column : Symbol)
• #create_trigger(table_name : TableName, name : String, function_name : String, callback : Symbol = :before, on : Array(Symbol) = [:update])

  Drop any existing trigger by this name first before creating.

• #disable_extension(name : String)
• #drop(table_name, *, if_exists = false)
• #drop_foreign_key(from : TableName, references : TableName, column : Symbol | Nil)
• #drop_function(name : String)
• #drop_index(table_name : TableName, columns : Columns | Nil = nil, if_exists = false, on_delete = :do_nothing, name : String | Nil | Symbol | Nil = nil)
• #drop_sequence(table : TableName, column : Symbol)
• #drop_trigger(table_name : TableName, name : String)

  Drop the tigger name for the table table_name

• #enable_extension(name : String)
• #make_optional(table : TableName, column : Symbol)
• #make_required(table : TableName, column : Symbol)
• #update_extension(name : String, to : String | Nil = nil)

Macro Detail

Instance Method Detail

create_trigger(:users, "trigger_set_timestamps", "set_timestamps")
# => CREATE TRIGGER trigger_set_timestamps BEFORE UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE set_timestamps();