db-querybuilder 0.1.1

Library to execute query builder

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

It is very important to make the connection to the database that we are going to use.

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','[e-mail]').results()

    print(query)



    # Insert data with attributes object

    user = TestUser()

    query = db.insert(table='test_data',object=user)

    print(query)