Sha256: 90ddceb7629c28551e9c9c3071b5fc63b665d9e35ccb1a8b3a2de0f318a098ee
Contents?: true
Size: 993 Bytes
Versions: 15
Compression:
Stored size: 993 Bytes
Contents
require 'arel/visitors/compat'
module Arel
module Visitors
class Derby < Arel::Visitors::ToSql
def visit_Arel_Nodes_SelectStatement o, a = nil
sql = o.cores.map { |x| do_visit(x, a) }.join
sql << " ORDER BY #{o.orders.map { |x| visit x }.join(', ')}" unless o.orders.empty?
sql << " #{do_visit o.offset, a}" if o.offset
sql << " #{do_visit o.limit, a}" if o.limit
sql << " #{do_visit o.lock, a}" if o.lock
sql
end
def visit_Arel_Nodes_Limit o, a = nil
"FETCH FIRST #{limit_for(o)} ROWS ONLY"
end
def visit_Arel_Nodes_Offset o, a = nil
"OFFSET #{do_visit o.value, a} ROWS"
end
# This generates SELECT...FOR UPDATE, but it will only work if the
# current transaction isolation level is set to SERIALIZABLE. Otherwise,
# locks aren't held for the entire transaction.
def visit_Arel_Nodes_Lock o, a = nil
do_visit o.expr, a
end
end
end
end
Version data entries
15 entries across 15 versions & 1 rubygems