YqlQuery

A simple YQL query generation library written in ruby, providing a chainable query builder capable of generating the most complex query conditions you can throw at it.

(sudo) gem install yql-query

http://rdoc.info/gems/yql-query

yql-query's primary interface is the Builder class. Once you've instantiated a builder, you can pretty much generate whatever query you'd like using it.

builder = YqlQuery::Builder.new
builder.table('music.artists')

to generate a query, the Builder class provides a number of methods to construct it's arguments:

builder.table('music.artists')
builder.select('name, genre')
builder.conditions("bands = 'false'")
builder.sort('age')

conditions are also aliased as 'where':

#using 'where'
builder.where("bands = 'true'")

# is the same thing as
builder.conditions("bands = 'true'")

conditions can be passed as either a string, an array or

builder.conditions(["name = 'Erykah Badu'", "release_year > '2005'"])

methods can be chained together:

builder.table('music.artists').select('name').where("genre = 'jazz'")

to generate the query, just call to_s or to_query:

builder.to_s
# => 'select * from tablename...'

builder.to_query
# => 'select * from tablename...'

passing a hash with a Builder instance to creates sub-select:

guid_query = Builder.new.table('users').select('guid').where("role = 'admin'")

builder = Builder.new.table('actions).where(:guid => guid_query)
builder.to_s
# => "select * from actions where guid in (select guid from users where role = 'admin')"

The full list of methods available:

table('music.albums')
use('http://somedomain.com/table.xml', 'othersource')
select('name')
conditions("genre = 'jazz'")
sort('albumName')
sort_descending('albumName')
limit(5)
offset(10)
tail(5)
truncate(10)
unique('format')
sanitize('description')
remote(10, 30) # remote limits and offsets

Refer to the documentation for complete usage and more examples.

• Fork the project.
• Make your feature addition or bug fix.
• Add tests for it. This is important so I don't break it in a future version unintentionally.
• Commit, do not mess with rakefile, version, or history. (if you want to have your own version, that is fine but bump version in a commit by itself I can ignore when I pull)
• Send me a pull request. Bonus points for topic branches.

Copyright (c) 2011 Steve Agalloco. See LICENSE for details.