def search(self, sql):
conn = self.connect()
cursor = conn.cursor()
log.log().logger.info(sql)
cursor.execute(sql)
values = cursor.fetchall()
# log.log().logger.info('values1 :', values)
cursor.close()
conn.close()
return values
def excutesql(self, sql):
log.log().logger.info(sql)
conn = self.connect()
cursor = conn.cursor()
cursor.execute(sql)
cursor.close()
try:
conn.commit()
except:
log.log().logger.info('commit error')
conn.close()
def insert(self, sql):
log.log().logger.debug(sql)
conn = self.connect()
cursor = conn.cursor()
cursor.execute(sql)
cursor.close()
try:
conn.commit()
except :
log.log().logger.error('commit error')
conn.close()
