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 ni