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
