Convert raw SQL to Pypika Objects
Reason this release was yanked:
logger initialized incorrectly
Project description
sql_to_pypika
Helper util for converting raq SQL expressions to PyPika objects. This is neither comprehensive nor perfect. My hope with creating a repo for this is that if people are interested then we can expand on this from here.
Usage
tables = [("foo", "foo"), ("bar", "b")]
evaluator = ExpressionEvaluator(tables)
result = evaluator.eval("foo.fizz = 1")
print(result) # "foo"."fizz"=1'
type(result) # pypika.terms.BasicCriterion
result = evaluator.eval("bar.fizz = 1")
print(result) # "b"."fizz"=1'
type(result) # pypika.terms.BasicCriterion
Disclaimer
The logic was initially created by @twheys, the creator of PyPika (gist) via this conversation.
I went ahead and cleaned it up and added some tests so I could use it for my own needs.
Dev / CI
This repo utilize Poetry, for package management. I recommend reading the Poetry install instructions here.
You can then simply run:
poetry install
We use pytest
and Black
for testing and linting respectively. You can use the scripts in the scripts folder to run them.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sql_to_pypika-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a30a5338b8755cf169655a14b4b5e930b514755bc1adfc47604a914037c0b83 |
|
MD5 | 6ac6161893b93ee49f41b6befca9da32 |
|
BLAKE2b-256 | 4034587841748f4455b3635472cdb6efba1cf95628c694060a7dd568a8795120 |