Contents

RSpec.describe ROM::Relation, '#dataset' do
  subject(:relation) { container.relations.users }

  include_context 'users and tasks'

  let(:dataset) { container.gateways[:default].dataset(:users) }

  with_adapters do
    context 'with schema' do
      before do
        conf.relation(:users) do
          schema do
            attribute :id, ROM::SQL::Types::Serial
            attribute :name, ROM::SQL::Types::String
          end
        end
      end

      it 'uses schema to infer default dataset' do
        expect(relation.dataset.sql).
          to eql(dataset.select(Sequel.qualify(:users, :id), Sequel.qualify(:users, :name)).order(Sequel.qualify(:users, :id)).sql)
      end
    end

    context 'with cherry-picked attributes in schema' do
      before do
        conf.relation(:users) do
          schema do
            attribute :id, ROM::SQL::Types::Serial
          end
        end
      end

      it 'uses schema to infer default dataset' do
        expect(relation.dataset.sql).
          to eql(dataset.select(Sequel.qualify(:users, :id)).order(Sequel.qualify(:users, :id)).sql)
      end
    end

    context 'with inferred schema' do
      before do
        conf.relation(:users) { schema(infer: true) }
      end

      it 'selects all qualified columns and sorts by pk' do
        expect(relation.dataset.sql).to eql(dataset.select(*relation.schema.qualified).order(Sequel.qualify(:users, :id)).sql)
      end
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
rom-sql-2.0.0.beta2	spec/unit/relation/dataset_spec.rb
rom-sql-2.0.0.beta1	spec/unit/relation/dataset_spec.rb