module Clear::Migration::Helper

Included Modules

• Clear::Migration::FullTextSearchableHelpers

Direct including types

• Clear::Migration

Defined in:

Constant Summary

TYPE_MAPPING = {"string" => "text", "int32" => "int", "int64" => "bigint", "long" => "bigint", "bigdecimal" => "numeric", "datetime" => "timestamp without time zone"}

Class Method Summary

• .datatype(type : String)

  Replace some common type to their equivalent in postgresql if the type is not found in the correspondance table, then return itself

Instance Method Summary

• #add_column(table, column, datatype, nullable = false, constraint = nil, default = nil, with_values = false)

  Add a column to a specific table

• #add_operation(op : Operation)
• #apply(dir : Direction = Clear::Migration::Direction::Up)

  This will apply the migration in a given direction (up or down)

• #change(dir)
• #change_column_type(table, column, to, from = nil)
• #change_type_column(table, from, to)
• #create_enum(name : Clear::SQL::Symbolic, arr : Enumerable(T)) forall T
• #create_enum(name : Clear::SQL::Symbolic, e : ::Clear::Enum.class)
• #create_index(table, columns : Array(String), name = nil, using = nil, unique = false)
• #create_index(table, column, name = nil, using = nil, unique = false)

  Add a column to a specific table

• #create_table(name, id : Symbol | Bool = true, schema = "public", &)

  Helper used in migration to create a new table.

• #drop_column(table, column, type)
• #drop_enum(name : Clear::SQL::Symbolic, arr : Enumerable(T) | Nil = nil) forall T
• #execute(sql : String)
• #irreversible!
• #rename_column(table, from, to)

Class Method Detail

Instance Method Detail

create_table(:users) do |t|
  t.column :first_name, :string
  t.column :last_name, :string
  t.column :email, :string, unique: true
  t.timestamps
end

create_table(:users, id: false) do |t|
  t.column :user_id, :integer, primary: true # Use custom name for the primary key
  t.column :first_name, :string
  t.column :last_name, :string
  t.column :email, :string, unique: true
  t.timestamps
end