def login(): retObj = {} retObj['telephone'] = "12345000000" retObj['password'] = "******" postStr = json.dumps(retObj) r = requests.post("http://192.168.3.80:21012/userLogin", headers=headers, data=postStr, verify=False) lxLog.getDebugLog()(r.text)
def run(self): mysqlConfig = { 'host': '127.0.0.1', 'user': '******', 'password': '******', 'port': 3306, 'database': 'tmj', 'charset': 'utf8' } mysqlConn = pymysql.connect(**mysqlConfig) mysqlCursor = mysqlConn.cursor() while True: logInfo = "" try: if q.empty(): break R.acquire() result = q.get() R.release() print(result) corpid = str(result[0]) logInfo = corpid detailUrl = 'http://gcxm.hunanjs.gov.cn/AjaxHandler/PersonHandler.ashx?method=getCorpDetail&corpid=' + corpid + '&isout=' response = requests.get(detailUrl) j = json.loads(response.text) if 0 == j['code']: saveCompany(corpid, j, mysqlCursor) except Exception as e: lxLog.getDebugLog()(str(e)) lxLog.getDebugLog()(logInfo) finally: pass
def createHeadImage(phone): try: color = (random.randint(0, 255), random.randint(0, 255), random.randint(0, 255), random.randint(0, 255)) new_image(300, 300, phone, color=color, show_image=False) except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err))
def run(self): config = { 'host': 'drdshbgav95e0z5apublic.drds.aliyuncs.com', 'user': '******', 'password': '******', 'port': 3306, 'database': 'test_base_user', 'charset': 'utf8' } conn = mysql.connector.connect(**config) cursor = conn.cursor() index = 0 phonePrefix = '%d%03d' % (_PhonePrefix, self.threadID) queryCountSql = "select count(*) from base_user where telephone like '{}%'".format( phonePrefix) cursor.execute(queryCountSql) data = cursor.fetchone() countZero = False if 1000 == data[0]: lxLog.LOG_DEBUG(u"%s已经有1000条记录", phonePrefix) return elif 0 == data[0]: countZero = True cursor.execute("begin") while index < 1000: phone = '%d%03d%03d' % (_PhonePrefix, self.threadID, index) if index % 100 == 0: lxLog.getDebugLog()(u"处理手机号码:%s", phone) try: if countZero: sql_query = "INSERT INTO `base_user` SET password = '******'" \ ", telephone = '" + phone + "'" \ ", resister_come = 1, login_fail_cnt = 0, user_status = 0, reg_time = NOW()" cursor.execute(sql_query) else: sql_query = "select user_id from base_user where telephone = '" + phone + "' " cursor.execute(sql_query) exist = False for user_id in cursor: exist = True break if False == exist: sql_query = "INSERT INTO `base_user`.`base_user` SET password = '******'" \ ", telephone = '" + phone + "'" \ ", resister_come = 1, login_fail_cnt = 0, user_status = 0, reg_time = NOW()" cursor.execute(sql_query) except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err)) finally: index = index + 1 cursor.execute("commit") #必须在事务后执行 QueueSql = " insert into base_sync_quee (user_id,telephone,nickname,type,cnt,next_syns_time) "\ " select user_id,telephone,telephone,1,0,now() from base_user where telephone like '{}%'"\ .format(phonePrefix) cursor.execute(QueueSql)
def getGreaterThan500(): suitableCompanyObj = open(suitableCompany, 'r+', encoding='utf-8') greaterThan500Obj = open(greaterThan500, 'w+', encoding='utf-8') lines = suitableCompanyObj.readlines() for line in lines: try: line = line.strip() if len(line) > 0: result = line.split('\t') print(line) corpid = str(result[0]) pageIndex = 1 fitCompany = False projectInfo = '' while True: getProjectListUrl = 'http://gcxm.hunanjs.gov.cn/AjaxHandler/PersonHandler.ashx?method=getProjectList&corpid=' \ + corpid + '&corptype=0&pageSize=10&pageIndex=' + str(pageIndex) projectResponse = requests.get(getProjectListUrl) projectResult = projectResponse.text j = json.loads(projectResult) if 0 == j['code']: if j['data']['total'] > 0: queryList = j['data']['list'] for tempObj in queryList: if tempObj['prjname'].find(u'景观') > 0 or \ tempObj['prjname'].find(u'绿化') > 0: print('\t' + tempObj['prjname']) getDetailUrl = 'http://gcxm.hunanjs.gov.cn/AjaxHandler/PersonHandler.ashx?method=getProjectDetail&prjid=' \ + str(tempObj['prjid']) projectDetailResponse = requests.get(getDetailUrl) detailResult = projectDetailResponse.text jDetail = json.loads(detailResult) if 0 == jDetail['code']: for tempDetailObj in jDetail['data']['ds1']: if str(tempDetailObj['tendercorpid']) == str(result[0]) \ and float(tempDetailObj['tendermoney2']) >= 500.0: fitCompany = True projectInfo = tempObj['prjname'] + '\t' + str( tempDetailObj['tendermoney2']) break if fitCompany: break else: break else: print('error, i\'m quit') os._exit(0) pageIndex = pageIndex + 1 if fitCompany or j['data']['pageIndex'] >= j['data']['pages']: break if fitCompany: greaterThan500Obj.write(line + '\t' + projectInfo + '\n') except Exception as err: lxLog.getDebugLog()(str(err)) suitableCompanyObj.close() greaterThan500Obj.close()
def login(self): loginTokenAuthRequest = LoginTokenAuth_pb2.LoginTokenAuthRequest() loginTokenAuthRequest.devId = 'aaaaaaa' loginTokenAuthRequest.userId = self.userInfo['userId'] loginTokenAuthRequest.authToken = self.userInfo['authToken'] loginTokenAuthRequest.devType = 1 try: data = loginTokenAuthRequest.SerializeToString() sendData = self.appPack(data,99902,1002) self.buffer = sendData except Exception as err: lxLog.getDebugLog()(u"main异常退出:%s", str(err))
def saveTender(tenderInfo, mysqlCursor): try: querySql = "select * from tender where tenderid = {}".format(tenderInfo['tenderid']) mysqlCursor.execute(querySql) temp = None for tempResult in mysqlCursor: temp = tempResult[0] if not temp is None: return else: for key in tenderInfo.keys(): if tenderInfo[key] is None: tenderInfo[key] = 0 if 0 == tenderInfo['tenderresultdate']: tenderInfo['tenderresultdate'] = '2099-1-1 0:0:0' if 0 == tenderInfo['createdate']: tenderInfo['createdate'] = '2099-1-1 0:0:0' if 0 == tenderInfo['CheckTime']: tenderInfo['CheckTime'] = '2099-1-1 0:0:0' tenderInfo['tenderresultdate'] = str.replace(tenderInfo['tenderresultdate'], 'T', ' ') tenderInfo['createdate'] = str.replace(tenderInfo['createdate'], 'T', ' ') tenderInfo['CheckTime'] = str.replace(tenderInfo['CheckTime'], 'T', ' ') insertSql = "insert into tender set tenderid = {}, tenderclassname = '{}'" \ ", tendertypename = '{}', tendernum = '{}', prjid = '{}'" \ ", tendertypenum = '{}', tenderclassnum = '{}'" \ ", tenderresultdate = '{}', tendermoney = '{}'" \ ", tendermoney2 = '{}', prjsize = '{}'" \ ", area = '{}', agencycorpid = '{}'" \ ", agencycorpname = '{}', tendercorpid = '{}'" \ ", tendercorpname = '{}', tenderprojectname = '{}'" \ ", tenderprojectidcard = '{}', createdate = '{}'" \ ", statusnum = '{}', oldid = '{}'" \ ", isxzjg = '{}', CheckDepartName = '{}'" \ ", CheckPersonName = '{}', CheckTime = '{}'".format( tenderInfo['tenderid'], tenderInfo['tenderclassname'], tenderInfo['tendertypename'] \ , tenderInfo['tendernum'], tenderInfo['prjid'], tenderInfo['tendertypenum'] \ , tenderInfo['tenderclassnum'], tenderInfo['tenderresultdate'] \ , tenderInfo['tendermoney'], tenderInfo['tendermoney2'] \ , tenderInfo['prjsize'], tenderInfo['area'] \ , tenderInfo['agencycorpid'], tenderInfo['agencycorpname'] \ , tenderInfo['tendercorpid'], tenderInfo['tendercorpname'] \ , tenderInfo['tenderprojectname'], tenderInfo['tenderprojectidcard'] \ , tenderInfo['createdate'], tenderInfo['statusnum'] \ , tenderInfo['oldid'], tenderInfo['isxzjg'] \ , tenderInfo['CheckDepartName'], tenderInfo['CheckPersonName'] \ , tenderInfo['CheckTime']) mysqlCursor.execute(insertSql) mysqlCursor.execute('commit') except Exception as e: lxLog.getDebugLog()(str(e)) lxLog.getDebugLog()(u"数据库执行异常:%s", str(tenderInfo))
def run(self): index = 0 while index < 10: phone = '%07d%03d%01d' % (_PhonePrefix, self.threadID, index) if index % 1 == 0: lxLog.getDebugLog()(u"处理手机号码:%s", phone) try: color = (random.randint(0, 255), random.randint(0, 255), random.randint(0, 255), random.randint(0, 255)) new_image(300, 300, phone, color=color, show_image=False) except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err)) finally: index = index + 1
def run(self): if "Android" == self.deviceInfo[0]['platformName']: example = androidLX2(self.deviceInfo) else: example = iOSLX2(self.deviceInfo) while True: try: example.runTest() except Exception as e: exc_type, exc_obj, exc_tb = sys.exc_info() msg = unicode.format(u"错误文件:{}:{}\n错误原因:{}", \ exc_tb.tb_frame.f_code.co_filename, exc_tb.tb_lineno, str(e)) lxLog.getDebugLog()(msg) finally: time.sleep(10)
def appUnpack(self, data): marsHeadLen, clientVersion, marsCommand, marsSN, marsBodyLen, routeCode, interfaceCode, responceSN = -1, -1, -1, -1, -1, -1, -1, -1 # 自定义包头 # MARS包头 # 打包 length = len(data) if length >= 32: marsHeadLen, clientVersion, marsCommand, marsSN, marsBodyLen, routeCode, interfaceCode, responceSN = struct.unpack('!iiiiiiii', data[0:32]) recvBody = data[32:] else: lxLog.getDebugLog()(u"appUnpack 接收数据较短,无法解析") return None return interfaceCode, recvBody
def test_LostPassword(self, driver): self.myLog(u'test_LostPassword begin') try: self.myLog(u'test_LostPassword 点击 忘记密码') driver.find_element_by_id('login_Btn_LoginchangeBtn').click() time.sleep(3) phone = '13' + util.getRandomString(1, 9) driver.find_element_by_id( 'RegisteredView_textfild_phoneTextfild').send_keys(phone) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('RegisteredView_btn_nextBtn').click() time.sleep(3) driver.find_element_by_id( 'register_textfild_codeTextFild').send_keys( util.getRandomString(1, 4)) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id( 'register_textfild_nicknameTextfild').send_keys(phone) driver.hide_keyboard() time.sleep(3) #进行密码输入错误的验证 #1.输入纯数字密码 driver.find_element_by_id( 'register_textfild_passwordTextfild').send_keys(phone) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('register_btn_downBtn').click() self.saveScreenNormal(driver, u"输入纯数字密码") time.sleep(3) #2.输入随机密码 driver.find_element_by_id( 'register_textfild_passwordTextfild').clear() password = util.getRandomString(2, 16) driver.find_element_by_id( 'register_textfild_passwordTextfild').send_keys(password) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('register_btn_downBtn').click() time.sleep(3) if True: lxLog.getDebugLog()(u'注册成功,号码:' + phone + u',密码:' + password) except Exception as e: print e self.saveScreen(driver, e)
def test_Register(self, driver): self.myLog(u'test_Register begin') try: self.myLog(u'test_Register 点击注册按钮') driver.find_element_by_id( 'com.lx.chat:id/sign_tv_register_2').click() time.sleep(3) phone = '13' + util.getRandomString(1, 9) driver.find_element_by_id( 'com.lx.chat:id/sign_et_register_num').send_keys(phone) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('com.lx.chat:id/sign_btn_login').click() time.sleep(3) driver.find_element_by_id( 'com.lx.chat:id/sign_verify_code').send_keys( util.getRandomString(1, 4)) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('com.lx.chat:id/sign_et_nick').send_keys( phone) driver.hide_keyboard() time.sleep(3) #进行密码输入错误的验证 #1.输入纯数字密码 driver.find_element_by_id('com.lx.chat:id/sign_et_num').send_keys( phone) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('com.lx.chat:id/sign_btn_login').click() self.saveScreenNormal(driver, u"输入纯数字密码") time.sleep(3) #2.输入随机密码 driver.find_element_by_id('com.lx.chat:id/sign_et_num').clear() password = util.getRandomString(2, 16) driver.find_element_by_id('com.lx.chat:id/sign_et_num').send_keys( password) driver.hide_keyboard() time.sleep(3) driver.find_element_by_id('com.lx.chat:id/sign_btn_login').click() time.sleep(3) if True: lxLog.getDebugLog()(u'注册成功,号码:' + phone + u',密码:' + password) except Exception as e: print e self.saveScreen(driver, e)
def run(self): index = 0 registerDict = {} while index < 1000: phone = '%d%03d%03d' % (_PhonePrefix, self.threadID, index) registerDict['telephone'] = phone registerDict['verifyCode'] = '0000' registerDict['nickname'] = phone registerDict['password'] = '******' registerDict['resisterCome'] = '1' registerStr = json.dumps(registerDict) try: r = requests.post( 'https://sso.im.test.bolod.xin:19000/sso/v1/register', data=registerStr, verify=False) # lxLog.getDebugLog()(r.text) loginRecvDict = json.loads(r.text) if '1' != loginRecvDict['result']: lxLog.getDebugLog()(unicode.format(u"注册失败,号码:{1},错误代码{0}", loginRecvDict['result'], phone)) else: lxLog.getDebugLog()(u'注册成功:%s', phone) except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err)) finally: index = index + 1
def saveProject(projectInfo, mysqlCursor): try: querySql = "select * from project where prjid = {}".format(projectInfo['prjid']) mysqlCursor.execute(querySql) temp = None for tempResult in mysqlCursor: temp = tempResult[0] if not temp is None: return else: for key in projectInfo.keys(): if projectInfo[key] is None: projectInfo[key] = 0 insertSql = "insert into project set prjid = {}, prjnum = '{}'" \ ", prjname = '{}', buildcorpname = '{}', prjtypenum = '{}'" \ ", county = '{}', prjtypename = '{}'".format( projectInfo['prjid'], projectInfo['prjnum'], projectInfo['prjname'] \ , projectInfo['buildcorpname'], projectInfo['prjtypenum'], projectInfo['county'] \ , projectInfo['prjtypename']) mysqlCursor.execute(insertSql) mysqlCursor.execute('commit') except Exception as e: lxLog.getDebugLog()(str(e)) lxLog.getDebugLog()(u"数据库执行异常:%s", str(projectInfo))
def login(): # 登陆 loginDict = {} loginDict['telephone'] = loginName loginDict['devType'] = 1 loginDict['password'] = hashlib.md5(md5Salt + loginPassword).hexdigest() loginDict['devBrand'] = 'vivo' loginStr = json.dumps(loginDict) lxLog.getDebugLog()(unicode.format(u'登陆发送数据:{0}', loginStr)) r = requests.post(loginAddr, data=loginStr, verify=False) lxLog.getDebugLog()(u'登陆接收数据:%s', r.text) loginRecvDict = json.loads(r.text) if '1' != loginRecvDict['result']: lxLog.getDebugLog()(unicode.format(u"登陆失败,错误代码{0}", loginRecvDict['result'])) return # 寻址 ''' getGateDict = {} getGateDict['useId'] = loginRecvDict['userId'] getGateDict['devType'] = '1' getGateDict['authToken'] = loginRecvDict['authToken'] getGateDict['version'] = '0.1' getGateStr = json.dumps(getGateDict) lxLog.getDebugLog()(unicode.format(u'寻址发送数据:{0}', getGateStr)) r = requests.post(loginAddr, data=loginStr, verify=False) lxLog.getDebugLog()(r.text) ''' userInfo = {} userInfo['userId'] = loginRecvDict['userId'] userInfo['authToken'] = loginRecvDict['authToken'] client = APPClient('192.168.3.149', 9091, userInfo) asyncore.loop() lxLog.getDebugLog()(u'异常退出了')
def reportToZK(): zk = KazooClient(zkHost + ":" + zkPort) zk.start() node = nodePath + avHost while True: try: lxLog.getDebugLog()(u"往%s:%d取数据", avHost, avPort) audioSize, videoSize = getConnections(avHost, avPort) currentTime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) value = avHost + ':' + str(avPort) + '|' + str( audioSize) + '|' + str(videoSize) + '|' + str( maxBandwidth) + '|' + currentTime lxLog.getDebugLog()(u"往%s:%s上报数据:%s", zkHost, zkPort, value) if zk.exists(node): zk.set(node, value.encode('ascii')) else: zk.create(node, value.encode('ascii'), None, True, False) except Exception as err: lxLog.getDebugLog()(u"reportToZK异常退出:%s", str(err)) zk.close() break finally: time.sleep(60)
def myLog(self, msg): lxLog.getDebugLog()("%s:%s", self.deviceInfo[0]['normalName'], msg)
retObj['ruleName'] = '测试' result.append(retObj) result.append('http://192.168.3.80:30000/lotterySetting/enableRuleName') return result def relateRule(): result = [] retObj = {} retObj['ruleId'] = 2 retObj['cmpId'] = 55 result.append(retObj) result.append('http://192.168.3.80:30000/lotterySetting/relateRule') return result if __name__ == '__main__': try: # login() result = editRule() postStr = json.dumps(result[0]) # print(json.dumps(result[0], sort_keys=True, indent=4)) r = requests.post(result[1], headers=headers, data=postStr, verify=False) lxLog.getDebugLog()(json.dumps(json.loads(r.text), sort_keys=True, indent=4, ensure_ascii=False)) # lxLog.getDebugLog()(r.text) except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err))
if __name__ == '__main__': ''' #注册 index = 0 registerDict = {} while index < 1: phone = '1239999%04d' % index registerDict['telephone'] = phone registerDict['verifyCode'] = '0000' registerDict['nickname'] = phone registerDict['password'] = '******' registerDict['resisterCome'] = '1' registerStr = json.dumps(registerDict) r = requests.post('https://192.168.3.149:12000/sso/v1/register', data=registerStr, verify=False) #lxLog.getDebugLog()(r.text) loginRecvDict = json.loads(r.text) if '1' != loginRecvDict['result']: lxLog.getDebugLog()(unicode.format(u"注册失败,号码:{1},错误代码{0}", loginRecvDict['result'], phone)) else: lxLog.getDebugLog()(u'注册成功:%s', phone) index = index + 1 ''' while True: try: login() except Exception as err: lxLog.getDebugLog()(u"main异常退出:%s", str(err)) finally: time.sleep(10000)
dstRequiredStr = "" for lines in f.readlines(): line = lines.split("\t") dstStr = "private " oldType = line[2].split('(')[0].strip() newType = typeDic[oldType] oldField = line[1].strip() newField = "" index = 0 while index < len(oldField): if '_' != oldField[index]: newField = newField + oldField[index] index = index + 1 else: newField = newField + oldField[index + 1].upper() index = index + 2 comment = line[0].strip() dstSqlStr = dstSqlStr + oldField + "=#{" + newField + "}," dstRequiredStr = dstRequiredStr + '"' + newField + '",' print(dstStr + newType + ' ' + newField + ';//' + comment) print(dstSqlStr) print(dstRequiredStr) if __name__ == '__main__': try: renameType() except Exception as err: lxLog.getDebugLog()(u"异常:%s", str(err))
def run(self): mysqlConfig = { 'host': '127.0.0.1', 'user': '******', 'password': '******', 'port': 3306, 'database': 'tmj', 'charset': 'utf8' } mysqlConn = pymysql.connect(**mysqlConfig) mysqlCursor = mysqlConn.cursor() startDate = time.mktime(time.strptime('2017-2-1', '%Y-%m-%d')) while True: try: if q.empty(): break R.acquire() result = q.get() R.release() print(result) #threadFileObj = open('thread' + str(self.threadID) + '.txt', 'a+', encoding='utf-8') try: corpid = str(result[0]) pageIndex = 1 fitCompany = False projectInfo = '' while True: getProjectListUrl = 'http://gcxm.hunanjs.gov.cn/AjaxHandler/PersonHandler.ashx?method=getProjectList&corpid=' \ + corpid + '&corptype=0&pageSize=10&pageIndex=' + str(pageIndex) projectResponse = requests.get(getProjectListUrl) projectResult = projectResponse.text j = json.loads(projectResult) if 0 == j['code']: if j['data']['total'] > 0: queryList = j['data']['list'] for tempObj in queryList: saveProject(tempObj, mysqlCursor) if True: print('\t' + tempObj['prjname']) getDetailUrl = 'http://gcxm.hunanjs.gov.cn/AjaxHandler/PersonHandler.ashx?method=getProjectDetail&prjid=' \ + str(tempObj['prjid']) projectDetailResponse = requests.get(getDetailUrl) detailResult = projectDetailResponse.text jDetail = json.loads(detailResult) if 0 == jDetail['code']: for tempDetailObj in jDetail['data']['ds1']: saveTender(tempDetailObj, mysqlCursor) continue tenderStartDateStr = tempDetailObj['tenderresultdate'].split('T')[0] tenderStartDate = time.mktime( time.strptime(tenderStartDateStr, '%Y-%m-%d')) if str(tempDetailObj['tendercorpid']) == str(result[0]) \ and float(tempDetailObj['tendermoney2']) >= 500.0 \ and tenderStartDate >= startDate: fitCompany = True projectInfo = tempObj['prjname'] + '\t' + str( tempDetailObj['tendermoney2']) break if fitCompany: break else: break else: print(str(result) + 'error, i\'m quit|' + projectResult) os._exit(0) pageIndex = pageIndex + 1 if fitCompany or j['data']['pageIndex'] >= j['data']['pages']: break #if fitCompany: #threadFileObj.write(result[1] + '\t' + projectInfo + '\n') except Exception as err: lxLog.getDebugLog()(str(err)) #threadFileObj.close() except Exception as e: lxLog.getDebugLog()(str(e)) finally: pass