对 mysql-connector 的二次封装
Project description
说明
安装:
pip install mysql-connector
1、作用
mysql
模块的再包装,并支持 with语法。
将使用简化抽象为:
- 连接数据库;
- 执行sql语句并获得返回结果;
- 关闭数据库(使用with的时候可以省略);
2、示例
示例1(with语法)
# 连接数据库
with MySQLTool(user=user, password=pw, database=database) as m2:
# 执行sql并获得返回结果
result2 = m2.run_sql([
['insert person(name, age) values ("李四", 20), ("王五", 30)'],
['select * from person']
])
# 打印结果
print(result2)
示例2(普通语法,建议使用专有语法,这里是通用语法示例)
m = MySQLTool()
# 查看mysql容器内 ip,参考这个链接:https://blog.csdn.net/CSDN_duomaomao/article/details/75638544
m.connect(user=user,
password=pw,
# host=ip,
database=database)
result = m.run_sql([
['insert person(name,age) values (%s, %s)', ['六六六', 666]],
['select * from person']
])
print(result)
m.close()
示例3(同时插入多行数据)
with MySQLTool(user=user, password=pw, database=database, host=host) as m2:
# 执行sql并获得返回结果
result2 = m2.insert_more_rows(
'INSERT INTO key_value (k, val, creator_id, user_id, status) values (%s, %s, %s, %s, %s)',
[
('c', 'AAA', 1, '1', 0),
('d', 'BBB', 1, '1', 0)
]
)
if result2 is not False:
print('success')
else:
print('error!')
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
mysql_lingling-0.0.5.tar.gz
(4.3 kB
view hashes)
Built Distribution
Close
Hashes for mysql_lingling-0.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 35ed0b5e066dca737279eb493018152e9d69e5f1568980f9e4817c1785bd6bed |
|
MD5 | 6bcc87c6ffe53f73404f2a2a688a992f |
|
BLAKE2b-256 | 9fa56ca92eb9593c56df407eba5d8b3642c63da504bb02f60ee8bbfbd1c27af4 |