A sql wrapper made to mimic the pymongo syntax in order to simplify sql syntax.
Project description
A sql wrapper made to mimic the pymongo syntax in order to simplify sql syntax.
Docs
Usage
from pymongo_the_sql.pymongo_the_sql import PyMongoTheSql PyMongoTheSql("../tests/test.sqlite3") <pymongo_the_sql.pymongo_the_sql.PyMongoTheSql object at 0x7f60878e8e80> client = PyMongoTheSql("../tests/test.sqlite3") client = PyMongoTheSql("../tests") db = client.get_database("test") db["users"] <pymongo_the_sql.pymongo_the_sql.PyMongoTheSql object at 0x7f6087763400> users = db["users"] users.find({"id": "1"})
Api
Update
Updates values for all specified columns where the conditions are True.
update(columns\_values: dict, conditions: dict[Optional], operator: str[Optional]) -> bool
Updates values for all specified columns where the conditions are True. Use the values tuple to update Blob type objects.
update\_blob(columns\_values: dict, values: tuple[Optional], conditions: dict[Optional], operator: str[Optional])
Updates values for all specifed columns on the first row where the conditions are True.
update\_one(columns\_values: dict, conditions: dict[Optional])
Updates values for all specified columns on every row.
update\_all(columns\_values: dict[Optional]) -> bool
Find
Returns the specified columns on all rows the conditions are True.
find(conditions: dict, columns: dict, operator: str) -> dict
Returns the specified columns on the first row the conditions are True.
find\_one(conditions: dict, columns: list, operator: str) -> dict
Returns the whole table. find_all() -> dict
Returns the specified columns on the last row the conditions are True.
find\_last(conditions: dict[Optional], columns: list[Optional], operator: str[Optional]) -> dict
Returns how many rows in the table. find_all_and_count() -> int
Returns how many rows the conditions are True.
find\_and\_count(conditions: dict[Optional], columns: list[Optional], operator: str[Optional]) -> int
Insert
Inserts the values in the specified columns. insert(columns\_values: dict) -> bool
Project details
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 pymongo_the_sql-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b8183dd1c36dfaa1e5c22876335a193d92ef5834ba8718a00eb4c5fe21e7cbe4 |
|
MD5 | edfe6221b8210db86644530797797af2 |
|
BLAKE2b-256 | 892539bca6c0beef3b163101862dd488f33022fb152e332318f8a119c3e40390 |