How to add stuff I associated to migrations?

Question

I have a seemingly easy problem, but I have been unable to find a proper explanation (or I've just been too tired to see it). I have following migrations and models:

    class User < Sequel::Model
            one_to_many :orders
    end

    Sequel.migration do
            change do
                    create_table :users do
                            primary_key :id
                            String :name, :null=> false
                            String :password, :null=>false
                            create_table :user_orders do
                                  #like that? If so, what to put in here?
                            end
                    end    
            end
    end

and

    class Order < Sequel::Model
            many_to_one :user
            many_to_one :restaurant #ignore for now
    end

    Sequel.migration do
            change do
                    create_table :orders do
                            primary_key :id
                           #no stuff yet
                    end
            end


    end

My question is - how do I create a table in users and a single entry in orders to assign proper orders to user and proper user to an order. If I skipped some obvious source then I'm sorry in advance (new to ruby and whole web apps thing), and by all means point me in the right direction.

score 1 · Accepted Answer · answered Nov 29 '14 at 20:24

1

I'm not sure if that is what you want, but as you can see in the documentation, the :orders table should contain a foreign key to :users:

Sequel.migration do
  change do
    create_table :orders do
      primary_key :id
      foreign_key :user_id, :users
      #no stuff yet
    end
  end
end

answered Nov 29 '14 at 20:24

Uri Agassi

36,848
14
76
93

Ok, I can see that - what about the other way around (users migration)? How would I create a table of orders? – Krzysztof Piszko Nov 29 '14 at 20:29
In a one_to_many relationship you don't need anything in the "one" side - the :orders table holds the relation with the foreign key. – Uri Agassi Nov 29 '14 at 20:30
Oh, I see. So one last question - let's say I want to list users and their orders like [this](http://pastebin.com/Dn9iUPvR). How would I access the orders assigned to user? – Krzysztof Piszko Nov 29 '14 at 20:37
`user.orders.each...` – Uri Agassi Nov 29 '14 at 20:38

How to add stuff I associated to migrations?

1 Answers1