def getListCache(self, key):
dataList = []
try:
dataList = self.__redisClient.lrange(key, 0, -1)
except Exception, e:
Loger.error(e, __file__)
raise e
def __endTransaction(self):
try:
if self.__cnx:
self.__cnx.close()
except Exception, e:
Loger.error(e, __file__)
raise e
def setListCache(self, key, values):
try:
self.__redisClient.delete(key)
for value in values:
self.__redisClient.rpush(key, value)
except Exception, e:
Loger.error(e, __file__)
raise e
def __init__(self):
super(CacheManager, self).__init__()
try:
pool = redis.ConnectionPool(host=Config.CACHE_HOST,
port=Config.CACHE_PORT,
db=0,
password=Config.CACHE_PASSWORD)
self.__redisClient = redis.Redis(connection_pool=pool)
except Exception, e:
Loger.error(e, __file__)
raise e
pass
def executeSingleQueryWithArgs(self, strsql, args, dictionary=True):
""" 查询 单条sql语句"""
results = None
try:
cnx = self.__cnxpool.get_connection()
cursor = cnx.cursor(dictionary=dictionary)
cursor.execute(strsql, args)
results = cursor.fetchall()
cursor.close()
except Exception as e:
Loger.error(e, __file__)
raise e
finally:
if cnx:
cnx.close()
return results
def executeSingleDmlWithArgs(self, strsql, args):
""" insert update delete 单条sql语句"""
results = True
try:
cnx = self.__cnxpool.get_connection()
cursor = cnx.cursor()
cursor.execute(strsql, args)
cursor.close()
cnx.commit()
except Exception as e:
Loger.error(e, __file__)
results = False
raise e
finally:
if cnx:
cnx.close()
return results
def executeTransactionDmlWithArgs(self, strsql, args):
"""事务下 insert update delete 单条sql语句"""
results = True
self.__startTransaction()
try:
cursor = self.__cnx.cursor()
cursor.execute(strsql, args)
cursor.close()
self.__commitTransaction()
except Exception as e:
Loger.error(e, __file__)
results = False
self.__rollbackTransaction()
raise e
finally:
self.__endTransaction()
return results
def executeTransactionMutltiDml(self, sqlList):
"""事务下 insert update delete 多条sql语句"""
results = True
self.__startTransaction()
try:
cursor = self.__cnx.cursor()
for strsql in sqlList:
cursor.execute(strsql)
cursor.close()
self.__commitTransaction()
except Exception as e:
Loger.error(e, __file__)
results = False
self.__rollbackTransaction()
raise e
finally:
self.__endTransaction()
return results
def executeTransactionQueryWithArgs(self, strsql, args, dictionary=True):
""" 事务下查询sql语句"""
results = None
self.__startTransaction()
try:
cursor = self.__cnx.cursor(dictionary=dictionary)
cursor.execute(strsql, args)
results = cursor.fetchall()
cursor.close()
self.__commitTransaction()
except Exception as e:
Loger.error(e, __file__)
self.__rollbackTransaction()
raise e
finally:
self.__endTransaction()
return results
def __init__(self):
''''' Constructor '''
dbconfig = {
"user": Config.DBUSER,
"password": Config.DBPWD,
"host": Config.DBHOST,
"port": Config.DBPORT,
"database": Config.DBNAME,
"charset": Config.DBCHAR
}
try:
self.__cnxpool = mysql.connector.pooling.MySQLConnectionPool(
pool_size=Config.DBPOOLSIZE,
pool_reset_session=True,
**dbconfig)
except Exception as e:
Loger.error(e, __file__)
raise e
def executeTransactionMutltiDmlWithArgsList(self, sqlList, argsList):
"""事务下 insert update delete 多条sql语句
argsList 数量与 sqlList数量一致，若无，则该条sql对应为[]
"""
results = True
self.__startTransaction()
try:
cursor = self.__cnx.cursor()
index = 0
for strsql in sqlList:
args = argsList[index]
cursor.execute(strsql, args)
index += 1
cursor.close()
self.__commitTransaction()
except Exception as e:
Loger.error(e, __file__)
results = False
self.__rollbackTransaction()
raise e
finally:
self.__endTransaction()
return results
def __startTransaction(self):
try:
self.__cnx = self.__cnxpool.get_connection()
except Exception as e:
Loger.error(e, __file__)
raise e
def __commitTransaction(self):
try:
self.__cnx.commit()
except Exception as e:
Loger.error(e, __file__)
raise e
def getStringCache(self, key):
value = None
try:
value = self.__redisClient.get(key)
except Exception, e:
Loger.error(e, __file__)
def setStringCache(self, key, value):
try:
self.__redisClient.set(key, value)
except Exception, e:
Loger.error(e, __file__)
raise e
def setCache(self, key, value, expire=Config.CACHE_EXPIRE):
try:
self.__redisClient.setex(key, value, time=expire)
except Exception, e:
Loger.error(e, __file__)
raise e
def __rollbackTransaction(self):
try:
self.__cnx.rollback()
except Exception as e:
Loger.error(e, __file__)
raise e