NQL
Natural Query Language built on top of ActiveRecord and Ransack
Installation
Add this line to your application's Gemfile:
gem 'nql'
And then execute:
$ bundle
Or install it yourself as:
$ gem install nql
Supported comparators
----------------------------------
| Symbol | Description |
----------------------------------
| : | Contains |
| = | Equals |
| != | Not equals |
| > | Grater than |
| >= | Grater or equals than |
| < | Less than |
| <= | Less or equals than |
----------------------------------
Usage
Converts from natural language to query expression
q = '(name: arg | name: br) & region = south'
Country.search(NQL.to_ransack(q)).result.to_sql
=> "SELECT coutries.* FROM countries WHERE (countries.name LIKE '%arg%' OR countries.name LIKE '%br%') AND region = 'south'"
Joins support
q = 'cities.name: buenos'
Country.search(NQL.to_ransack(q)).result.to_sql
=> "SELECT countries.* FROM countries LEFT OUTER JOIN cities ON countries.id = cities.country_id WHERE cities.name LIKE '%buenos%'"
Contributing
- Fork it
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Added some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create new Pull Request