Looks like it should work to me. Here's a post I did on migrations that I
"know" works. You may want to try starting from that and see if you can
figure out what's going wrong here.

http://steamcode.blogspot.com/2009/03/sequel-migrations.html

On Tue, Apr 28, 2009 at 3:29 PM, Olly <[email protected]>wrote:

>
> Thank you very much for your quick answer!
>
> So I did the following changes:
> /tmp
> /tmp/db
> /tmp/migrations
> /tmp/migrations/001_create_tables.rb
>
> Contents of 001_create_tables.rb:
>   Class.new(Sequel::Migration) do
>    def up
>       create_table :a do
>        primary_key :id, :integer
>      end
>
>       create_table :b do
>        primary_key :id, :integer
>      end
>    end
>
>    def down
>       drop_table :a
>       drop_table :b
>    end
>  end
>
> The result is:
> $ sequel -version
> sequel 2.12.0
>
> $ sequel -E -m migrations sqlite://db/dev.db
> I, [2009-04-29T00:18:43.939000 #852]  INFO -- : SELECT * FROM
> `schema_info` LIMIT 1
> I, [2009-04-29T00:18:43.949000 #852]  INFO -- : CREATE TABLE
> `schema_info` (`version` integer)
> I, [2009-04-29T00:18:44.149000 #852]  INFO -- : SELECT * FROM
> `schema_info` LIMIT 1
> I, [2009-04-29T00:18:44.149000 #852]  INFO -- : Transaction.begin
> I, [2009-04-29T00:18:44.149000 #852]  INFO -- : SELECT * FROM
> `schema_info` LIMIT 1
> I, [2009-04-29T00:18:44.149000 #852]  INFO -- : SELECT * FROM
> `schema_info` LIMIT 1
> I, [2009-04-29T00:18:44.159000 #852]  INFO -- : INSERT INTO
> `schema_info` (`version`) VALUES (1)
> I, [2009-04-29T00:18:44.319000 #852]  INFO -- : Transaction.commit
>
> The tables a and b were not created. Even '-M 1' did not what I
> expected.
> Am I still completely wrong?
>
> Thanks in advance! Oliver.
> >
>


-- 
Scott
http://steamcode.blogspot.com/

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to