The serviette package

[Tags:bsd3, json, jsontosql, library, sql]

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]


Versions,,,,,, (info)
Dependencies aeson, base (>=4.7 && <5), bytestring (>=0.9 && <0.11), generic-deriving, text (>=0.11 && <2.0), text-show [details]
License BSD3
Copyright 2017 Sasa Bogicevic
Author Sasa Bogicevic
Category Web
Home page
Source repository head: git clone
Uploaded Sat Jun 24 20:59:55 UTC 2017 by v0d1ch
Distributions NixOS:
Downloads 250 total (42 in the last 30 days)
0 []
Status Docs available [build log]
Last success reported on 2017-06-24 [all 1 reports]
Hackage Matrix CI




Maintainer's Corner

For package maintainers and hackage trustees

Readme for serviette

Readme for serviette-

SERVIETTE - JSON to SQL Build Status

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

    "selectName": "users",
          {"tablename":"addresses","field":"userid","operator":"=","withTable":"users", "withField":"id"},
          {"tablename":"posts","field":"userid","operator":"=","withTable":"users", "withField":"id"}
          {"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 =  join posts on userid =   where > 1","warnings":"","errors":""}

You can find this lib on hackage Serviette backend is here