建立连接

import torndb
db = torndb.Connection("127.0.0.1:3306", "test", user="root", password="admin")

然后运行一下，啊。报错了。

ModuleNotFoundError: No module named 'MySQLdb'

装个库

pip install mysql-python

恩，还是失败，参考这篇文章：
http://www.linuxfly.org/windows_install_mysql_python_library/

基本用法

看看下面这个例子就知道了:

def run(self):
    logging.debug("exec sql {} {}".format(self.sql, self.values))
    if "insert" in self.sql:
        return db.insert(self.sql, *self.values)
    if "select" in self.sql:
        data_list = db.query(self.sql, *self.values)
        obj_list = []
        for dbdata in data_list:
            obj = self.target_class()
            for dbdata_key in dbdata:                    
                obj.__dict__[dbdata_key] = dbdata[dbdata_key]
            obj_list.append(obj)
        return obj_list
    else:
        return db.execute(self.sql, *self.values)