mysql python 封装库

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() # 操作结束，关闭对象