tormysql 使用

创建连接池

https://pypi.org/project/TorMySQL/

import tornado.ioloop
from project_settings.db_settings import DBMysql

user = DBMysql[0]["user"]
host = DBMysql[0]["host"]
db = DBMysql[0]["db"]
password = DBMysql[0]["password"]
import tormysql
import pymysql.cursors

pool = tormysql.ConnectionPool(
    # max_connections=100,  # max open connections
    max_connections=500,  # max open connections
    idle_seconds=7500,  # conntion idle timeout time, 0 is not timeout
    wait_connection_timeout=600,  # wait connection timeout
    host=host,
    user=user,
    passwd=password,
    db=db,
    charset="utf8",
    cursorclass=pymysql.cursors.DictCursor # 获取的是字典形式， 没有这句获取的是元组
)

db_base

from yang_test.common.connect_pool import pool

from yang_test.common.base_model import BaseModel


# class DBBase(BaseModel):
class DBBase():
    def __init__(self, conn=None):
        self.conn = conn

    async def update_data(self, sql):
        """更新数据"""
        async with await pool.Connection() as conn:
            async with conn.cursor<