#!/usr/bin/env python3
import sys
import pexpect
import os

'''本脚本用于实现scp指令将上位机文件传输给板卡 并自动填充目标ip地址和用户名密码'''

class LogWrapper:
    def __init__(self, file):
        self.file = file

    def write(self, data):
        self.file.write(data.decode('utf-8'))
        self.file.flush()

    def flush(self):
        self.file.flush()  


if __name__ == '__main__':
    filepath = sys.argv[1]
    if len(sys.argv) > 2:
        dst_path = ' root@192.168.137.89:/home/root/' + sys.argv[2]
    else:
        dst_path = ' root@192.168.137.89:/home/root/'
    command = "scp " + filepath + ' ' + dst_path
    password = "root"
    print(command)

    # Remove old host key if it exists
    known_hosts_file = "~/.ssh/known_hosts"
    ip_address = "192.168.137.89"
    remove_command = f"ssh-keygen -f \"{known_hosts_file}\" -R \"{ip_address}\""
    os.system(remove_command)

    # Execute SCP command
    child = pexpect.spawn(command, logfile=LogWrapper(sys.stdout))
    index = child.expect(["Are you sure you want to continue connecting (yes/no)?", "password:", pexpect.EOF])

    if index == 0:
        child.sendline("yes")
        child.expect("password:")
    
    if index in [0, 1]:
        child.sendline(password)
        child.expect(pexpect.EOF)
    
    print(child.before.decode())

#!/usr/bin/env python3
from xlrd  import open_workbook
from lottery_draw import Ui_MainForm
import sys
import random
import time
import os.path
from PyQt5.QtCore import QThread, QTimer
from PyQt5 import QtCore, QtGui, QtWidgets

NAME_SET = set()

def get_all_names():
    p_path = os.path.split(os.path.realpath(__file__))[0]
    table = open_workbook(p_path + '/抽奖名单.xlsx').sheet_by_index(1)
    for cell in table.col_values(0):
        if not cell:
            break
        NAME_SET.add(cell.strip())        

class Py_Select(Ui_MainForm, QtWidgets.QWidget):
    def __init__(self):
        super(Py_Select, self).__init__()
        self.setupUi(self)
        self.init()
        self.setWindowTitle("抽奖工具")

    def init(self):
        get_all_names()
        self.name_list = list(NAME_SET)
        self.boxNames.setText('')
        self.btnStart.clicked.connect(self._start) 
        self.btnStop.clicked.connect(self._stop)
        self.index = 0
        self.timer = None

    def _start(self):
        self.btnStart.setHidden(True)
        self.btnStop.setHidden(False)
        self.name_list = list(NAME_SET)
        random.seed(int(time.time()))
        random.shuffle(self.name_list)

        if not self.timer:
            self.timer = QTimer()
        self.timer.timeout.connect(self._range_name)
        self.timer.start(50)

    def _range_name(self):
        self.index += 1
        if self.index >= len(self.name_list):
            self.index = 0
        self.boxNames.setText(self.name_list[self.index])

    def _stop(self):       
        if self.timer:
            self.timer.stop()
            NAME_SET.discard(self.boxNames.text().strip())
        self.btnStart.setHidden(False)
        
if __name__ == '__main__':
    app = QtWidgets.QApplication(sys.argv)
    myshow = Py_Select()
    myshow.show()
    sys.exit(app.exec_())

import requests
import re
import json

headers = {
    'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8',
    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36'}

def getTencentVideoUrl(url):
    vid = url.split('/')[-1][:-5]
    url = 'http://h5vv.video.qq.com/getinfo?otype=json&platform=11&defnpayver=1&appver=3.4.40&defn=fhd&vid=' + vid
    html = requests.get(url, headers=headers).text
    # 获取json数据
    p = re.compile(r'({.*})', re.S)
    jsonstr = re.findall(p, html)[0]
    json_data = json.loads(jsonstr)
    print(jsonstr)

    # 解析json数据获取url
    fvkey = json_data['vl']['vi'][0]['fvkey']
    keyid = json_data['vl']['vi'][0]['cl']['ci'][0]['keyid'].split('.')
    filename = keyid[0] + '.p' + keyid[1][2:] + '.' + keyid[2] + '.mp4'
    baseUrl = json_data['vl']['vi'][0]['ul']['ui'][3]['url']  # 实际数据中有多个cdn可供选择
    result = baseUrl + filename + '?vkey=' + fvkey
    return result

if __name__ == '__main__':
    url = input('请输入腾讯视频网址:')
    print('视频下载地址：\n', getTencentVideoUrl(url))

pip install pyexecjs

import requests
import execjs
import json


def createParams(city, month, ctx):
    '''由城市名、年月得出经js加密后的post参数,ctx由js代码解析得到'''
    method = 'GETDAYDATA'
    js = 'getEncryptedData("{0}", "{1}", "{2}")'.format(method, city, month)
    params = ctx.eval(js)
    return {'hd': params}


def getResponseData(city, month, ctx):
    '''由城市名、年月向服务器发送post请求并解密返回数据,ctx由js代码解析得到'''
    apiUrl = 'https://www.aqistudy.cn/historydata/api/historyapi.php'
    headers = {
        'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
        'Accept-Encoding': 'gzip, deflate',
        'Accept-Language': 'zh-CN,zh;q=0.8',
        'Content-Type': 'application/x-www-form-urlencoded',
        'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.80 Safari/537.36'
    }

    response = requests.post(apiUrl, data=createParams(
        city, month, ctx), headers=headers, timeout=10)
    if response.status_code != 200:
        return None
    # 解析数据
    js = 'decodeData("{0}")'.format(response.text)
    decrypted_data = ctx.eval(js)
    data = json.loads(decrypted_data)
    return data['result']['data']['items']


if __name__ == '__main__':
    # js环境，这里用nodeJS
    node = execjs.get()
    # compile javascript
    ctx = node.compile(open('encryption.js', encoding='utf-8').read())

    city = input('请输入城市名(如: 西安)：')
    year = input('请输入年份(如: 2018)：')
    month = input('请输入月份(如: 5)：').zfill(2)
    items = getResponseData(city, year + month, ctx)

    if items is not None:
        print('\n')
        print('日期\tAQI\tPM2.5\tPM10\tSO2\tNO2\tCO\tO3\t质量等级')
        for item in items:
            print(item['time_point'], end='\t')
            print(item['aqi'], end='\t')
            print(item['pm2_5'], end='\t')
            print(item['pm10'], end='\t')
            print(item['so2'], end='\t')
            print(item['no2'], end='\t')
            print(item['co'], end='\t')
            print(item['o3'], end='\t')
            print(item['quality'])
    else:
        print('数据获取失败!')

import re
import requests

def dd2dms(deg):
    d = int(float(deg))
    md = abs(float(deg) - d) * 60
    m = int(md)
    sd = (md - m) * 60
    return '{:d}° {:d}′ {:.7f}″'.format(d, m, sd)

headers = {
    "User-Agent": "User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36",
    "Referer": "https://www.amap.com"
}

def Locate(url_string):
    amapUrl = r'^http://surl.amap.com/\w{13}$'
    if re.match(amapUrl, url_string) is None:
        return 'NOT FOUND'

    try:
        url_string = 'https://' + url_string[7:]
        r = requests.head(url_string, stream=True, headers=headers)
        realUrl = r.headers['Location']

        posPattern = r'(\d{1,3}\.\d{6,20}),(\d{1,3}\.\d{6,20})'
        jingdu = re.search(posPattern, realUrl).group(2)
        # print(jingdu)

        weidu = re.search(posPattern, realUrl).group(1)
        # print(weidu)
        result = '({0},{1})\r\n({2},{3})'.format(weidu, jingdu, dd2dms(weidu), dd2dms(jingdu))

        return result

    except BaseException as e:
        print(e)
        return 'NOT FOUND'

if __name__ == '__main__':
    url_string = 'http://surl.amap.com/3U9wY_0957DEP'
    print(Locate(url_string))

def GET(self):
    try:
        data = web.input()
        if len(data) == 0:
            return "hello, this is handle view"
        signature = data.signature
        timestamp = data.timestamp
        nonce = data.nonce
        echostr = data.echostr
        token = "xxxxxxxxxxx"
        list1 = [token,timestamp,nonce]
        list1.sort()
        str_list1 = ''.join(list1)
        print(str_list1)
        sha1 = hashlib.sha1()
        sha1.update(str_list1.encode('utf-8'))
        hashcode = sha1.hexdigest()
        print("handle/GET func: hashcode, signature: ", hashcode, signature)
        if hashcode == signature:
            return echostr
        else:
            return ""
    except Exception as Argument:
        return Argument

def POST(self):
     str_xml = web.data()
     xml = etree.fromstring(str_xml)
     msgType = xml.find("MsgType").text
     fromUser = xml.find("FromUserName").text
     toUser = xml.find("ToUserName").text
     #如果符合高德链接格式则返回经纬度，否则返回test+原字符串
     if msgType == 'text':
         getMsg=xml.find("Content").text.strip()
         amapUrl = r'^http://surl.amap.com/\w{13}$'
         if re.match(amapUrl, getMsg) is None:
             content = "test"+ getMsg
         else:
             content=getLocate.Locate(getText)
         render = web.template.render('templates/')
         return render.reply_text(fromUser, toUser, int(time.time()), content)
     elif msgType == 'image':
         pass
     else:
         pass

def main():
    return 'Hello World!'

def main():
    return 'Hello World!'

if __name__ == '__main__':
    print(main())

def getMd5(path):
    dest=bytes.fromhex('00000030')
    with open(path,'rb') as fs:
        content = fs.read()
        md5Pos = 0
        while content:
            md5Pos = content.find(dest, md5Pos)
            if md5Pos==-1:
                break
            print(content[md5Pos+4:md5Pos+20].hex())            
            md5Pos += 20


if __name__=='__main__':
    getMd5(r'C:\Users\upython\Desktop\xxx.vi')