Python package for converting JSON objects into SQL filter expressions using rust
from datetime import datetime
import jsql
def test_mysql():
input = {
"name": "apple",
"date": {"$gt": datetime(2024, 2, 1), "$lt": datetime(2024, 2, 10)},
"$or": [{"colour": "red"}, {"colour": "green"}],
}
sql, params = jsql.mysql(input)
assert sql == "`name` = ? and `date` > ? and `date` < ? and (`colour` = ? or `colour` = ?)", sql
assert params == ("apple", datetime(2024, 2, 1, 0, 0), datetime(2024, 2, 10, 0, 0), "red", "green")
- MySQL
- ClickHouse
- MongoDB
- ElasticSearch