def get_events(request):
data = request.body
data = data.replace("'", "\"")
data = json.loads(data)
#get event in which user joined
db = db_layer.db_layer('event_members')
join_data = db.get_data(data['data'][0])
event_list = []
for i in join_data:
event_list.append(str(i['event_id']))
print event_list
db = db_layer.db_layer('ski_event')
out = {'start_time':[], 'end_time':[], 'venue':[], 'eventId':[], 'title':[], 'join':[], 'description':[]}
event_data = db.get_data({})
#tailoring the request
for i in event_data:
if str(i['event_id']) in event_list:
out['join'].append(True)
else:
out['join'].append(False)
# out['start_time'].append("%d:%d" %(i['start_time'].hour, i['start_time'].minute))
# out['end_time'].append("%d:%d" %(i['end_time'].hour, i['end_time'].minute))
# out['start_date'].append("%d-%d-%d" %(i['start_time'].month, i['start_time'].day, i['start_time'].year))
# out['end_date'].append("%d-%d-%d" %(i['end_time'].month, i['end_time'].day, i['end_time'].year))
out['title'].append(i['title'])
out['start_time'].append(str(i['start_time']))
out['end_time'].append(str(i['end_time']))
out['venue'].append(i['venue'])
out['description'].append(i['description'])
out['eventId'].append(i['event_id'])
return HttpResponse(json.dumps({'data':out,'status':"success"}), content_type="application/json")
def create_event(request):
data = ((request.body))
data = data.replace("'", "\"")
data = json.loads(data)
x =str(autoIncrement())
data['data'][0]['event_id']= x
# data['data'][0]['start_time'] = datetime.datetime.strptime(data['data'][0]['start_time'],'%Y-%m-%dT%H:%M:%S.%fZ')
# data['data'][0]['end_time'] = datetime.datetime.strptime(data['data'][0]['end_time'],'%Y-%m-%dT%H:%M:%S.%fZ')
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('ski_event')
db.set_data(data['data'])
db = db_layer.db_layer('event_members')
db.set_data([{'user_id':data['data'][0]['user_id'],'event_id':str(data['data'][0]['event_id'])}])
return HttpResponse(json.dumps({'data':"Event created Successfully",'status':"success"}), content_type="application/json")
def autoIncrementskiSId():
cnt=0;
db = db_layer.db_layer('ski_sessionid')
l = db.get_count()
cnt=l+1;
db.set_sessionCount(cnt)
return cnt
def autoIncrement():
cnt=0;
db = db_layer.db_layer('count')
l = db.get_count()
cnt=l+1;
db.set_count(cnt)
return cnt
def get_eventmembers(request):
data = request.body
data = data.replace("'", "\"")
data = json.loads(data)
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer("event_members")
info = db.get_data(data['data'][0])
print info
db = db_layer.db_layer("user")
l = []
for i in info:
x = db.get_data({"user_id": i['user_id']})[0]
l.append({"user_name":x['user_name'], "user_id":x['user_id']})
print l
return HttpResponse(json.dumps({'data':{'events': l} ,'status':"success"}), content_type="application/json")
def get_userInfo(request):
db = db_layer.db_layer('user')
userRecords=db.getUserRecords()
if not userRecords:
return HttpResponse(json.dumps({'data':[],'status':"failed"}))
else:
return HttpResponse(json.dumps({'Response':userRecords,'status':"success"}), content_type="application/json")
def join_event(request):
data = ((request.body))
data = data.replace("'", "\"")
data = json.loads(data)
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('event_members')
db.set_data(data['data'])
return HttpResponse(json.dumps({'data':"person joined the event",'status':"success"}), content_type="application/json")
def unjoin_event(request):
data = ((request.body))
data = data.replace("'", "\"")
data = json.loads(data)
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('event_members')
db.unjoin_event(data['data'][0]['user_id'],data['data'][0]['event_id'])
return HttpResponse(json.dumps({'data':"user-event pair deleted",'status':"success"}), content_type="application/json")
def update_currentloc(request):
data = request.body
data = data.replace("'", "\"")
data = json.loads(data)
current_time = datetime.datetime.utcnow()
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('user')
db.update({'user_id':data['data'][0]['user_id']}, {'user_location':data['data'][0]['CurrentLocation'], 'last_update':current_time})
return HttpResponse(json.dumps({'data':"location updated",'status':"success"}), content_type="application/json")
def get_skirecords(request):
data = ((request.body))
data = data.replace("'", "\"")
data = json.loads(data)
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('ski_session')
skiRecords=db.getCommonEvents(data['data'][0]['user_id'],data['data'][0]['player_id'])
if not skiRecords:
return HttpResponse(json.dumps({'data':"Matched event not found",'status':"failed"}))
else:
return HttpResponse(json.dumps({'data':skiRecords,'status':"success"}), content_type="application/json")
def check_user(request):
data = ((request.body))
data = data.replace("'", "\"")
data = json.loads(data)
print data
db = db_layer.db_layer('user')
l = db.get_data({'user_id':data['data'][0]['user_id']})
print l
if not l:
db.set_data(data['data'])
return HttpResponse(json.dumps({'data':" User created ",'status':"success"}), content_type="application/json")
else:
return HttpResponse(json.dumps({'data':" Already exists ",'status':"success"}), content_type="application/json")
def start_session(request):
data = request.body
data = data.replace("'", "\"")
data = json.loads(data)
x =autoIncrementskiSId()
data['data'][0]['session_id']= x
db = db_layer.db_layer('ski_session')
data['data'][0]['start_time'] = datetime.datetime.utcnow()
data['data'][0]['end_time'] = ''
data['data'][0]['distance'] = ''
data['data'][0]['location_trace'] = ''
db.set_data(data['data'])
return HttpResponse(json.dumps({'data':"session started",'status':"success"}), content_type="application/json")
def event_details(request):
data = ((request.body))
print data
data = data.replace("'", "\"")
data = json.loads(data)
print data
db = db_layer.db_layer('ski_event')
l = db.get_data(data['data'])
print l
if not l:
return HttpResponse(json.dumps({'data':"Event Notfound",'status':"failed"}))
else:
return HttpResponse(json.dumps({'data':l,'status':"success"}), content_type="application/json")
def end_session(request):
data = request.body
data = data.replace("'", "\"")
data = json.loads(data)
x =autoIncrementskiSId()
data['data'][0]['session_id']= x
if data == '':
return HttpResponse(json.dumps({'data':"no data received",'status':"failed"}), content_type="application/json")
db = db_layer.db_layer('ski_session')
db.set_data( [{'session_id':x, 'location_trace':data['data'][0]['Session_Data'], 'distance':data['data'][0]['distance'], 'end_time': data['data'][0]['end_time'], 'start_time': data['data'][0]['start_time'],
'user_id':data['data'][0]['User_id'],'event_id':data['data'][0]['Event_id']}])
return HttpResponse(json.dumps({'data':"session end recorded",'status':"success"}), content_type="application/json")
__author__ = 'musunuru'
import threading
import time
import paho.mqtt.client as mqtt
import db_layer
from smartbathroom.settings import mqtt_host
from smartbathroom import settings
from twilio.rest import TwilioRestClient
topic = "ui"
publish_topic = "sensor_control"
db = db_layer.db_layer("noti")
janitor_msg = "Hi, Service needed for wash room %s"
user_msg = "Hi, Washroom %s is empty now."
def on_connect(client, userdata, flags, rc):
print("[MQTT]Connected with result code "+str(rc))
client.subscribe(topic,0)
def on_message(client, userdata, msg):
# print(msg.topic+" "+str(msg.payload))
data = {}
if msg.topic == topic:
data = eval(msg.payload)
print data
id = data["restroom_id"]
if str(data["service"]) == "1":
janitor_list = db.get_data({"restroom_id":str(id), "type" :"service"})
for i in janitor_list:
send_text(i["telno"],janitor_msg %(id))
def main():
parser = argparse.ArgumentParser(\
description="Compute the dataset statistics.",
formatter_class=argparse.ArgumentDefaultsHelpFormatter)
parser.add_argument('--config', metavar="conf", nargs='?',
default="conf/config.json", help='Configuration file')
args = parser.parse_args()
db = db_layer(args.config)
languages = db.get_languages()
authors = db.get_authors()
print "total", len(authors)
print "Number of languages:", len(languages)
print "Languages:", ', '.join(languages)
ln_sts = {}
for ln in languages:
ln_sts[ln] = {}
authors_ids = db.get_authors(ln)
authors = [db.get_author(id_) for id_ in authors_ids]
ln_sts[ln]["num_authors"] = len(authors)
n_docs_per_author = [len(a["documents"]) for a in authors]
chars_per_author = [np.mean([len(c) for c in a["corpus"]])\
for a in authors]
ln_sts[ln]["num_documents"] = sum(n_docs_per_author)
ln_sts[ln]["avg_docs_per_author"] = np.mean(n_docs_per_author)
ln_sts[ln]["std_docs_per_author"] = np.std(n_docs_per_author)
ln_sts[ln]["min_docs_per_author"] = np.min(n_docs_per_author)
ln_sts[ln]["max_docs_per_author"] = np.max(n_docs_per_author)
ln_sts[ln]["avg_avg_chars_per_author"] = np.mean(chars_per_author)
ln_sts[ln]["std_avg_chars_per_author"] = np.std(chars_per_author)
ln_sts[ln]["min_avg_chars_per_author"] = np.min(chars_per_author)
ln_sts[ln]["max_avg_chars_per_author"] = np.max(chars_per_author)
print
print "Documents per author"
print "Lang & Num & Avg & Std & Min & Max\\\\"
for ln in ln_sts:
print "%4s & %3d & %5.2f & %5.2f & %3d & %3d\\\\" % \
(ln,
ln_sts[ln]["num_documents"],
ln_sts[ln]["avg_docs_per_author"],
ln_sts[ln]["std_docs_per_author"],
ln_sts[ln]["min_docs_per_author"],
ln_sts[ln]["max_docs_per_author"],
)
print
print "Average document length (chars) per author"
print "Lang & Avg & Std & Min & Max\\\\"
for ln in ln_sts:
print "%4s & %7.2f & %7.2f & %4d & %4d\\\\" % \
(ln,
ln_sts[ln]["avg_avg_chars_per_author"],
ln_sts[ln]["std_avg_chars_per_author"],
ln_sts[ln]["min_avg_chars_per_author"],
ln_sts[ln]["max_avg_chars_per_author"],
)
print
print "Bye!"
