def postData(arg, sensorType):
config = confLoader()
url = config.get_url()
temp = {}
temp['datetime'] = arg["time"]
temp['device_id'] = arg['device_id']
temp['voltage'] = arg['voltage']
temp['ele_quantity'] = arg['ele_quantity']
temp['device_temp'] = arg['device_temp']
if sensorType == TEMPERATURE:
temp['value'] = arg['temperature']
temp['sensor_id'] = TEMPERATURE
if sensorType == HUMIDITY:
temp['value'] = arg['humidity']
temp['sensor_id'] = HUMIDITY
if sensorType == PM2_5:
temp['value'] = arg['pm2_5']
temp['sensor_id'] = PM2_5
if sensorType == NOISE:
temp['value'] = arg['noise']
temp['sensor_id'] = NOISE
try:
req = urllib2.Request(url, json.dumps(temp))
req.add_header('Content-Type', 'application/json')
response = urllib2.urlopen(req)
return True
except:
return False
def postData(arg, sensorType):
config = confLoader()
url = config.get_url()
temp = {}
temp['datetime'] = arg["time"]
temp['device_id'] = arg['device_id']
temp['voltage'] = arg['voltage']
temp['ele_quantity'] = arg['ele_quantity']
temp['device_temp'] = arg['device_temp']
if sensorType == TEMPERATURE:
temp['value'] = arg['temperature']
temp['sensor_id'] = TEMPERATURE
if sensorType == HUMIDITY:
temp['value'] = arg['humidity']
temp['sensor_id'] = HUMIDITY
if sensorType == PM2_5:
temp['value'] = arg['pm2_5']
temp['sensor_id'] = PM2_5
if sensorType == NOISE:
temp['value'] = arg['noise']
temp['sensor_id'] = NOISE
try:
req = urllib2.Request(url, json.dumps(temp))
req.add_header('Content-Type', 'application/json')
response = urllib2.urlopen(req)
return True
except:
return False
def Post(args):
config = confLoader()
try:
conn = MySQLdb.connect(host=config.get_host(),
port=config.get_port(),
user=config.get_user(),
passwd=config.get_passwd(),
db=config.get_db(),
charset='utf8')
cur = conn.cursor()
sql = 'insert into sensor_data(device_id, sensor_id, value,\
datetime, ele_quantity, voltage, \
device_temp) values (%s, %s,%s, %s, %s, %s, %s)'
values = []
for arg in args:
datetime = arg["time"]
temperature = arg["temperature"]
humidity = arg['humidity']
noise = arg['noise']
pm2_5 = arg['pm2_5']
device_id = arg['device_id']
voltage = arg['voltage']
ele_quantity = arg['ele_quantity']
device_temp = arg['device_temp']
values.append(
(device_id, TEMPERATURE, temperature,
datetime, ele_quantity, voltage, device_temp))
values.append(
(device_id, HUMIDITY, humidity, datetime,
ele_quantity, voltage, device_temp))
values.append(
(device_id, NOISE, noise, datetime,
ele_quantity, voltage, device_temp))
values.append(
(device_id, PM2_5, pm2_5, datetime,
ele_quantity, voltage, device_temp))
cur.executemany(sql, values)
conn.commit()
cur.close()
conn.close()
except:
print "insert data failed!"
def Post(args):
config = confLoader()
try:
conn = MySQLdb.connect(host=config.get_host(),
port=config.get_port(),
user=config.get_user(),
passwd=config.get_passwd(),
db=config.get_db(),
charset='utf8')
cur = conn.cursor()
sql = 'insert into sensor_data(device_id, sensor_id, value,\
datetime, ele_quantity, voltage, \
device_temp) values (%s, %s,%s, %s, %s, %s, %s)'
values = []
for arg in args:
datetime = arg["time"]
temperature = arg["temperature"]
humidity = arg['humidity']
noise = arg['noise']
pm2_5 = arg['pm2_5']
device_id = arg['device_id']
voltage = arg['voltage']
ele_quantity = arg['ele_quantity']
device_temp = arg['device_temp']
values.append((device_id, TEMPERATURE, temperature, datetime,
ele_quantity, voltage, device_temp))
values.append((device_id, HUMIDITY, humidity, datetime,
ele_quantity, voltage, device_temp))
values.append((device_id, NOISE, noise, datetime, ele_quantity,
voltage, device_temp))
values.append((device_id, PM2_5, pm2_5, datetime, ele_quantity,
voltage, device_temp))
cur.executemany(sql, values)
conn.commit()
cur.close()
conn.close()
except:
print "insert data failed!"
