As far as I understand the command line for sequel, it should be
possible to apply a database schema (even with more than one table/
file) by the following:
sequel -E -m migations sqlite://db/dev.db
But Sequel does only apply one file of that directory.
This is my structure:
/tmp
/tmp/migrations
/tmp/migrations/001_tablea.rb
/tmp/migrations/001_tableb.rb
/tmp/db
I run 'sequel -E -m migrations sqlite://db/dev.db' (at /tmp level)
with this result:
I, [2009-04-28T23:16:09.640000 #1800] INFO -- : SELECT * FROM
`schema_info` LIMIT 1
I, [2009-04-28T23:16:09.640000 #1800] INFO -- : CREATE TABLE
`schema_info` (`version` integer)
I, [2009-04-28T23:16:09.790000 #1800] INFO -- : SELECT * FROM
`schema_info` LIMIT 1
I, [2009-04-28T23:16:09.810000 #1800] INFO -- : Transaction.begin
I, [2009-04-28T23:16:09.810000 #1800] INFO -- : CREATE TABLE `b`
(`id` integer PRIMARY KEY AUTOINCREMENT)
I, [2009-04-28T23:16:09.820000 #1800] INFO -- : SELECT * FROM
`schema_info` LIMIT 1
I, [2009-04-28T23:16:09.830000 #1800] INFO -- : SELECT * FROM
`schema_info` LIMIT 1
I, [2009-04-28T23:16:09.830000 #1800] INFO -- : INSERT INTO
`schema_info` (`version`) VALUES (1)
I, [2009-04-28T23:16:09.921000 #1800] INFO -- : Transaction.commit
But where is table 'a'? Why was it not created?
Here the table definitions:
001_tablea.rb
class CreateA < Sequel::Migration
def up
create_table :a do
primary_key :id, :integer
end
end
def down
drop_table :a
end
end
001_tableb.rb
class CreateB < Sequel::Migration
def up
create_table :b do
primary_key :id, :integer
end
end
def down
drop_table :b
end
end
How are migrations supposed to use?! Am I completely wrong?
Thank you very much in advance!
Oliver.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
