Contents

require File.dirname(__FILE__) + '/../spec_helper'

describe Sequel do

#  describe "has method 'fos' that" do
#    before :each do
#      @db = Sequel.fos('fos')
#    end
#
#    it "instantiates a fos/pervasive db from an odbc name" do
#      @db.should_not be nil
#    end
#
#    it "actually works to see a fos table" do
#      TripLeg.db=@db
#      TripLeg.first.should_not be nil
#    end
#  end

  describe "has method 'fos_dbr' that" do
    before :each do
      hash = {:host=>"localhost", :user=>'root', :password=>'', :database=>'test'}
      @db = Sequel.fos_dbr(hash)
    end

    it "instantiates dbr/mysql db from hash of params name" do
      @db.should_not be nil
    end

    it "actually works to see dbr tables" do
      [TripLeg,Trip,Quote,Aircraft,Code,CrewLeg].each{|model| model.db=@db}
#      TripLeg.first.should_not be nil
#      TripLeg.first.trip.should_not be nil
      p Trip.eager_graph(:quote).sql
#      p TripLeg.select(:trip_number).eager_graph(:trip).sql
#      p TripLeg.filter(:id=>"WERJ-1-17-40385-1243").first
#      p TripLeg.filter(:'trip legs__trip_number'=>68070,:leg_number=>5).eager_graph(:crew_legs => [:crew_name, :position_code]).sql
#      t = TripLeg.filter(:'trip legs__trip_number'=>68070,:leg_number=>5).eager_graph(:crew_legs => [:crew_name, :position_code]).all.first
#      p [t.status,t.division,t.regulation,t.closed,t.ete,t.department,t.deadhead,t.company]
#      p TripLeg.filter(:id=>"WERJ-1-17-40385-1243").eager_graph(:aircraft).all.first
#      TripLeg.filter(:'trip legs__kid_date'=>40475..40475, :cancel_code=>0,:leg_type_code=>7).eager_graph(:crew_legs=>:position_code).all.size.should == 3
    end
  end

#  it "set_db method finds sets db on all Sequel models" do
#    db = Sequel.fos('fos')
#    Sequel.set_db db
#    Trip.db.should == db
#  end

  it "converts fos_id to key that can be used to query model" do
    Sequel.fos_id_to_lookup_key("MERE-0-8-40443-1259").should == ['MERE',0,8,40443,1259]
  end

end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
fossil-0.5.23	spec/sequel/core_patch_spec.rb
fossil-0.5.22	spec/sequel/core_patch_spec.rb
fossil-0.5.21	spec/sequel/core_patch_spec.rb