def analysis(request):
# First step : create a list of the available links:
try:
if request.COOKIES['sim_name'] in tools_sql.list_sim_db():
# we create maxtimesim
sim_name = request.COOKIES['sim_name']
query = 'SELECT MAX(ev_time) AS max_time FROM ' + sim_name
output = tools_data.query_sql([query], True, 'pointq_db')
maxtimesim = int(round(output[0]['max_time']))
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(sim_name) + '\''
associated_network = tools_data.query_sql([query_1], True, 'network_db')[0]['name_network']
# we load the geojson of the associated network
query_2 = 'SELECT geojson FROM index_network WHERE name = \'' + str(associated_network) + '\''
geojson_associated_network = tools_data.query_sql([query_2], True, 'network_db')[0]['geojson']
# we load the topology json of the associated network
query_3 = 'SELECT topjson FROM index_network WHERE name = \'' + str(associated_network) + '\''
topjson_associated_network = tools_data.query_sql([query_3], True, 'network_db')[0]['topjson']
template = loader.get_template('pointqanalysis/index.html')
context = RequestContext(request, {'maxtimesim': maxtimesim, 'geojson': geojson_associated_network, 'topjson':topjson_associated_network})
return HttpResponse(template.render(context))
else:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
except:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
def testzone(request):
try:
if request.COOKIES['sim_name'] in tools_sql.list_sim_db():
sim_name = request.COOKIES['sim_name']
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(sim_name) + '\''
associated_network = tools_data.query_sql([query_1], True, 'network_db')[0]['name_network']
# we load the geojson of the associated network
query_2 = 'SELECT geojson FROM index_network WHERE name = \'' + str(associated_network) + '\''
geojson_associated_network = tools_data.query_sql([query_2], True, 'network_db')[0]['geojson']
# we load the topology json of the associated network
query_3 = 'SELECT topjson FROM index_network WHERE name = \'' + str(associated_network) + '\''
topjson_associated_network = tools_data.query_sql([query_3], True, 'network_db')[0]['topjson']
template = loader.get_template('pointqanalysis/vehicle_traj.html')
context = RequestContext(request, {'geojson': geojson_associated_network, 'topjson':topjson_associated_network})
return HttpResponse(template.render(context))
else:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
except:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
def upload_xml(request):
status = 'unposted'
# If we receive a POST request : the form has been submitted
if request.method == 'POST':
form = Form_upload_xml(request.POST, request.FILES)
form2 = Form_delete_xml(request.POST, request.FILES)
# if the form upload is valid (no error)
if form.is_valid() and form.is_multipart():
# we set delete form to normal
form2 = Form_delete_xml()
name_network = form.cleaned_data['name_network']
# we save the upload
tools_data.save_file(request.FILES['network_xml'], name_network,
'/upload/network_xml', '.xml')
# we convert the network
tools_sql.treat_network_db(name_network, '/upload/network_xml')
# we delete the upload
os.remove(settings.MEDIA_ROOT + '/upload/network_xml/' +
str(name_network) + '.xml')
status = 'posted'
# if form delete is valid
elif form2.is_valid() and form.is_multipart():
# we set upload form to normal
form = Form_upload_xml()
name_network_delete = form2.cleaned_data['name_network_delete']
# we build the query to delete the network from the database
query = 'DELETE FROM index_network WHERE name = \'' + name_network_delete + '\''
# we delete the row from the table
tools_data.query_sql([query], False, 'network_db')
status = 'posted'
# Else: the request is type GET: we print the form
else:
form = Form_upload_xml()
form2 = Form_delete_xml()
template = loader.get_template('pointqanalysis/uploadxml.html')
context = RequestContext(request, {
'form': form,
'form2': form2,
'status': status
})
return HttpResponse(template.render(context))
def treat_network_db(name,path):
# we create the table index_network if it's not created
query_1 = 'CREATE TABLE index_network (name text, geojson text, topjson text)'
tools_data.query_sql([query_1], False, 'network_db')
# we insert a new row in index_network
# query_2 = 'INSERT INTO index_network VALUES (\'' + name + '\',\'' + tools_json.xml2geojson(name) + '\')'
query_2 = 'INSERT INTO index_network VALUES (\'' + name + '\',\'' + tools_json.xml2geojson(name) + '\',\'' + tools_json.xml2topjson(name) + '\')'
tools_data.query_sql([query_2], False, 'network_db')
def treat_network_db(name,path):
# we create the table index_network if it's not created
query_1 = 'CREATE TABLE index_network (name text, geojson text, topjson text)'
tools_data.query_sql([query_1], False, 'network_db')
# we insert a new row in index_network
# query_2 = 'INSERT INTO index_network VALUES (\'' + name + '\',\'' + tools_json.xml2geojson(name) + '\')'
query_2 = 'INSERT INTO index_network VALUES (\'' + name + '\',\'' + tools_json.xml2geojson(name) + '\',\'' + tools_json.xml2topjson(name) + '\')'
tools_data.query_sql([query_2], False, 'network_db')
def upload_xml(request):
status = 'unposted'
# If we receive a POST request : the form has been submitted
if request.method == 'POST':
form = Form_upload_xml(request.POST, request.FILES)
form2 = Form_delete_xml(request.POST, request.FILES)
# if the form upload is valid (no error)
if form.is_valid() and form.is_multipart():
# we set delete form to normal
form2 = Form_delete_xml()
name_network= form.cleaned_data['name_network']
# we save the upload
tools_data.save_file(request.FILES['network_xml'], name_network , '/upload/network_xml', '.xml')
# we convert the network
tools_sql.treat_network_db(name_network, '/upload/network_xml')
# we delete the upload
os.remove(settings.MEDIA_ROOT + '/upload/network_xml/' + str(name_network) + '.xml')
status = 'posted'
# if form delete is valid
elif form2.is_valid() and form.is_multipart():
# we set upload form to normal
form = Form_upload_xml()
name_network_delete= form2.cleaned_data['name_network_delete']
# we build the query to delete the network from the database
query = 'DELETE FROM index_network WHERE name = \'' + name_network_delete + '\''
# we delete the row from the table
tools_data.query_sql([query], False, 'network_db')
status = 'posted'
# Else: the request is type GET: we print the form
else:
form = Form_upload_xml()
form2 = Form_delete_xml()
template = loader.get_template('pointqanalysis/uploadxml.html')
context = RequestContext(request, {'form': form, 'form2': form2, 'status': status})
return HttpResponse(template.render(context))
def get_my_choices():
# we create the table index_network if it's not created
# query_1 = 'CREATE TABLE index_network (name text, geojson text)'
query_1 = 'CREATE TABLE index_network (name text, geojson text, topjson text)'
tools_data.query_sql([query_1], False, 'network_db')
query_2 = 'SELECT name FROM index_network'
output = tools_data.query_sql([query_2], True, 'network_db')
liste_name = []
for line in output:
liste_name.append((line['name'], line['name']))
return liste_name
def get_my_choices():
# we create the table index_network if it's not created
# query_1 = 'CREATE TABLE index_network (name text, geojson text)'
query_1 = 'CREATE TABLE index_network (name text, geojson text, topjson text)'
tools_data.query_sql([query_1], False, 'network_db')
query_2 = 'SELECT name FROM index_network'
output = tools_data.query_sql([query_2], True, 'network_db')
liste_name = []
for line in output:
liste_name.append((line['name'], line['name']))
return liste_name
def simul_manag(request):
# If we receive a POST request : the form has been submitted
if request.method == 'POST':
form = Form_upload_fil(request.POST, request.FILES)
# if the form is valid (no error)
if form.is_valid() and form.is_multipart():
name_simul = form.cleaned_data['name_simul']
name_simul = re.sub('[^a-zA-Z0-9]', '_', name_simul)
name_network = form.cleaned_data['name_network']
# we save the upload
tools_data.save_file(request.FILES['simul_txt_db'], name_simul,
'/upload/txt_db', '.txt')
status = 'Thanks for uploading the text database'
# we convert the db
tools_sql.treat_simul_db(name_simul, '/upload/txt_db')
# we create the table index_network if it's not created
query_1 = 'CREATE TABLE index_simul_network (name_simul text, name_network text)'
tools_data.query_sql([query_1], False, 'network_db')
# we insert a new row in index_network
query_2 = 'INSERT INTO index_simul_network VALUES (\'' + name_simul + '\',\'' + name_network + '\')'
tools_data.query_sql([query_2], False, 'network_db')
# we delete the upload
os.remove(settings.MEDIA_ROOT + '/upload/txt_db/' +
str(name_simul) + '.txt')
else:
status = ''
# Else: the request is type GET: we print the form
else:
form = Form_upload_fil()
status = ''
template = loader.get_template('pointqanalysis/upload.html')
context = RequestContext(
request, {
'form': form,
'status': status,
'upload_xml': reverse('pointqanalysis:upload_xml')
})
return HttpResponse(template.render(context))
def json_plot_queue(queue, t_start, t_end, sim_name):
dataPoints = []
nb_veh_queue = 0
query = 'SELECT ev_time, ev_type FROM ' + sim_name + ' WHERE queue = \'' + queue + '\' AND (ev_type = 4 OR ev_type = 1 OR ev_type = 5)'
output = tools_data.query_sql([query], True, 'pointq_db')
for event in output:
if (event['ev_type'] == 1 or event['ev_type'] == 5):
nb_veh_queue += 1
else:
nb_veh_queue -= 1
if (event['ev_time'] >= t_start and event['ev_time'] <= t_end):
dataPoints.append({
'x': float(event['ev_time']),
'y': int(nb_veh_queue)
})
serie = {
'type': 'line',
'showInLegend': 'true',
'legendText': queue,
'dataPoints': dataPoints
}
return serie
def json_plot_flow(link, t_start, t_end, granul, sim_name):
# granularity sanity check
if t_end - t_start >= granul:
# number of iteration
iter = int((t_end - t_start) / granul)
# we start to iterate to create dataPoints
dataPoints = []
for i in range(iter):
query = 'SELECT COUNT(ev_time) FROM ' + sim_name + ' WHERE c_link = ' + str(
link) + ' AND ev_type =4 AND ev_time >= ' + str(
t_start +
i * granul) + ' AND ev_time < ' + str(t_start +
(i + 1) * granul)
output = tools_data.query_sql([query], True, 'pointq_db')
dataPoints.append({
'y':
float(output[0]['COUNT(ev_time)']),
'label':
'[' + str(t_start + i * granul) + '-' +
str(t_start + (i + 1) * granul) + ']'
})
#print(dataPoints)
serie = {
'type': 'column',
'showInLegend': 'true',
'legendText': str(link),
'dataPoints': dataPoints
}
return serie
else:
return '{}'
def json_plot_TT(orig, dest, t_start, t_end, sim_name):
query = 'SELECT time_entry, time_exit FROM ' + sim_name + ' WHERE entry_id = ' + str(orig) + ' AND c_loc_link = ' + str(dest) + ' AND time_entry >= ' + str(t_start) + ' AND time_entry <= ' +str(t_end)
output = tools_data.query_sql([query], True, 'pointq_db')
dataPoints=[]
for event in output:
#dataPoints.append({'x':1, 'y':2})
dataPoints.append({'x':float(event['time_entry']), 'y':(float(event['time_exit']-float(event['time_entry'])))});
serie = {'type': 'line', 'showInLegend': 'true', 'legendText': str(orig)+' to '+str(dest), 'dataPoints': dataPoints}
return serie
def analysis(request):
# First step : create a list of the available links:
try:
if request.COOKIES['sim_name'] in tools_sql.list_sim_db():
# we create maxtimesim
sim_name = request.COOKIES['sim_name']
query = 'SELECT MAX(ev_time) AS max_time FROM ' + sim_name
output = tools_data.query_sql([query], True, 'pointq_db')
maxtimesim = int(round(output[0]['max_time']))
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(
sim_name) + '\''
associated_network = tools_data.query_sql(
[query_1], True, 'network_db')[0]['name_network']
# we load the geojson of the associated network
query_2 = 'SELECT geojson FROM index_network WHERE name = \'' + str(
associated_network) + '\''
geojson_associated_network = tools_data.query_sql(
[query_2], True, 'network_db')[0]['geojson']
# we load the topology json of the associated network
query_3 = 'SELECT topjson FROM index_network WHERE name = \'' + str(
associated_network) + '\''
topjson_associated_network = tools_data.query_sql(
[query_3], True, 'network_db')[0]['topjson']
template = loader.get_template('pointqanalysis/index.html')
context = RequestContext(
request, {
'maxtimesim': maxtimesim,
'geojson': geojson_associated_network,
'topjson': topjson_associated_network
})
return HttpResponse(template.render(context))
else:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
except:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
def simul_manag(request):
# If we receive a POST request : the form has been submitted
if request.method == 'POST':
form = Form_upload_fil(request.POST, request.FILES)
# if the form is valid (no error)
if form.is_valid() and form.is_multipart():
name_simul = form.cleaned_data['name_simul']
name_simul = re.sub('[^a-zA-Z0-9]', '_', name_simul)
name_network = form.cleaned_data['name_network']
# we save the upload
tools_data.save_file(request.FILES['simul_txt_db'], name_simul , '/upload/txt_db', '.txt')
status = 'Thanks for uploading the text database'
# we convert the db
tools_sql.treat_simul_db(name_simul , '/upload/txt_db')
# we create the table index_network if it's not created
query_1 = 'CREATE TABLE index_simul_network (name_simul text, name_network text)'
tools_data.query_sql([query_1], False, 'network_db')
# we insert a new row in index_network
query_2 = 'INSERT INTO index_simul_network VALUES (\'' + name_simul + '\',\'' + name_network+ '\')'
tools_data.query_sql([query_2], False, 'network_db')
# we delete the upload
os.remove(settings.MEDIA_ROOT + '/upload/txt_db/' + str(name_simul) + '.txt')
else:
status = ''
# Else: the request is type GET: we print the form
else:
form = Form_upload_fil()
status =''
template = loader.get_template('pointqanalysis/upload.html')
context = RequestContext(request, {'form': form, 'status':status, 'upload_xml': reverse('pointqanalysis:upload_xml')})
return HttpResponse(template.render(context))
def length_links(links, associated_network):
lengths = {}
# we recover the json of the network from the database
query = "SELECT geojson FROM index_network WHERE name = \'" + associated_network + "\'"
geojson = tools_data.query_sql([query], True, 'network_db')[0]['geojson']
geojson = json.loads(geojson)
for feature in geojson['features']:
if int(feature['properties']['id']) in links and feature['geometry']['type'] == 'LineString':
lengths[str(feature['properties']['id'])] = feature['properties']['length']
return lengths
def testzone(request):
try:
if request.COOKIES['sim_name'] in tools_sql.list_sim_db():
sim_name = request.COOKIES['sim_name']
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(
sim_name) + '\''
associated_network = tools_data.query_sql(
[query_1], True, 'network_db')[0]['name_network']
# we load the geojson of the associated network
query_2 = 'SELECT geojson FROM index_network WHERE name = \'' + str(
associated_network) + '\''
geojson_associated_network = tools_data.query_sql(
[query_2], True, 'network_db')[0]['geojson']
# we load the topology json of the associated network
query_3 = 'SELECT topjson FROM index_network WHERE name = \'' + str(
associated_network) + '\''
topjson_associated_network = tools_data.query_sql(
[query_3], True, 'network_db')[0]['topjson']
template = loader.get_template('pointqanalysis/vehicle_traj.html')
context = RequestContext(
request, {
'geojson': geojson_associated_network,
'topjson': topjson_associated_network
})
return HttpResponse(template.render(context))
else:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
except:
return HttpResponseRedirect(reverse('pointqanalysis:simulations'))
def list_sim_db():
# we create the xml doc to store the list
root = etree.Element('root')
# connection database
query = 'SELECT name FROM SQLITE_MASTER WHERE type=\'table\' ORDER BY name'
query_answer = tools_data.query_sql([query], True, 'pointq_db')
for line in query_answer:
sim = etree.Element('sim')
sim.text = line['name']
root.append(sim)
#return xml
xml = etree.tostring(root)
return xml
def list_sim_db():
# we create the xml doc to store the list
root = etree.Element('root')
# connection database
query = 'SELECT name FROM SQLITE_MASTER WHERE type=\'table\' ORDER BY name'
query_answer = tools_data.query_sql([query], True, 'pointq_db')
for line in query_answer:
sim = etree.Element('sim')
sim.text = line['name']
root.append(sim)
#return xml
xml = etree.tostring(root)
return xml
def json_plot_link_occupancy(dict_link_occupancy, t_start, t_end, sim_name):
list_serie = []
# for each link we want to plot the occupancy
for link in dict_link_occupancy.keys():
dataPoints = []
nb_veh_queue = 0
# we build the query
query_partial = '('
for second_link in dict_link_occupancy[link]:
if second_link == dict_link_occupancy[link][0]:
query_partial += 'queue = \'[' + str(link) + ', ' + str(
second_link) + ']\''
else:
query_partial += ' OR queue = \'[' + str(link) + ', ' + str(
second_link) + ']\''
query_partial += ')'
query = 'SELECT ev_time, ev_type FROM ' + sim_name + ' WHERE ' + query_partial + ' AND (ev_type = 4 OR ev_type = 1 OR ev_type = 5)'
output = tools_data.query_sql([query], True, 'pointq_db')
for event in output:
if (event['ev_type'] == 1 or event['ev_type'] == 5):
nb_veh_queue += 1
else:
nb_veh_queue -= 1
if (event['ev_time'] >= t_start and event['ev_time'] <= t_end):
dataPoints.append({
'x': float(event['ev_time']),
'y': int(nb_veh_queue)
})
serie = {
'type': 'line',
'showInLegend': 'true',
'legendText': 'Link ' + link + ' occupancy',
'dataPoints': dataPoints
}
list_serie.append(serie)
return list_serie
def json_plot_flow(link, t_start, t_end, granul, sim_name):
# granularity sanity check
if t_end - t_start >= granul :
# number of iteration
iter = int((t_end - t_start) / granul)
# we start to iterate to create dataPoints
dataPoints = []
for i in range(iter):
query = 'SELECT COUNT(ev_time) FROM ' + sim_name + ' WHERE c_link = ' + str(link) + ' AND ev_type =4 AND ev_time >= ' + str(t_start + i * granul) + ' AND ev_time < ' + str(t_start + (i + 1) * granul)
output = tools_data.query_sql([query], True, 'pointq_db')
dataPoints.append({'y': float(output[0]['COUNT(ev_time)']), 'label': '['+ str(t_start + i * granul) + '-' + str(t_start + (i + 1) * granul) + ']'})
#print(dataPoints)
serie = {'type': 'column', 'showInLegend': 'true', 'legendText': str(link), 'dataPoints': dataPoints}
return serie
else:
return '{}'
def json_plot_queue(queue, t_start, t_end, sim_name):
dataPoints = []
nb_veh_queue = 0
query = 'SELECT ev_time, ev_type FROM ' + sim_name + ' WHERE queue = \'' + queue + '\' AND (ev_type = 4 OR ev_type = 1 OR ev_type = 5)'
output = tools_data.query_sql([query], True, 'pointq_db')
for event in output:
if (event['ev_type'] == 1 or event['ev_type'] == 5):
nb_veh_queue += 1
else:
nb_veh_queue -= 1
if (event['ev_time'] >= t_start and event['ev_time'] <= t_end):
dataPoints.append({'x': float(event['ev_time']), 'y': int(nb_veh_queue)})
serie = {'type': 'line', 'showInLegend': 'true', 'legendText': queue, 'dataPoints': dataPoints}
return serie
def json_plot_TT(orig, dest, t_start, t_end, sim_name):
query = 'SELECT time_entry, time_exit FROM ' + sim_name + ' WHERE entry_id = ' + str(
orig) + ' AND c_loc_link = ' + str(dest) + ' AND time_entry >= ' + str(
t_start) + ' AND time_entry <= ' + str(t_end)
output = tools_data.query_sql([query], True, 'pointq_db')
dataPoints = []
for event in output:
#dataPoints.append({'x':1, 'y':2})
dataPoints.append({
'x':
float(event['time_entry']),
'y': (float(event['time_exit'] - float(event['time_entry'])))
})
# we sort datapoints by x values to avoid the bug
dataPoints.sort(key=lambda item: item['x'])
serie = {
'type': 'line',
'showInLegend': 'true',
'legendText': str(orig) + ' to ' + str(dest),
'dataPoints': dataPoints
}
return serie
def json_plot_link_occupancy(dict_link_occupancy, t_start, t_end, sim_name):
list_serie = []
# for each link we want to plot the occupancy
for link in dict_link_occupancy.keys():
dataPoints = []
nb_veh_queue = 0
# we build the query
query_partial = '('
for second_link in dict_link_occupancy[link]:
if second_link == dict_link_occupancy[link][0]:
query_partial += 'queue = \'[' + str(link) + ', ' + str(second_link) + ']\''
else:
query_partial += ' OR queue = \'[' + str(link) + ', ' + str(second_link) + ']\''
query_partial += ')'
query = 'SELECT ev_time, ev_type FROM ' + sim_name + ' WHERE ' + query_partial + ' AND (ev_type = 4 OR ev_type = 1 OR ev_type = 5)'
output = tools_data.query_sql([query], True, 'pointq_db')
for event in output:
if (event['ev_type'] == 1 or event['ev_type'] == 5):
nb_veh_queue += 1
else:
nb_veh_queue -= 1
if (event['ev_time'] >= t_start and event['ev_time'] <= t_end):
dataPoints.append({'x': float(event['ev_time']), 'y': int(nb_veh_queue)})
serie = {'type': 'line', 'showInLegend': 'true', 'legendText': 'Link ' + link + ' occupancy', 'dataPoints': dataPoints}
list_serie.append(serie)
return list_serie
def ajax(request):
if request.method == 'POST':
if request.POST.get("action", "") == 'veh_trajectory':
vehicles = json.loads(request.POST.get("vehicles", ""))
nb_veh = json.loads(request.POST.get("nb_veh", ""))
links = json.loads(request.POST.get("links", ""))
intersections = json.loads(request.POST.get("intersections", ""))
# First we calculate the length of each link
try:
sim_name = request.COOKIES['sim_name']
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(sim_name) + '\''
associated_network = tools_data.query_sql([query_1], True, 'network_db')[0]['name_network']
lengths = tools_sql.length_links(links, associated_network)
return HttpResponse(json.dumps(lengths))
except:
return HttpResponse('False')
else:
if request.GET.get('action', '') == 'listsim':
xml = tools_sql.list_sim_db()
return HttpResponse(xml)
elif request.GET.get('action', '') == 'deltable':
table = request.GET.get('table_name', '')
return HttpResponse(tools_sql.deltable(table))
elif request.GET.get('action', '') == 'set_cookie':
sim_name = request.GET.get('sim_name', '')
response = HttpResponse('Cookie')
response.set_cookie(key = 'sim_name', value = sim_name)
return response
elif request.GET.get('action', '') == 'redirect':
redirection = request.GET.get('redirection', '')
return HttpResponse(reverse('pointqanalysis:' + redirection))
elif request.GET.get('action', '') == 'get_from_node':
node_id = request.GET.get('node_id', '')
type_anal = request.GET.get('type', '')
if type_anal == 'flow':
answer = tools_json.json_get_output_links(node_id)
return HttpResponse(json.dumps(answer,indent=4), content_type="application/json")
elif request.GET.get('action', '') == 'list_vehicle_traj':
ori_link = request.GET.get('ori_link', '')
dest_link = request.GET.get('dest_link', '')
sim_name = request.COOKIES['sim_name']
answer = tools_sql.list_vehicle_traj(ori_link, dest_link, sim_name, 'pointq_db')
dic_routes = answer[0]
dic_veh = answer[1]
output = [[list(x), dic_routes[x][0], dic_routes[x][1]] for x in dic_routes.keys()]
json_output = json.dumps({"dic_veh" : dic_veh, 'routes': output})
return HttpResponse(json_output, content_type="application/json")
elif request.GET.get('action', '') == 'generate_json_plot':
# we treat the parameters
type_anal = request.GET.get('type', '')
t_start = int(request.GET.get('t_start', ''))
t_end = int(request.GET.get('t_end', ''))
sim_name = request.COOKIES['sim_name']
# first case: flows
if type_anal == 'flow':
granul = int(request.GET.get('granul', ''))
links = request.GET.get('links', '')
list_links = links.split('-')
data = []
for link_id in list_links:
data.append(tools_json.json_plot_flow(link_id, t_start, t_end, granul, sim_name))
title = {'text': 'Flows'}
axisX = {'title': "Time interval [s]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
axisY = {'title': "Flow [veh per interval]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
answer = {'title': title, 'exportEnabled': 'true', 'axisX': axisX, 'axisY': axisY, 'data': data}
return HttpResponse(json.dumps(answer, indent=4), content_type="application/json")
# second case : queues
elif type_anal == 'queue':
link_occupancy = request.GET.get('link_occupancy', '')
sep_queues_origin = request.GET.get('sep_queues_origin', '')
queues = request.GET.get('queues', '')
list_queues = queues.split('-')
queues_occupancy = {}
queues_origin = []
list_queues_treated = []
for queue in list_queues:
list_queues_treated.append('[' + queue.split('.')[0] + ', ' + queue.split('.')[1] + ']')
if link_occupancy == 'true':
list_first_link = []
for queue in list_queues_treated:
list_first_link.append(queue.split(',')[0][1:])
list_first_link_occupancy = set()
for first_link in list_first_link:
if (list_first_link.count(first_link) > 1):
list_first_link_occupancy.add(first_link)
for link in list_first_link_occupancy:
queues_occupancy[link] = []
for queue in list_queues_treated:
first_link = queue.split(',')[0][1:]
second_link = int(queue.split(',')[1][:-1])
if first_link in list_first_link_occupancy:
queues_occupancy[first_link].append(second_link)
# we delete keys of queues occupancy from list_queus treated
# queues_occupancy -> we want to plot the total occupancy of a link
# list_queues_treated -> we want to plot independant queues
list_queues_treated = [x for x in list_queues_treated if x.split(',')[0][1:] not in queues_occupancy.keys()]
elif sep_queues_origin == 'true':
# we reset list_queues_treated
list_queues_treated = []
# we create the string to plot queues without any separation
for queue in list_queues:
list_queues_treated.append('[' + queue.split('.')[1] + ', ' + queue.split('.')[2] + ']')
# we create an array to plot origin based separated queues
for queue in list_queues:
temp = []
temp.append(queue.split('.')[0])
temp.append(queue.split('.')[1])
temp.append(queue.split('.')[2])
queues_origin.append(temp)
data = []
# we generate the plots for independant queues
for queue in list_queues_treated:
data.append(tools_json.json_plot_queue(queue, t_start, t_end, sim_name))
# we generate the plots for the total occupancy of links
if link_occupancy == 'true':
list_series = tools_json.json_plot_link_occupancy(queues_occupancy, t_start, t_end, sim_name)
for serie in list_series:
data.append(serie)
# we generate the plots for origin based queues
if sep_queues_origin == 'true':
for queue in queues_origin:
data.append(tools_json.json_plot_queue_origin(queue, t_start, t_end, sim_name))
title = {'text': 'Queues'}
axisX = {'title': "Time [s]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
axisY = {'title': "Queue length [veh]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
answer = {'zoomEnabled': 'true', 'exportEnabled': 'true', 'title': title, 'axisX': axisX, 'axisY': axisY, 'data': data}
return HttpResponse(json.dumps(answer, indent=4), content_type="application/json")
#last case : ODs
elif type_anal == 'OD':
pairs = request.GET.get('ODs', '')
list_pairs = pairs.split('-')
list_pairs_treated = []
for pair in list_pairs:
list_pairs_treated.append(pair.split('.'))
data=[]
for pair in list_pairs_treated:
data.append(tools_json.json_plot_TT(int(pair[0]), int(pair[1]), t_start, t_end, sim_name))
title = {'text': 'Travel Time'}
axisX = {'title': "Entry Time [s]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
axisY = {'title': "Travel Time [s]", 'titleFontWeight': "lighter", 'titleFontSize': '17'}
answer = {'zoomEnabled': 'true', 'exportEnabled': 'true', 'title': title, 'axisX': axisX, 'axisY': axisY, 'data': data}
return HttpResponse(json.dumps(answer, indent=4), content_type="application/json")
else:
return False
def deltable(table_name): # connection database query_1 = 'DROP TABLE ' + str(table_name) query_2 = 'DELETE FROM index_simul_network WHERE name_simul = \'' + str(table_name) + '\'' tools_data.query_sql([query_2], False, 'network_db') return tools_data.query_sql([query_1], False, 'pointq_db')
def deltable(table_name): # connection database query_1 = 'DROP TABLE ' + str(table_name) query_2 = 'DELETE FROM index_simul_network WHERE name_simul = \'' + str(table_name) + '\'' tools_data.query_sql([query_2], False, 'network_db') return tools_data.query_sql([query_1], False, 'pointq_db')
def ajax(request):
if request.method == 'POST':
if request.POST.get("action", "") == 'veh_trajectory':
vehicles = json.loads(request.POST.get("vehicles", ""))
nb_veh = json.loads(request.POST.get("nb_veh", ""))
links = json.loads(request.POST.get("links", ""))
intersections = json.loads(request.POST.get("intersections", ""))
# First we calculate the length of each link
try:
sim_name = request.COOKIES['sim_name']
# which network is associated with the simulation
query_1 = 'SELECT name_network FROM index_simul_network WHERE name_simul = \'' + str(
sim_name) + '\''
associated_network = tools_data.query_sql(
[query_1], True, 'network_db')[0]['name_network']
lengths = tools_sql.length_links(links, associated_network)
return HttpResponse(json.dumps(lengths))
except:
return HttpResponse('False')
else:
if request.GET.get('action', '') == 'listsim':
xml = tools_sql.list_sim_db()
return HttpResponse(xml)
elif request.GET.get('action', '') == 'deltable':
table = request.GET.get('table_name', '')
return HttpResponse(tools_sql.deltable(table))
elif request.GET.get('action', '') == 'set_cookie':
sim_name = request.GET.get('sim_name', '')
response = HttpResponse('Cookie')
response.set_cookie(key='sim_name', value=sim_name)
return response
elif request.GET.get('action', '') == 'redirect':
redirection = request.GET.get('redirection', '')
return HttpResponse(reverse('pointqanalysis:' + redirection))
elif request.GET.get('action', '') == 'get_from_node':
node_id = request.GET.get('node_id', '')
type_anal = request.GET.get('type', '')
if type_anal == 'flow':
answer = tools_json.json_get_output_links(node_id)
return HttpResponse(json.dumps(answer, indent=4),
content_type="application/json")
elif request.GET.get('action', '') == 'list_vehicle_traj':
ori_link = request.GET.get('ori_link', '')
dest_link = request.GET.get('dest_link', '')
sim_name = request.COOKIES['sim_name']
answer = tools_sql.list_vehicle_traj(ori_link, dest_link, sim_name,
'pointq_db')
dic_routes = answer[0]
dic_veh = answer[1]
output = [[list(x), dic_routes[x][0], dic_routes[x][1]]
for x in dic_routes.keys()]
json_output = json.dumps({"dic_veh": dic_veh, 'routes': output})
return HttpResponse(json_output, content_type="application/json")
elif request.GET.get('action', '') == 'generate_json_plot':
# we treat the parameters
type_anal = request.GET.get('type', '')
t_start = int(request.GET.get('t_start', ''))
t_end = int(request.GET.get('t_end', ''))
sim_name = request.COOKIES['sim_name']
# first case: flows
if type_anal == 'flow':
granul = int(request.GET.get('granul', ''))
links = request.GET.get('links', '')
list_links = links.split('-')
data = []
for link_id in list_links:
data.append(
tools_json.json_plot_flow(link_id, t_start, t_end,
granul, sim_name))
title = {'text': 'Flows'}
axisX = {
'title': "Time interval [s]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
axisY = {
'title': "Flow [veh per interval]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
answer = {
'title': title,
'exportEnabled': 'true',
'axisX': axisX,
'axisY': axisY,
'data': data
}
return HttpResponse(json.dumps(answer, indent=4),
content_type="application/json")
# second case : queues
elif type_anal == 'queue':
link_occupancy = request.GET.get('link_occupancy', '')
sep_queues_origin = request.GET.get('sep_queues_origin', '')
queues = request.GET.get('queues', '')
list_queues = queues.split('-')
queues_occupancy = {}
queues_origin = []
list_queues_treated = []
for queue in list_queues:
list_queues_treated.append('[' + queue.split('.')[0] +
', ' + queue.split('.')[1] +
']')
if link_occupancy == 'true':
list_first_link = []
for queue in list_queues_treated:
list_first_link.append(queue.split(',')[0][1:])
list_first_link_occupancy = set()
for first_link in list_first_link:
if (list_first_link.count(first_link) > 1):
list_first_link_occupancy.add(first_link)
for link in list_first_link_occupancy:
queues_occupancy[link] = []
for queue in list_queues_treated:
first_link = queue.split(',')[0][1:]
second_link = int(queue.split(',')[1][:-1])
if first_link in list_first_link_occupancy:
queues_occupancy[first_link].append(second_link)
# we delete keys of queues occupancy from list_queus treated
# queues_occupancy -> we want to plot the total occupancy of a link
# list_queues_treated -> we want to plot independant queues
list_queues_treated = [
x for x in list_queues_treated
if x.split(',')[0][1:] not in queues_occupancy.keys()
]
elif sep_queues_origin == 'true':
# we reset list_queues_treated
list_queues_treated = []
# we create the string to plot queues without any separation
for queue in list_queues:
list_queues_treated.append('[' + queue.split('.')[1] +
', ' + queue.split('.')[2] +
']')
# we create an array to plot origin based separated queues
for queue in list_queues:
temp = []
temp.append(queue.split('.')[0])
temp.append(queue.split('.')[1])
temp.append(queue.split('.')[2])
queues_origin.append(temp)
data = []
# we generate the plots for independant queues
for queue in list_queues_treated:
data.append(
tools_json.json_plot_queue(queue, t_start, t_end,
sim_name))
# we generate the plots for the total occupancy of links
if link_occupancy == 'true':
list_series = tools_json.json_plot_link_occupancy(
queues_occupancy, t_start, t_end, sim_name)
for serie in list_series:
data.append(serie)
# we generate the plots for origin based queues
if sep_queues_origin == 'true':
for queue in queues_origin:
data.append(
tools_json.json_plot_queue_origin(
queue, t_start, t_end, sim_name))
title = {'text': 'Queues'}
axisX = {
'title': "Time [s]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
axisY = {
'title': "Queue length [veh]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
answer = {
'zoomEnabled': 'true',
'exportEnabled': 'true',
'title': title,
'axisX': axisX,
'axisY': axisY,
'data': data
}
return HttpResponse(json.dumps(answer, indent=4),
content_type="application/json")
#last case : ODs
elif type_anal == 'OD':
pairs = request.GET.get('ODs', '')
list_pairs = pairs.split('-')
list_pairs_treated = []
for pair in list_pairs:
list_pairs_treated.append(pair.split('.'))
data = []
for pair in list_pairs_treated:
data.append(
tools_json.json_plot_TT(int(pair[0]), int(pair[1]),
t_start, t_end, sim_name))
title = {'text': 'Travel Time'}
axisX = {
'title': "Entry Time [s]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
axisY = {
'title': "Travel Time [s]",
'titleFontWeight': "lighter",
'titleFontSize': '17'
}
answer = {
'zoomEnabled': 'true',
'exportEnabled': 'true',
'title': title,
'axisX': axisX,
'axisY': axisY,
'data': data
}
return HttpResponse(json.dumps(answer, indent=4),
content_type="application/json")
else:
return False