| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
| |
Here `offset` is bound twice. It used to be `:b1` appeared twice.
This commit changes the second `offset` name changed from `:b1` to `:b3`
which should not affect the actual bind values for offset.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
This is part of a greater refactoring to have the `BindParam` nodes hold
onto their values. We want to generally keep the AST decoupled from what
you're actually doing with those values, but ultimately the usage of
`BindParam` is almost identical to how you'd use `Casted` or `Quoted`.
Forcing consumers of Arel's API to maintain the bind values separately
from the AST makes manipulating the AST essentially impossible, as you
would need to perform a full walk of the AST to determine whether a
given node contains bind parameters, and which value it maps to.
By storing the value on the bind parameter directly, we can collect them
in another AST pass (realistically it'll be part of the same pass that
performs SQL construction for performance reasons). This will
dramatically simplify AST manipulation for Rails or any other consumers
that work with bind params.
As part of this change I've removed the `BindVisitor`, which appears to
be dead code, and had tests break from this change.
|
|\
| |
| | |
Make Visitor visit thread safe by holding dispatch method reference
|
| | |
|
| |
| |
| |
| |
| |
| |
| | |
This reverts commit 6d105c7f891a14316eab47dfff3bf1b94f3204e7, reversing
changes made to 437aa3a4bb8ad4f3f4eba299dbb1112852f9c7ac.
This broke Active Record when the values are sql literals
|
| | |
|
|\ \
| |/
|/| |
named functions compared to nil
|
| | |
|
|/ |
|
| |
|
| |
|
|\
| |
| | |
Add Arel::Nodes::Casted to dot visitor
|
| |
| |
| |
| |
| |
| |
| | |
Adds casted node to the dot visitor with outgoing edges to val and
attribute.
Fixes #419
|
|\ \
| | |
| | | |
Freeze all the strings in visitors
|
| | | |
|
|/ / |
|
|/
|
|
|
|
|
|
|
| |
Since BindParam has no value, treating it like a string
causes it to fallback to Object#to_s, leading to output like
`#<Arel::Nodes::BindParam:0x007fa43c866108>`.
Since angle brackets are significant in Dot labels, this causes
`Error: bad label format` when passing the graph into dot.
|
|\
| |
| | |
Fix issue #415 - Should Arel::Nodes::True.new() be 1 in sqlite3?
|
| | |
|
|\ \
| | |
| | | |
Support Oracle bind parameter value for Oracle12 visitor
|
| |/ |
|
|\ \
| | |
| | | |
PG: Add Support for GroupBy's Cube, Rollup and Grouping Set
|
| | |
| | |
| | |
| | | |
Visitor
|
|/ /
| |
| |
| |
| |
| |
| | |
it would generates `SELECT ... FETCH FIRST n ROWS ONLY FOR UPDATE`
which causes Oracle 12c database returns this error :
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
|
|/ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
*** Individual commit messages included below ***
* Preliminary support for bitwise operations as infix operators. Tests to follow.
* Added bitwise xor, shift left and shift right operators
* Fixed the BitwiseOr class so it uses the :| operator instead of :&
* All the methods for the bitwise operators in the Arel::Math module now wrap them up in Arel::Nodes::Grouping so the operation becomes isolated like addition and subtraction
* Preliminary set of tests for the new operators
* Updated README with examples of bitwise operations
* Added a new UnaryOperation class which is a riff on the InfixOperation class
* Added tests for UnaryOperation (inspired by InfixOperation tests)
* Added the bitwise not (~) operator as a UnaryOperation
* Added tests for the bitwise not operator
* Added documentation for the bitwise not operator
* Updated gemspec using `rake arel.gemspec`
|
| |
|
| |
|
|\
| |
| | |
Improve error message when passed unsupported type
|
| | |
|
|\ \
| | |
| | | |
No need to quote limit for Oracle12 visitor
|
| |/ |
|
| | |
|
| | |
|
| | |
|
| |
| |
| |
| |
| |
| |
| | |
Explicitly declare if this is case sensitive or not
currently postgres assumes case insensitive regexp
no other databases support regexps
|
|/
|
|
|
|
|
| |
Explicitly declare if this is case sensitive or not
most implementation assume case sensitive
postgres assumes case insensitive
|
|\
| |
| | |
Support Oracle 12c top-N query
|
| |
| |
| |
| | |
to support `FETCH FIRST n ROWS` and `OFFSET` for Oracle 12c database
|
|/ |
|
|
|
|
|
| |
Refernce:
https://technet.microsoft.com/en-us/library/ms175486%28v=sql.105%29.aspx
|
|
|
|
|
|
| |
These two clauses have nearly identical semantics with regards to how
they would be constructed as an AST. It doesn't make sense for their
interfaces to be separate.
|
|
|
|
|
| |
to_SQL already has supported the ESCAPE clause in #318.
PostgreSQL can use the ESCAPE clause too.
|
|
|
|
|
|
| |
This constructor parameter was unused for everything except the
convenience methods `to_sql` and `where_sql`. We can pass the engine
into those methods directly.
|
|
|
|
|
|
|
| |
The only place this method was still used is on the MSSQL visitor. The
visitor has all of the objects required to inline this lookup there.
Since the `primary_key` method on the connection adapter will perform a
query when called, we can cache the result on the visitor.
|
| |
|
| |
|
|
|
|
|
|
|
|
| |
The only reason we're using strings is to pre-populate the cache, but
`Class#name` returns a new string instance on every call. This is a
pretty major source of memory usage. We don't technically need to
pre-populate the cache, and not doing so allows us to go back to using
cache objects
|
|
|
|
|
|
|
|
|
|
|
|
| |
This removes the need for us to do the re-ordering by walking the AST in
ActiveRecord. We're using a block to communicate with the collector,
since the collector needs to be the thing which knows about the index,
while the visitor is the thing that needs to know the syntax. The
BindParam needs to know about neither of these things, so it's been
changed to stop being a subclass of SqlLiteral
I could also see an alternative implementation using format strings if
for some reason blocks cause a problem.
|