def sendSinglePersonLocationMsg(): for i in range(1000): tag_info = PG_Client.query( 'select * from tag_info ORDER BY RANDOM() LIMIT 1 ', None) print(' rows : ', tag_info) message = newSinglePersonMessageData(tag_info) conn.sendTopic(str(message), 'testtopic')
def sendOnlineMsg(): for i in range(1): tag_info = PG_Client.query( 'select * from tag_info ORDER BY RANDOM() LIMIT 1 ', None) print(' rows : ', tag_info) message = newOnlineMessageData(tag_info) conn.sendTopic(str(message), 'testtopic')
def sendLocationMsg(): for i in range(1): # tag_info = PG_Client.query('select i_id from tag_info ORDER BY RANDOM() LIMIT 1 ', None); tag_info = PG_Client.query( 'select i_id from tag_info ORDER BY RANDOM() LIMIT 1 ', None) print(' rows : ', tag_info) message = newMessageData(tag_info) print(' message : ', message) conn.sendTopic(str(message), 'testtopic')
def readNewMessageFile(): tag_info = PG_Client.query('select i_id from tag_info ORDER BY RANDOM() LIMIT 1 ', None); print(' rows : ', tag_info); msg = newMessageData(tag_info); print(' msg : ' , msg) with open('E:\projects\五系统一中心\mq_test\Win32\Win32\\001', 'w+') as f: f.write(str(msg)); print(f.read())
def getTagListByPages(pageNo): total = 10081 pageSize = 500 offset = (pageNo - 1) * pageSize tagInfoSql = 'select * ' \ 'from tag_info ' \ 'order by i_id asc ' \ ' limit ' + str(pageSize) + ' offset ' + str(offset) + '' tagInfoList = PG_Client.query(tagInfoSql, None) return tagInfoList
def createNewMessage(count): allMsg = ''; for i in range(count) : # 数据库查询 tag_info = PG_Client.query('select i_id from tag_info ORDER BY RANDOM() LIMIT 1 ', None); print(' rows : ', tag_info); # 获取当前时间戳 dtime = datetime.datetime.now() ans_time = int(time.mktime(dtime.timetuple())) * 1000; id = tag_info['i_id']; # id = 1111; # 图层 emapArr = ['egms_369857' , 'egms_130738']; layer_name = RandomUtils.getRamdonByArr(emapArr); key = "coordinate" # 随机坐标 x = RandomUtils.getRandomBetweenNumbers(0, 61); y = RandomUtils.getRandomBetweenNumbers(-46, 0); val = str(x) + "," + str(y); msg = '{"cls":"tag","id":%(id)d,"layer_name":"%(layer_name)s","time":%(time)d,"key":"%(key)s","val":"%(val)s"}\n'; msg = msg % { 'id' : id , 'layer_name' : layer_name , 'time' : ans_time , 'key' : key , 'val' : val } allMsg += msg; print(' msg : ' , allMsg) with open('E:\projects\五系统一中心\mq_test\Win32\Win32\\001', 'w+') as f: f.write(allMsg)
def updatePersonId(): ''' 计算总数 select count(1) from door_person_info dpi left join tag_info ti on dpi.i_person_id = ti.c_person_id and ti.i_id = dpi.i_tag_id where ti.i_id is null ''' total = 1150 pageSize = 500 page = total / pageSize + 1 page = int(page) ''' select dpi.* from door_person_info dpi left join tag_info ti on dpi.i_person_id = ti.c_person_id and ti.i_id = dpi.i_tag_id where ti.i_id is null select ti.i_id , ti.c_person_id from tag_info ti left join door_person_info dpi on dpi.i_person_id = ti.c_person_id and ti.i_id = dpi.i_tag_id where dpi.i_person_id is null order by dpi.i_person_id desc ''' for pageNo in range(0, page): offset = pageNo * pageSize sql = 'select dpi.i_person_id , dpi.i_tag_id ' \ 'from door_person_info dpi ' \ 'left join tag_info ti ' \ 'on dpi.i_person_id = ti.c_person_id' \ ' and ti.i_id = dpi.i_tag_id ' \ 'where ti.i_id is null' \ ' order by dpi.i_person_id desc ' \ ' limit ' + str(pageSize) + ' offset ' + str(offset) + '' tag_info_sql = ' select ti.i_id , ti.c_person_id ' \ 'from tag_info ti ' \ 'left join door_person_info dpi ' \ 'on dpi.i_person_id = ti.c_person_id ' \ 'and ti.i_id = dpi.i_tag_id ' \ 'where dpi.i_person_id is null ' \ 'order by dpi.i_person_id desc ' \ ' limit ' + str(pageSize) + ' offset ' + str(offset) + '' personList = PG_Client.query(sql, None) tagInfoList = PG_Client.query(tag_info_sql, None) i = 0 if personList and len(personList): conn = PG_Client.getConn() cur = conn.cursor() for personItem in personList: tagInfoItem = tagInfoList[i] tagid = tagInfoItem['i_id'] i_person_id = personItem['i_person_id'] ''' update tag_info set c_person_id = %s where i_id = %s ''' updateSql = ' update tag_info set c_person_id = %s ' \ 'where i_id = %s' updatePersonSql = ' update door_person_info set i_tag_id = %s ' \ 'where i_person_id = %s' params = [] params.append(i_person_id) params.append(tagid) personParams = [] personParams.append(tagid) personParams.append(i_person_id) cur.execute(updateSql, tuple(params)) cur.execute(updatePersonSql, tuple(personParams)) i = i + 1 conn.commit() cur.close() conn.close()
pageNo = 1 pageSize = 20 # 10081 # 分页查询标签 while (pageNo < 600): offSet = (pageNo - 1) * pageSize if pageNo % 60 == 0: f.write('\n') f.write('\n') f.write('\n') f.write('\n') sql = 'select i_id from tag_info ORDER BY i_id asc limit %(pageSize)s offset %(offset)d ' sql = sql % {'pageSize': pageSize, 'offset': offSet} tag_info_list = PG_Client.query(sql, None) message = '' if tag_info_list and len(tag_info_list) > 0: for tagItem in tag_info_list: i_id = tagItem['i_id'] message = message + str(i_id) message = message + ',' print('tag_info_list : ', tag_info_list) pageNo = pageNo + 1 f.write(message) f.write('\n') print(f.read())