Contents

require 'rubygems'
require 'spec'

$: << File.expand_path(File.join(File.dirname(__FILE__),"..","lib"))
require 'amalgalite'
require 'amalgalite/schema'

describe Amalgalite::Schema do
  before(:each) do
    @schema = IO.read( SpecInfo.test_schema_file )
    @iso_db_file = SpecInfo.make_iso_db
    @iso_db = Amalgalite::Database.new( SpecInfo.make_iso_db )
  end

  after(:each) do
    File.unlink SpecInfo.test_db if File.exist?( SpecInfo.test_db )
    @iso_db.close
    File.unlink @iso_db_file if File.exist?( @iso_db_file )
  end

  it "loads the schema of a database" do
    schema = @iso_db.schema
    schema.tables.size.should == 2
  end

  it "loads the views in the database" do
    sql = "CREATE VIEW v1 AS SELECT c.name, c.two_letter, s.name, s.subdivision FROM country AS c JOIN subcountry AS s ON c.two_letter = s.country"
    @iso_db.execute( sql )
    @iso_db.schema.views.size.should == 1
    @iso_db.schema.views["v1"].sql.should == sql
  end

  it "loads the tables and columns" do
    @iso_db.schema.tables.size.should == 2
    ct = @iso_db.schema.tables['country']
    ct.name.should == "country"
    ct.columns.size.should == 3
    ct.indexes.size.should == 2

    ct.columns['two_letter'].should be_primary_key
    ct.columns['name'].should_not be_nullable
    ct.columns['name'].should be_not_null_constraint
    ct.columns['name'].should_not be_has_default_value
    ct.columns['id'].should_not be_auto_increment
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
amalgalite-0.1.0	spec/schema_spec.rb
amalgalite-0.2.0	spec/schema_spec.rb
amalgalite-0.2.2	spec/schema_spec.rb
amalgalite-0.2.3	spec/schema_spec.rb
amalgalite-0.2.1	spec/schema_spec.rb
amalgalite-0.2.4	spec/schema_spec.rb