query-builder

                                         _           _ _     _           
                                        | |         (_) |   | |          
   __ _ _   _  ___ _ __ _   _   ______  | |__  _   _ _| | __| | ___ _ __
  / _` | | | |/ _ \ '__| | | | |______| | '_ \| | | | | |/ _` |/ _ \ '__|
 | (_| | |_| |  __/ |  | |_| |          | |_) | |_| | | | (_| |  __/ |   
  \__, |\__,_|\___|_|   \__, |          |_.__/ \__,_|_|_|\__,_|\___|_|   
     | |                 __/ |                                           
     |_|                |___/                                            

sql query builder library for crystal-lang

Installation

Add this to your application's shard.yml:

dependencies:
  query-builder:
    github: izniburak/query-builder

Usage

require "query-builder"
builder = Query::Builder.new

p builder.table("test").where("id", 17).or_where("language", "crystal").get

# Output:
# "SELECT * FROM test WHERE id = '17' OR language = 'crystal' LIMIT 1"


p builder.table('test').select('id, title, status').order_by('id', 'desc').limit(10).get_all
# Output:
# "SELECT id, title, status FROM test ORDER BY id DESC LIMIT 10"

Docs

Documentation Page: query-builder Docs

Contributing

1. Fork it ( https://github.com/izniburak/query-builder/fork )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create a new Pull Request

Contributors

• izniburak İzni Burak Demirtaş - creator, maintainer