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

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page