Sha256: d950967ea5283a9ca43d94c3b99ff8621b0907de2d6590e90da305c970cfd06f
Contents?: true
Size: 459 Bytes
Versions: 6
Compression:
Stored size: 459 Bytes
Contents
require_relative '../../../spec_helper'
require 'sql/maker/select/oracle'
describe 'SQL::Maker::Select::Oracle' do
let(:sel) do
SQL::Maker::Select::Oracle.new( :new_line => %q{ } )
.add_select('foo')
.add_from('user')
.limit(10)
.offset(20)
end
it do
expect(sel.as_sql).to be == 'SELECT * FROM ( SELECT foo, ROW_NUMBER() OVER (ORDER BY 1) R FROM user LIMIT 10 OFFSET 20 ) WHERE R BETWEEN 20 + 1 AND 10 + 20'
end
end
Version data entries
6 entries across 6 versions & 1 rubygems