serviette: JSON to Sql
This is a package candidate release! Here you can preview how this package release will appear once published to the main package index (which can be accomplished via the 'maintain' link below). Please note that once a package has been published to the main package index it cannot be undone! Please consult the package uploading documentation for more information.
Use json to generate simple sql queries. I needed this for the work project and decided to implement it also in haskell. This could be used to query the database directly from frontend.
[Skip to Readme]
Properties
| Versions | 0.1.0.0, 0.1.0.1, 0.1.0.2, 0.1.0.3, 0.1.0.4, 0.1.0.5, 0.1.0.6, 0.1.0.6 |
|---|---|
| Change log | None available |
| Dependencies | aeson, base (>=4.7 && <5), bytestring (>=0.9 && <0.11), generic-deriving, text (>=0.11 && <2.0), text-show [details] |
| License | BSD-3-Clause |
| Copyright | 2017 Sasa Bogicevic |
| Author | Sasa Bogicevic |
| Maintainer | brutallesale@gmail.com |
| Category | Web |
| Home page | https://github.com/v0d1ch/serviette#readme |
| Source repo | head: git clone https://github.com/v0d1ch/serviette |
| Uploaded | by v0d1ch at 2017-06-24T20:59:18Z |
Modules
[Index]
Downloads
- serviette-0.1.0.6.tar.gz [browse] (Cabal source package)
- Package description (as included in the package)
Maintainer's Corner
Package maintainers
- No current members of group
For package maintainers and hackage trustees
Readme for serviette-0.1.0.6
[back to package description]SERVIETTE - JSON to SQL 
Library for generating SQL queries from JSON. Send the json in the expected format and receive raw sql string.
Why ?
- Why not ?
Expected JSON format
{
"format":1,
"action":"SELECT",
"selectName": "users",
"joinTables":[
{"tablename":"addresses","field":"userid","operator":"=","withTable":"users", "withField":"id"},
{"tablename":"posts","field":"userid","operator":"=","withTable":"users", "withField":"id"}
],
"whereCondition":[
{"whereTableName":"users","whereField":"id", "whereOperator":">", "whereFieldValue": 1}
]
}
If format is set to 1 you will get json response:
{"response":"SELECT users join addresses on userid = users.id join posts on userid = users.id where users.id > 1","warnings":"","errors":""}