Contents

require 'spec_helper'

RSpec.describe ROM::SQL::OrderDSL, :postgres, helpers: true do
  include_context 'database setup'

  subject(:dsl) do
    ROM::SQL::OrderDSL.new(schema)
  end

  let(:schema) do
    define_schema(:users, id: ROM::SQL::Types::Serial, name: ROM::SQL::Types::String)
  end

  let(:ds) do
    conn[:users]
  end

  describe '#call' do
    it 'returns an array with ordered expressions' do
      expect(dsl.call { id }.first.sql_literal(conn[:users])).to eql('"id"')
    end
  end

  describe '#method_missing' do
    it 'responds to methods matching attribute names' do
      expect(dsl.id.name).to be(:id)
      expect(dsl.name.name).to be(:name)
    end

    it 'delegates to sequel virtual row' do
      expect(dsl.call { nullif(id.qualified, `''`).desc }.first.sql_literal(conn[:users])).
        to eql(%(NULLIF("users"."id", '') DESC))
    end
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
rom-sql-1.2.2	spec/unit/order_dsl_spec.rb
rom-sql-1.2.1	spec/unit/order_dsl_spec.rb
rom-sql-1.2.0	spec/unit/order_dsl_spec.rb
rom-sql-1.1.2	spec/unit/order_dsl_spec.rb
rom-sql-1.1.1	spec/unit/order_dsl_spec.rb
rom-sql-1.1.0	spec/unit/order_dsl_spec.rb
rom-sql-1.0.3	spec/unit/order_dsl_spec.rb
rom-sql-1.0.2	spec/unit/order_dsl_spec.rb
rom-sql-1.0.1	spec/unit/order_dsl_spec.rb
rom-sql-1.0.0	spec/unit/order_dsl_spec.rb
rom-sql-1.0.0.rc2	spec/unit/order_dsl_spec.rb
rom-sql-1.0.0.rc1	spec/unit/order_dsl_spec.rb
rom-sql-1.0.0.beta3	spec/unit/order_dsl_spec.rb