import os import django import sys BASE_DIR = os.path.dirname(os.path.abspath(__file__)) # 定位到你的django根目录 sys.path.append(os.path.abspath(os.path.join(BASE_DIR, os.pardir))) os.environ.setdefault("DJANGO_SETTINGS_MODULE", "yfwlw_pro.settings") # project_name 项目名称 django.setup() import json import time import requests import datetime from apps.ReportManage.all_dict import trap_list from apps.AppInfoManage.models import Equip, Equip_type, Trapstatus, Trapdata, Trapphoto print("--------trap_transpond start!-----------") url = 'http://telemo.org/pest/data/grid/picturedataview.do' # dat= {'username': 'jkTest','password': '123456','sign':'cf6345abb2ed948a534467d278a79190'} #将携带的参数传给params # r = requests.get(url, params=dat) # rec = r.text # data = json.loads(rec) # print(data['resultData'][-1]) while True: time.sleep(3600) nowtime = datetime.datetime.now().strftime('%Y%m%d') origin = sys.stdout f = open('../logs/'+nowtime+'trapphoto.txt','a+') sys.stdout = f for i in trap_list: print("=========================================") r = requests.get(url, params=i) rec = r.text data = json.loads(rec) # print("data:",data) try: trapstatus = data['resultData'][0] except: print("-------------continue-------------") continue # print("设备位置为:",trapstatus) imei = trapstatus['dataviewId'] detester = datetime.datetime.strptime(trapstatus['pictureTime'],"%Y-%m-%d %H:%M:%S") trap_exist = Equip.objects.filter(equip_id=imei) addr = "http://telemo.org/" + trapstatus['picturePath'] print("time",detester) print("imei",imei) print("addr",addr) # 设备存在: if trap_exist.exists(): imei = Equip.objects.get(equip_id=imei) if Trapphoto.objects.filter(addr=addr).exists(): print("------------image exists----------------") else: Trapphoto.objects.create(equip_id=imei,addr=addr,upl_time=detester) print("----------------image upload success-------------------") else: print("---------equip not exists------------") sys.stdout = origin f.close()