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