https://www.cnblogs.com/dfcao/p/lightweight-python-mysql-class.html
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from LightMysql import LightMysql
# def dbHelp():
if __name__ == '__main__':
# 配置信息,其中host, port, user, passwd, db为必需
dbconfig = {'host':'127.0.0.1',
'port': 3306,
'user':'root',
'passwd':'root',
'db':'sqlinsee',
'charset':'utf8'}
db = LightMysql(dbconfig) # 创建LightMysql对象,若连接超时,会自动重连
# 查找(select, show)都使用query()函数
sql_select = "SELECT * FROM urlList"
result_all = db.query(sql_select) # 返回全部数据
result_count = db.query(sql_select, 'count') # 返回有多少行
result_one = db.query(sql_select, 'one') # 返回一行
# 增删改都使用dml()函数
# sql_update = "update Customer set Cost=2 where Id=2"
# sql_insert = "insert urlList "
sql_insert = """INSERT INTO urlList(url,
isCheck,checkResult)
VALUES ('http://baidu.com', 0, 0)"""
result_update = db.dml(sql_insert)
# sql_delete = "delete from Customer where Id=2"
# result_delete = db.dml(sql_delete)
db.close() # 操作结束,关闭对象