Contents

require 'spec_helper'
require 'fileutils'
require "sequel"
module Alf
  describe Sequel::Environment do
    
    let(:rel) {Alf::Relation[
      {:sid => 'S1', :name => 'Smith', :status => 20, :city => 'London'},
      {:sid => 'S2', :name => 'Jones', :status => 10, :city => 'Paris'},
      {:sid => 'S3', :name => 'Blake', :status => 30, :city => 'Paris'},
      {:sid => 'S4', :name => 'Clark', :status => 20, :city => 'London'},
      {:sid => 'S5', :name => 'Adams', :status => 30, :city => 'Athens'}
    ]}

    let(:file){ _("alf.db", __FILE__) }

    before(:all){
      unless File.exists?(file) 
        FileUtils.rm_rf file
        db = ::Sequel.connect(uri)
        db.create_table(:suppliers){
          primary_key :sid
          String  :sid
          String  :name
          Integer :status
          String  :city
        }
        rel.each{|tuple| db[:suppliers].insert(tuple)}
      end
    }

    describe "recognizes?" do

      it "should recognize sqlite files" do
        Sequel::Environment.recognizes?([file]).should be_true
      end

      it "should recognize database uris" do
        Sequel::Environment.recognizes?(["postgres://localhost/database"]).should be_true
        Sequel::Environment.recognizes?(["sqlite://#{file}"]).should be_true
      end

      it "should not be too permissive" do
        Sequel::Environment.recognizes?(["nosuchone.db"]).should be_false
        Sequel::Environment.recognizes?([nil]).should be_false
      end

    end # recognizes?

    it "should let Environment autodetect sqlite files" do
      Environment.autodetect(file).should be_a(Sequel::Environment)
    end

    describe "dataset" do

      let(:env) { Sequel::Environment.new(file) }

      it "should serve iterators" do
        env.dataset(:suppliers).should be_a(Alf::Iterator)
      end

      it "should be the correct relation" do
        env.dataset(:suppliers).to_rel.should eq(rel)
      end

    end # dataset

  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
alf-0.12.0	spec/unit/alf-sequel/test_environment.rb
alf-0.11.1	spec/unit/alf-sequel/test_environment.rb
alf-0.11.0	spec/unit/alf-sequel/test_environment.rb