How to use sequel join tables in ramaze07.12.13

How to use sequel join tables in ramaze

Attached is the example
1.
create a mysql database jointable
mysql -u username -pmypassword 
>create database jointable;
>exit

2.
ramaze create jointables

3.
add to app.rb

require 'sequel'

# Set DB
DB = Sequel.mysql('jointable', :user => 'root', :password => 'mypassword', :host => 'localhost')
Sequel::Model.plugin :schema

4
add 3 models in /model/
robot.rb
part.rb
jointer.rb

lass Robot < Sequel::Model(:robots)
  many_to_many :robots, :join_table => :joiner,
               :left_key => :robot_id, :right_key => :part_id,
               :class => 'Part'
  set_schema do
    primary_key   :id
    String        :name
  end

create_table!
end

class Part < Sequel::Model(:parts)
  many_to_many :parts, :join_table => :joiner,
               :left_key => :part_id, :right_key => :robot_id,
               :class => 'Robot'

set_schema do
    primary_key   :id
    String        :name
  end

create_table!
end

class Joiner < Sequel::Model(:joiner)
  many_to_one :robot, :key => :robot_id, :class => 'Robot'
  many_to_one :part, :key => :part_id, :class => 'Part'
  set_schema do
    primary_key   :id
    integer :robot_id
    integer :part_id
  end

create_table!
end

5.
edit model/init.rb 
and add:

require 'model/robot'
  require 'model/part'
  require 'model/joiner'

6
login into console:
ramaze -console

7
create a robot entry by:
robot1 = Robot.create(:name =>'Asimov')

8.
create 3 part entries by:
head = Part.create(:name =>'Head')
body = Part.create(:name =>'Body')
hand = Part.create(:name =>'Hand')

9.
now add the parts to the robot
robot1.add_part(head)
robot1.add_part(body)
robot1.add_part(hand)

10.
myrobot = Robot[1]
myrobot.parts 
will show you the robot with all it  parts

mypart = Part[1]
mypart.robots
will show you all the robotos what include the part

check

http://groups.google.com/group/sequel-talk/browse_thread/thread/41cab26a73b9491f/0fddf863723ec1e9?lnk=gst&q=join_table#0fddf863723ec1e9

Anonymous