A lightweight db tools for sql.
Project description
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
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
dbtool-0.0.4.tar.gz
(4.4 kB
view hashes)
Built Distribution
dbtool-0.0.4-py3-none-any.whl
(5.2 kB
view hashes)