Python WebSocket消息发送与接收

最新推荐文章于 2024-08-12 00:59:33 发布

Lboy、

最新推荐文章于 2024-08-12 00:59:33 发布

阅读量5.7k

点赞数 1

文章标签： python websocket

本文链接：https://blog.csdn.net/weixin_43419111/article/details/109305865

版权

一、读取Excel

import xlrd

#读取excel文件
def excel():
    wb = xlrd.open_workbook('C:\\Users\\Administrator\\PycharmProjects\\HB\\testFile\\case\\1024.xlsx')# 打开Excel文件
    sheet = wb.sheet_by_name('content')#通过excel表格名称(rank)获取工作表
    dat = []  #创建空list
    for a in range(sheet.nrows):  #循环读取表格内容（每次读取一行数据）
                cells = sheet.row_values(a)  # 每行数据赋值给cells
                data=str(cells[0])#因为表内可能存在多列数据，0代表第一列数据，1代表第二列，以此类推
                dat.append(data) #把每次循环读取的数据插入到list
    return dat
a = excel() #返回整个函数的值
print(a)

def test(a):   #a变量传入
    for b in a:  #循环读取a变量list
        print(b)
        return b
test(a)

二、requests请求循环发送消息

import requests
import json
import time
from readExcel2 import *


url='https://xxxxxxxxxxxx/chat/user/speak'
headers={"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjIyMzQ0MjYzMDAsImlzcyI6ImF1dGhfdG9rZW4iLCJkYXRhIjoie1widXNlcklkXCI6NzcwLFwibmlja25hbWVcIjpudWxsfSJ9.QGBQdPgBSjme5xSRNfuo0TluWtmRMrLCWrIzeKYx5rM","platform":'2','Content-Type': 'application/json;charset=UTF-8'}
payload = {"version":"2.0.3","live_id":982744,"type":1,"platform":2,"content":"嘿嘿","channelid":"0","pkg":"ddd","event_id":260,"send_type":0}


for i in excel():
	# print(i)
	payload["content"] = i
	response = requests.post(headers=headers,url=url, data=json.dumps(payload))
	time.sleep(1)
# 休眠1秒
	print(response.text)
# 	print(json.dumps(response.text))
	# s=json.dumps(response.text).encode("utf-8")
	# f = open("text.txt",'wb')
	# f.write(s+b"\r\n")
	# f.close()

三、Websocket拉取消息

import websocket


def on_message(ws, message):  # 服务器有数据更新时，主动推送过来的数据
    print(message)


def on_error(ws, error):  # 程序报错时，就会触发on_error事件
    print(error)


def on_close(ws):
    print("Connection closed")


def on_open(ws):  # 连接到服务器之后就会触发on_open事件，这里用于send数据
    req = '{"event":"subscribe", "channel":"btc_usdt.deep"}'
    print(req)
    ws.send(req)


if __name__ == "__main__":
    websocket.enableTrace(True)
    ws = websocket.WebSocketApp("wss://axxxxxxx/websocketServer?module=chat&product=hs&roomid=982744&userid=820&accessToken=e76576a79e4d9155923ffa726e161ede",
                                on_message=on_message,
                                on_error=on_error,
                                on_close=on_close)
    ws.on_open = on_open
    ws.run_forever(ping_timeout=30)