def setUp(self):
self.d = getDriver()
self.d.get(YamlReader().data['global']['corp']['url'])
self.login = LoginOutObj(self.d)
self.mdObj=Moudle_dataFill_overall_mn_dailyFill(self.d)
self.naviObj = NavigateObj(self.d)
self.login.Login(YamlReader().data['global']['corp']['user'], YamlReader().data['global']['corp']['pass'])
def setUp(self):
self.d= getDriver()
self.d.get(YamlReader().data['BAIDU']['INFO']['url'])
self.login=BaiduObj(self.d)
self.conf=YamlReader().data
class MySuite(unittest.TestCase):
driver = webdriver.Chrome(executable_path=CHROMEDRIVER)
conf = YamlReader().data
caseList = conf['suite']['oper']
def doSearch(self, sql="select version()"):
resArry = []
self.cur.execute(sql)
for i in self.cur:
resArry.append(i)
return resArry
def doUpdate(self, sql=""):
pass
def doDelete(self, sql=""):
pass
def doInseart(self, sql="", textPath=""):
pass
def __del__(self):
self.cur.close()
self.conn.close()
if __name__ == '__main__':
conf = YamlReader().data
# print(conf["mysqldb"]["ip"],conf["mysqldb"]["port"],conf["mysqldb"]["username"],conf["mysqldb"]["password"])
conn = mysqlSearch(conf["mysqldb"]["ip"], conf["mysqldb"]["port"],
conf["mysqldb"]["username"],
conf["mysqldb"]["password"],
conf["mysqldb"]["defaultDB"])
print(conn.doSearch(sql=conf["dbQueries"]["statisticSearch"]["sql"]))
# print(conn.doSearch())