diff options
| author | Aaron Patterson <aaron.patterson@gmail.com> | 2010-09-24 09:41:48 -0700 |
|---|---|---|
| committer | Aaron Patterson <aaron.patterson@gmail.com> | 2010-09-24 09:41:48 -0700 |
| commit | 487df1771ded1fb065a53ebe9d1a5a9c119478e3 (patch) | |
| tree | dacefa00fca782bcbd86bd5cf2476226253fc674 /lib/arel/visitors | |
| parent | 7615bd7f928390d0ba9501e5206fd89ce6ce44fc (diff) | |
| download | rails-487df1771ded1fb065a53ebe9d1a5a9c119478e3.tar.gz rails-487df1771ded1fb065a53ebe9d1a5a9c119478e3.tar.bz2 rails-487df1771ded1fb065a53ebe9d1a5a9c119478e3.zip | |
adding an oracle visitor
Diffstat (limited to 'lib/arel/visitors')
| -rw-r--r-- | lib/arel/visitors/oracle.rb | 15 | ||||
| -rw-r--r-- | lib/arel/visitors/to_sql.rb | 4 |
2 files changed, 19 insertions, 0 deletions
diff --git a/lib/arel/visitors/oracle.rb b/lib/arel/visitors/oracle.rb new file mode 100644 index 0000000000..840a7a9ace --- /dev/null +++ b/lib/arel/visitors/oracle.rb @@ -0,0 +1,15 @@ +module Arel + module Visitors + class Oracle < Arel::Visitors::ToSql + def visit_Arel_Nodes_SelectStatement o + if o.limit + o.cores.last.wheres.push Nodes::LessThanOrEqual.new( + Nodes::SqlLiteral.new('ROWNUM'), o.limit + ) + o.limit = nil + end + super + end + end + end +end diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb index 69c7736a4b..5ec811a53a 100644 --- a/lib/arel/visitors/to_sql.rb +++ b/lib/arel/visitors/to_sql.rb @@ -148,6 +148,10 @@ module Arel "#{visit o.left} > #{visit o.right}" end + def visit_Arel_Nodes_LessThanOrEqual o + "#{visit o.left} <= #{visit o.right}" + end + def visit_Arel_Nodes_LessThan o "#{visit o.left} < #{visit o.right}" end |