Library to execute query builder
Project description
Database Query Builder
- A library that serves as a means of connecting to a database and executing sql statements.
Installation 😀📚
pip install db_querybuilder
Get started
How to use Database Query Builder
from db_querybuilder import DatabaseQueryBuilder
class TestUser():
def __init__(self) -> None:
self.id = -1
self.first_name = 'Jhon'
self.last_name = 'Doe'
if __name__ == '__main__':
db = DatabaseQueryBuilder(db_user='root',db_password='',db_database='test',db_port=3306)
# Query to json
query = db.setTable('test_data').query().where(clausule='id',parameter=1).toJson()
print(query)
# Query select
query = db.select(['id','first_name']).from_('test_data').where('email','emaffini0@mlb.com').results()
print(query)
# Insert data with attributes object
user = TestUser()
query = db.insert(table='test_data',object=user)
print(query)
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
db-querybuilder-0.1.0.tar.gz
(4.8 kB
view hashes)
Built Distribution
Close
Hashes for db_querybuilder-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3bea79e4d5caacfa1df56ca0230dae25e063dcb1bdf465138698c46272881cf0 |
|
MD5 | a2f4db4bb34550672ad96aef72873d92 |
|
BLAKE2b-256 | 7b82b048eb8e69e613cf70dfa62b4d8470595ff6d4a06d8c76dd0df1bc821bab |