django views.py接收json数据

最新推荐文章于 2022-07-02 16:47:33 发布

原创最新推荐文章于 2022-07-02 16:47:33 发布 · 1k 阅读

CC 4.0 BY-SA版权

这篇博客讲述了如何在Django中使用views.py接收并处理JSON数据，通过json库进行解析。接着，展示了如何与数据库交互，包括查询HaDevices表，根据条件插入或更新数据，并设置自定义昵称。最后，返回HTTP响应，包含设备ID和MQTT主题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

from django.shortcuts import HttpResponse
from json_data.models import HaDevices
from django.db import connection
import json
from json_data import mqtt_client
import paho.mqtt.client as mqtt
import time

default_dtfield = ‘2016-01-01 00:08:00’

def get_data(request):
jso = request.GET.get(‘json’)
ss = json.loads(jso)
# sa = json.load(jso)
ids = ss.get(‘macAddr’)
types = ss.get(‘type’)
print(ss)
print(ids)
print(types)
type_str = {“undefined”, “switch”, “socket”, “light”}
for x in type_str:
if types == x:
return types
cursor = connection.cursor()
cursor.execute(“SELECT id FROM ha_devices WHERE hw_id = ‘%s’” % ids)
rows = cursor.fetchall()
print(rows)
cursor.execute(“INSERT INTO ha_devices SET hw_id = ‘%s’, type=’%s’” % (ids, types))
cursor.execute(“UPDATE ha_devices SET nickname=CONCAT(‘DEV_’, LPAD(id,5,‘0’)) WHERE hw_id=’%s’” % ids)
cursor.execute(“SELECT id FROM ha_devices WHERE hw_id = ‘%s’” % ids)
get_id = cursor.fetchall() # 获取返回的数据
topic = “/DEVICE/”
print(rows)
print(get_id)
print(topic)
return HttpResponse(json.dumps({
“id”: get_id, “topic”: topic}))
# return HttpResponse(“json = %s” % ss)

def get_json(request):
global haDevices_all
global haDevices_obj
jso = request.GET.get(‘json’)
ss = json.loads(jso)
ids = ss.get(‘macAddr’)
types = ss.get(‘type’)
print(ss)
print(ids)
print(types)
try:
haDevices_all = HaDevices.objects.get(hw_id=’%s’ % ids)
except HaDevices.DoesNotExist:
print(“没有该数据”)
haDevices_obj = HaDevices.objects.create(hw_id=’%s’ % ids, type=1, nickname=‘undefined’, online=0, switch=0,
light_r=0, light_g=0, light_b=0)
haDevices_obj.save()
if len(str(haDevices_obj.id)) < 5:
n = str(haDevices_obj.id).zfill(5)
print(n)
haDevices_obj.nickname = “DEV_” + str(n)
else:
m = haDevices_obj.id
print(m)
haDevices_obj.nickname = “DEV_” + str(m)
# print(haDevices_all)
get_id = haDevices_obj.id
topic = “/DEVICE/”
else:
if len(str(haDevices_all.id)) < 5:
n = str(haDevices_all.id).zfill(5)
print(n)
haDevices_all.nickname = “DEV_” + str(n)
haDevices_all.save()
else:
m = haDevices_all.id
print(m)
haDevices_all.nickname = “DEV_” + str(m)
haDevices_all.save()
get_id = haDevices_all.id
topic = “/DEVICE/”

return HttpResponse(json.dumps({"id": get_id, "topic": topic}))