database tools;数据库操作
Project description
db-hammer
db-hammer 是个简单数据库工具库,在 Python DB-API上提供一些高级方法;方便大家经常做数据库查询。 目前已对 MySQL、Oracle、MSSQL、PostgreSQL 数据进行封装,封装其他结构化数据库也很简单。
Python Console
>>> from db_hammer.mysql import MySQLConnection
>>> db_conf = {"host": "10.0.0.10","user": "dbuser","pwd": "dbpassword","db_name": "db_name"}
>>> db = MySQLConnection(**db_conf):
>>> r = db.select_dict_list("select * from t_student")
>>> r
[{'name': '小明', 'sex': '男', 'age': 18, 'address': '湖南省长沙岳麓区', 'mobile': '13012345678'}, {'name': '小花', 'sex': '女', 'age': 16, 'address': '江苏省南京市鼓楼区', 'mobile': '13100000001'}]
Python With
from db_hammer.mysql import MySQLConnection
db_conf = {"host": "10.0.0.10","user": "dbuser","pwd": "dbpassword","db_name": "db_name"}
with MySQLConnection(**db_conf) as db:
i_sql = db.gen_insert_dict_sql(dict_data={
"name": "小白",
"sex": "男",
"age": "20",
"address": "上海市虹口区",
}, table_name="t_student")
db.execute(i_sql)
db.commit()
rs = db.select_dict_list(sql="select * from t_student")
print(rs)
连接其他数据库
from db_hammer.oracle import OracleConnection
from db_hammer.postgresql import PostgreSQLConnection
from db_hammer.mssql import MsSQLConnection
db_oracle = OracleConnection(**db_conf)
db_psql = PostgreSQLConnection(**db_conf)
db_mssql = MsSQLConnection(**db_conf)
数据库方法列表
# 根据sql获取页数
select_page_size(sql: str, page_size=50)
# 获取分页列表数据,列表字典形式返回
select_page_list(sql: str, page_size=50, page_start=1, **kwargs)
# 获取分页列表数据,列表字典形式返回
select_dict_page_list(sql: str, page_size=50, page_start=1, **kwargs)
# 获取第一列第一行的值
select_value(sql: str)
# 获取列表数据,列表方式返回
select_list(sql: str)
# 获取所有列表数据,列表字典形式返回
select_dict_list(sql: str)
# 获取第一行数据,字典形式返回
select_dict(sql: str)
# 执行SQL,并返回影响行数
execute(sql: str)
# 关闭连接
close()
# 回滚事务
rollback()
# 提交事务
commit()
# 根据字典生成 Insert SQL
gen_insert_dict_sql(dict_data: dict, table_name: str)
# 根据字典来生成 Update SQL
gen_update_dict_sql(dict_data: dict, table_name: str, where: str)
# 根据sql语句把数据生成 Insert SQL
select_insert_sql(sql: str, table_name: str)
其他小工具
# 执行本地命令
db_hammer.util.cmd
# 简单的日期转换
db_hammer.util.date
# 获取文件和目录工具(好用)
db_hammer.util.file
# 简单保存键值工具
db_hammer.util.keep
# 一个简单的收发邮件工具
db_hammer.util.sim_email
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-hammer-0.0.3.tar.gz
(41.4 kB
view hashes)
Built Distribution
db_hammer-0.0.3-py3-none-any.whl
(44.5 kB
view hashes)
Close
Hashes for db_hammer-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 084b03ce9bc4e2c9a9d0924f33534ae7575447fac7bf5295d2af3ccb2bc79af0 |
|
MD5 | 6d7451afc8c78634ae4f730bc95b4c23 |
|
BLAKE2b-256 | 2454aadfd70affc1549863e8948fc76a7be64b1b693a5af0bc1210e89d854abb |