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())