sequel_migrations.md

Quick Links

• Sequel Cheat Sheet

Traditional Column Change

Sequel.migration do
  change do
    alter_table(:table_name) do
      add_column :name, String, :null => true
    do
  do
end

Up / Down Column Change

Sequel.migration do
  up do
    alter_table(:table_name) do
      add_column :name, String, :null => true
    do
  do
  down do
    alter_table(:table_name) do
      drop_column :name
    end
  end
end

Insert / Delete Records

Sequel.migration do                                                                            
  up do
    bs_id = self[:my_table].insert(:name => 'food', :title => 'bar', :type => '1103')
  end

  down do
    from(:my_table).where(:name => 'foo').delete
  end
end