module Clear::Migration::Helper

Included Modules

Direct including types

Defined in:

clear/extensions/enum/migration.cr
clear/extensions/full_text_searchable/full_text_searchable.cr
clear/migration/migration.cr
clear/migration/operation/columns.cr
clear/migration/operation/indexes.cr
clear/migration/operation/table.cr

Constant Summary

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

Class Method Summary

Instance Method Summary

Instance methods inherited from module Clear::Migration::FullTextSearchableHelpers

add_full_text_searchable(table, on : Array(Tuple(String, Char)), column_name = "full_text_vector", catalog = "pg_catalog.english", trigger_name = nil, function_name = nil) add_full_text_searchable

Class Method Detail

def self.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


[View source]

Instance Method Detail

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

Add a column to a specific table


[View source]
def add_operation(op : Operation) #

[View source]
def apply(dir : Direction = Clear::Migration::Direction::Up) #

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


[View source]
abstract def change(dir) #

[View source]
def change_column_type(table, column, to, from = nil) #

[View source]
def change_type_column(table, from, to) #

[View source]
def create_enum(name : Clear::SQL::Symbolic, arr : Enumerable(T)) forall T #

[View source]
def create_enum(name : Clear::SQL::Symbolic, e : ::Clear::Enum.class) #

[View source]
def create_index(table, columns : Array(String), name = nil, using = nil, unique = false) #

[View source]
def create_index(table, column, name = nil, using = nil, unique = false) #

Add a column to a specific table


[View source]
def create_table(name, id : Symbol | Bool = true, schema = "public", &) #

Helper used in migration to create a new table.

Usage:

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

By default, a column id of type integer will be created as primary key of the table. This can be prevented using primary: false

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

[View source]
def drop_column(table, column, type) #

[View source]
def drop_enum(name : Clear::SQL::Symbolic, arr : Enumerable(T) | Nil = nil) forall T #

[View source]
def execute(sql : String) #

[View source]
def irreversible! #

[View source]
def rename_column(table, from, to) #

[View source]