Rom-sql Rake Task

Question

I'm trying to setup migrations using 'rom/sql/rake_task'.

Here is my sample, but sadly it isn't working as it's complaining about a missing sequel adaptor. Any assistance or direction would be appreciated?

require 'sqlite3'
require 'rom-sql'
require 'rom/sql/rake_task'

namespace :db do
  task :setup do
    ROM.setup(:sql, 'sqlite_memory')
    ROM.finalize

    ROM::SQL.migration do
      change do
        create_table(:users) do
          primary_key :id
          String :name
        end
      end
    end
  end
end

gotar · Accepted Answer · 2015-05-14T06:46:45.763

3

Complete example: https://github.com/gotar/sinatra-rom

after you add

require 'bundler/setup'
require 'rom/sql/rake_task'

task :setup do
  # Load ROM related stuff. You don't need to specify manually connection
end

to Rakefile you will get few Raketasks (rake -T) to list them,

and then

$ rake db:create_migration[any_name]

and in file it will create, you can add your migration.

Thats all

edited May 14 '15 at 06:46

answered May 14 '15 at 06:35

gotar

91
5

score 0 · Answer 2 · answered May 14 '15 at 05:44

0

you may wanna try:

ROM::SQL::Migration.connection = ROM.setup(:sql, 'sqlite_memory').default.connection
ROM.finalize.env

ROM::SQL::Migration.create do
  # ...
end

answered May 14 '15 at 05:44

Kamil Lelonek

14,592
14
66
90

Thanks @squixy - but I am still getting LoadError: cannot load such file -- sequel/adapters/ – Dane Balia May 14 '15 at 05:50
Which version of ROM are you using? – Kamil Lelonek May 14 '15 at 06:01
Using roda 2.2.0 Using transproc 0.2.0 Using rom 0.6.2 Using sequel 4.22.0 Using rom-sql 0.4.1 – Dane Balia May 14 '15 at 06:06
this is the directions I was following, http://rom-rb.org/blog/2015/04/04/rom-0-6-1-released/ – Dane Balia May 14 '15 at 06:10

Rom-sql Rake Task

2 Answers2