_ _ _ _
| | (_) | | |
__ _ _ _ ___ _ __ _ _ ______ | |__ _ _ _| | __| | ___ _ __
/ _` | | | |/ _ \ '__| | | | |______| | '_ \| | | | | |/ _` |/ _ \ '__|
| (_| | |_| | __/ | | |_| | | |_) | |_| | | | (_| | __/ |
\__, |\__,_|\___|_| \__, | |_.__/ \__,_|_|_|\__,_|\___|_|
| | __/ |
|_| |___/
sql query builder library for crystal-lang
Add this to your application's shard.yml
:
dependencies:
query-builder:
github: izniburak/query-builder
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"
Documentation Page: query-builder Docs
- Fork it ( https://github.com/izniburak/query-builder/fork )
- Create your feature branch (git checkout -b my-new-feature)
- Commit your changes (git commit -am 'Add some feature')
- Push to the branch (git push origin my-new-feature)
- Create a new Pull Request
- izniburak İzni Burak Demirtaş - creator, maintainer