dbtool 0.0.4

A lightweight db tools for sql.

dbtool

A lightweight db tools for sql.

pip install dbtool

# sqlite3 ....
db = dbtool.DB('sqlite', database=':memory:')

# sql
db.execute(sql)
db.execute_fetchone(sql)
db.execute_count(sql)
db.execute_cursor(sql)
db.execute_many(sql)
db.execute_script(sql)
db.execute_file(file)

# crud
db.insert(dict, table='user')
db.update(dict, table='user', id_name='id')
db.delete_by_id(1, table='user', id_name='id')
db.find_by_id(1, table='user', id_name='id')
db.find('user', type=0)
db.find_one('user', id=1)
db.find_count('user', type=0)

# transactions
with db.transaction():
    db.execute(sql1)

# example mysql
db_config = {
    'host': '127.0.0.1',
    'port': 3306,
    'database': 'test',
    'user': 'root',
    'password': '123456',
    'client_flag': CLIENT.MULTI_STATEMENTS,
}
db = dbtool.DB('mysql',  mincached=1, maxconnections=20, **db_config)

db vs driver

• sqlite - sqlite3
• mysql - pymysql
• postgresql - psycopg2
• sqlserver - pymssql

connections pool args: https://webwareforpython.github.io/DBUtils/main.html#pooleddb-pooled-db