rql
rql copied to clipboard
Add IN and NIN support
First attempt https://github.com/a8m/rql/pull/10/
The equality fn for the test doesn't like comparing slices because its deep, not sure what we want to do there.
Looking at integration testing next.
resolves https://github.com/a8m/rql/issues/8
due to how args are handled by sql.query, this needs to be changed a bit.
Currently assuming the parser receives valid rql it produces something like Select * FROM table WHERE id > ? and name IN (?)
, and args would contain a slice as an argument [5, [1,2]]
. .query
wants something more like Select * FROM table WHERE id > ? and name IN (?, ?)
and args to be flat [5,1,2]
.
related: https://stackoverflow.com/questions/20271123/how-to-execute-an-in-lookup-in-sql-using-golang/32837541
updated to support multiple ?
placeholders, added working integration tests, currently could use some clean up and the tests are broken, not sure why.
Any news about this feature ? Thanks
updated to support multiple
?
placeholders, added working integration tests, currently could use some clean up and the tests are broken, not sure why.
If you give me access to your fork, I can help you
I'll take another stab at this pending review for https://github.com/a8m/rql/pull/49