def connect(self):
"""
连接数据库
语法: cx_Oracle.connect('username','pwd','IP/HOSTNAME:PORT/TNSNAME')
或
cx_Oracle.makedsn(IP,PORT,TNSNAME)
cx_Oracle.connect(username,pwd,dsn)
"""
try:
dsn = cx_Oracle.makedsn(self.__host, self.__port, self.__tnsname)
conn = cx_Oracle.connect(self.__username, self.__password, dsn)
# self.__conn = cx_Oracle.connect(self.__username, self.__password,
# self.__host + ':' + self.__port + '/' + self.__service_name)
return conn
except Exception as err:
logger.error(err)
def connect(self):
"""
连接数据库
语法: MySQLdb.connect(host=主机地址, port=端口, user=用户名, passwd=密码, db=库)
"""
try:
conn = pymysql.connect(host=self.host,
port=self.port,
user=self.user,
passwd=self.password,
db=self.db,
charset='utf8',
connect_timeout=self.timeout)
return conn
except Exception as err:
logger.error(err)
def connect(self):
"""
:return: 连接redis
"""
try:
if self.password is None:
pool = redis.ConnectionPool(host=self.host,
port=self.port,
db=self.db)
else:
pool = redis.ConnectionPool(host=self.host,
port=self.port,
db=self.db,
password=self.password)
r = redis.Redis(connection_pool=pool)
return r
except Exception as err:
logger.error(err)
def __del__(self):
logger.error("关闭mysql链接")
self.close()
def execute_sql(self, sql):
try:
self.cursor.execute(sql)
except Exception as err:
logger.error(err)