Skip to main content

对 mysql-connector 的二次封装

Project description

说明

安装:

pip install mysql-lingling

1、作用

mysql 模块的再包装,并支持 with语法。

将使用简化抽象为:

  1. 连接数据库;
  2. 执行sql语句并获得返回结果;
  3. 关闭数据库(使用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.

Files for mysql-lingling, version 0.0.8
Filename, size File type Python version Upload date Hashes
Filename, size mysql_lingling-0.0.8-py3-none-any.whl (5.9 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size mysql_lingling-0.0.8.tar.gz (4.5 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page