Module: LookupBy::Lookup::SchemaMethods

Defined in:
lib/lookup_by/lookup.rb

Instance Method Summary collapse

Instance Method Details

#create_lookup_table(name, options = {}) ⇒ Object

Create a lookup table.

Examples:

create_lookup_table :statuses, schema: "custom", small: true

create_lookup_table :companies do |t|
  t.string :short_name
end

Parameters:

  • name (Symbol)
  • options (Hash) (defaults to: {})

Options Hash (options):

  • lookup_column (Symbol) —

    Name of the lookup column.

  • lookup_type (Symbol) —

    Type of the lookup column, e.g. :text, :uuid, or :inet.

  • primary_key (String) —

    Name of the primary key.

  • schema (String) 


161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
 
# File 'lib/lookup_by/lookup.rb', line 161

def create_lookup_table(name, options = {})
  options.symbolize_keys!

  schema = options[:schema].to_s

  if schema.present?
    table = name.to_s
  else
    schema, table = name.to_s.split('.')
    schema, table = nil, schema unless table
  end

  name = schema.blank? ? table : "#{schema}.#{table}"

  lookup_column = options[:lookup_column] || table.singularize
  lookup_type   = options[:lookup_type]   || :text

  table_options = options.slice(:primary_key, :id)
  table_options[:primary_key] ||= table.singularize + '_id'

  table_options[:id] = false if options[:small]

  create_table name, table_options do |t|
    t.column table_options[:primary_key], 'smallserial primary key' if options[:small]

    t.column lookup_column, lookup_type, null: false

    yield t if block_given?
  end

  add_index name, lookup_column, unique: true, name: "#{table}__u_#{lookup_column}"
end

#create_lookup_tables(*names) ⇒ Object 



194
195
196
197
198
199
200
 
# File 'lib/lookup_by/lookup.rb', line 194

def create_lookup_tables(*names)
  options = names.last.is_a?(Hash) ? names.pop : {}

  names.each do |name|
    create_lookup_table name, options
  end
end