def exec_mysql(self, sql): try: conn = MySQLdb.connect(self.host, self.port, self.user, self.password, self.database) cur = conn.cursor() if cur: appiumautolog().info(u"执行SQL语句|%s|" %sql) resList = cur.execute(sql) return resList except Exception, e: appiumautolog().error(e)
def exec_mssql(self, sql): try: conn = pymssql.connect(host = self.host, port = self.port, user = self.user, password = self.password, database = self.database, charset="utf8") cur = conn.cursor() if cur: appiumautolog().debug(u"执行SQL语句|%s|" %sql) cur.execute(sql) rows = cur.fetchall() if len(rows) == 0: appiumautolog().warning(u"没有查询到数据") else: appiumautolog().debug(u"返回执行结果%s" %rows) return rows else: appiumautolog().error(u"数据库连接不成功") conn.close() except Exception, e: appiumautolog().error(e)