json2sql

A lightweight Python3 library for describing SQL statements using JSON

Is this project helpful? Send me a simple warm message!

Crossroad

Documentation

API design

input - text file, string, dict
kwargs

json2sql.json2sql()

TBD

json2sql.delete2sql()

TBD

json2sql.insert2sql()

TBD

json2sql.replace2sql()

TBD

json2sql.select2sql()

TBD

json2sql.update2sql()

TBD

Installation

There is required Python3 in version 3.4 or later:

$ pip3 install json2sql

Why was this library created?

The code was originally placed in fabric8-analytics project for instrumentation of jobs based on API requests or periodic jobs written in YAML/JSON config files. Code was extracted to provide basic JSON/YAML/dict to SQL conversion.

Under the hood

This project uses mosql under the hood for creating SQL statements. However it was not possible to use mosql to create more sophisticated queries (such as joins described by jobs or nested select queries). Check out mosql page for more details.

Name		Name	Last commit message	Last commit date
Latest commit History 12 Commits
json2sql		json2sql
test		test
.coafile		.coafile
.gitignore		.gitignore
.pylintrc		.pylintrc
.travis.yml		.travis.yml
CONTRIBUTORS.txt		CONTRIBUTORS.txt
LICENSE		LICENSE
MANIFEST.in		MANIFEST.in
Makefile		Makefile
README.md		README.md
coala_requirements.txt		coala_requirements.txt
dev_requirements.txt		dev_requirements.txt
json2sql-cli		json2sql-cli
requirements.txt		requirements.txt
setup.py		setup.py

License

fridex/json2sql

Folders and files

Latest commit

History

Repository files navigation

json2sql

Crossroad

Documentation

API design

json2sql.json2sql()

json2sql.delete2sql()

json2sql.insert2sql()

json2sql.replace2sql()

json2sql.select2sql()

json2sql.update2sql()

Installation

Why was this library created?

Under the hood

About

Topics

Resources

License

Stars

Watchers

Forks

Languages