def __init__(self):
print("DB Dependency Constructor")
config = {
'host': '127.0.0.1',
'user': '******',
'password': '',
'database': 'soa',
'autocommit': True
}
self.connection_pool = pymysqlpool.ConnectionPool(size=10,
name='DB Pool',
**config)
def __init__(self):
pymysqlpool.logger.setLevel('DEBUG')
config = {
'host': 'localhost',
'user': '******',
'password': '',
'database': 'azdna',
'autocommit': True
}
self._pool = pymysqlpool.ConnectionPool(size=10,
name='pool1',
**config)
def connectionpool(self):
config = {
'host': '172.31.20.34',
'user': '******',
'password': '******',
'database': 'odesk_visual_chameleon_sylius',
'autocommit': True
}
connPool = pymysqlpool.ConnectionPool(size=5,
name='connPool',
**config)
conn = connPool.get_connection()
cur = conn.cursor()
return connPool, conn, cur
def __connect(self):
try:
if self.__config:
load_dict = self.__config
else:
config = MysqlUtil._find("db_config.json",
os.path.abspath("."))
if not config:
common_path = os.path.dirname(os.path.abspath(__file__))
config = MysqlUtil._find("db_config.json", common_path)
with open(config, "r") as file:
load_dict = json.load(file)
return pymysqlpool.ConnectionPool(
size=self.pool_size,
cursorclass=pymysql.cursors.DictCursor,
**load_dict)
except Exception as e:
logger.error(traceback.format_exc())
logger.error("cannot create mysql pool")
def __init__(self, size=10, name="dbpool", config=None):
self.__pool = pymysqlpool.ConnectionPool(size, name, **config)
from logging import getLogger, root
logger = getLogger("asr")
SERVER_URL = os.getenv("SERVER_URL")
DB = os.getenv("DB")
USER_NAME = os.getenv("DB_USER_NAME")
PASSWORD = os.getenv("DB_USER_PASSWORD")
config = {
'host': SERVER_URL,
'user': USER_NAME,
'password': PASSWORD,
'database': DB,
'autocommit': True}
pool = pymysqlpool.ConnectionPool(size=10, name='pool', **config)
def get_db_connection():
return pool.get_connection(timeout=10)
def save(sqlstr):
with get_db_connection() as c:
cursor = c.connection.cursor()
cursor.execute(sqlstr)
def load():
with get_db_connection() as c:
cursor = c.connection.cursor(pymysql.cursors.DictCursor)
config.read('db.ini')
appid = 'wxd804ce3c79766b25'
secret = '370ed21807a52343a3de7f9ff9b474c3'
conn_config = {
'host': config['mysql']['host'],
'port': int(config['mysql']['port']),
'user': config['mysql']['usr'],
'password': config['mysql']['pwd'],
'database': config['mysql']['database'],
'autocommit': True
}
try:
# 初始化连接池
quizPool = pymysqlpool.ConnectionPool(size=int(
config['mysql']['pool_size']),
name='quizPool',
**conn_config) #初始化一个mysql连接池
conn = quizPool.get_connection() # 获取一个连接
cursor = conn.cursor() # 获取游标
cursor.execute('select VERSION()') # 执行sql语句mysql版本
quizPool.put_connection(conn) # 放回mysql连接，千万不能少
print('mysql version：', cursor.fetchone()[0]) # 结果
print('connPool size:', quizPool.size()) # 连接池大小
except Exception as e:
# 初始化失败
print(e)
print('数据库连接池初始化失败')
exit()
app = Flask(__name__)
#-----跨域----#
# MySQL
import pymysql, pymysqlpool
import pymysql.cursors
pymysqlpool.logger.setLevel('DEBUG')
myconfig = {
'host': config.mysql.host,
'user':config.mysql.user,
'password':config.mysql.password,
'database':config.mysql.db,
'cursorclass': pymysql.cursors.DictCursor,
'autocommit':True
}
connPool = pymysqlpool.ConnectionPool(size=5, name='connPool', **myconfig)
conn = connPool.get_connection(timeout=5, retry_num=2)
# OpenConnection
def openConnection():
global conn, connPool
try:
if conn is None:
conn = connPool.get_connection(timeout=5, retry_num=2)
except:
print("ERROR: Unexpected error: Could not connect to MySql instance.")
sys.exit()
async def sql_update_balances():
print('SQL: Updating all wallet balances')
