Module: ActiveRecord::ConnectionAdapters::Redshift::ColumnMethods

Included in:
Table, TableDefinition
Defined in:
lib/active_record/connection_adapters/redshift/schema_definitions.rb

Instance Method Summary collapse

Instance Method Details

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



40
41
42
 
# File 'lib/active_record/connection_adapters/redshift/schema_definitions.rb', line 40

def json(name, options = {})
  column(name, :json, options)
end

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



44
45
46
 
# File 'lib/active_record/connection_adapters/redshift/schema_definitions.rb', line 44

def jsonb(name, options = {})
  column(name, :jsonb, options)
end

#primary_key(name, type = :primary_key, options = {}) ⇒ Object

Defines the primary key field. Use of the native PostgreSQL UUID type is supported, and can be used by defining your tables as such:

create_table :stuffs, id: :uuid do |t|
  t.string :content
  t.timestamps
end

By default, this will use the uuid_generate_v4() function from the uuid-ossp extension, which MUST be enabled on your database. To enable the uuid-ossp extension, you can use the enable_extension method in your migrations. To use a UUID primary key without uuid-ossp enabled, you can set the :default option to nil:

create_table :stuffs, id: false do |t|
  t.primary_key :id, :uuid, default: nil
  t.uuid :foo_id
  t.timestamps
end

You may also pass a different UUID generation function from uuid-ossp or another library.

Note that setting the UUID primary key default value to nil will require you to assure that you always provide a UUID value before saving a record (as primary keys cannot be nil). This might be done via the SecureRandom.uuid method and a before_save callback, for instance.



33
34
35
36
37
38
 
# File 'lib/active_record/connection_adapters/redshift/schema_definitions.rb', line 33

def primary_key(name, type = :primary_key, options = {})
  return super unless type == :uuid
  options[:default] = options.fetch(:default, 'uuid_generate_v4()')
  options[:primary_key] = true
  column name, type, options
end