1 from manifold.core.query import Query
3 from django.views.generic.base import TemplateView
4 from django.shortcuts import render_to_response
6 from unfold.loginrequired import LoginRequiredView
7 from django.http import HttpResponse
9 from manifold.core.query import Query
10 from manifoldapi.manifoldapi import execute_query
12 from string import join
18 # handles serialization of datetime in json
19 DateEncoder = lambda obj: obj.strftime("%B %d, %Y %H:%M:%S") if isinstance(obj, datetime.datetime) else None
21 # support converting decimal in json
22 json.encoder.FLOAT_REPR = lambda o: format(o, '.2f')
24 # handles decimal numbers serialization in json
25 class DecimalEncoder(json.JSONEncoder):
26 def _iterencode(self, o, markers=None):
27 if isinstance(o, decimal.Decimal):
28 return (str(o) for o in [o])
29 return super(DecimalEncoder, self)._iterencode(o, markers)
31 class objectRequest(object):
33 def __init__(self, request, object_type, object_name):
34 self.type = object_type
35 self.name = object_name
40 self.request = request
42 # XXX TODO: What about the local: objects?
43 # Example: local:user (Manifold) is different from user (SFA GW)
45 if ((self.type == 'platform') or (self.type == 'testbed')) :
46 self.type = 'local:platform'
48 self.properties = ['platform', 'platform_longname', 'platform_url', 'platform_description','gateway_type'];
49 self.filters['disabled'] = '0'
50 self.filters['gateway_type'] = 'sfa'
51 self.filters['platform'] = '!myslice'
54 query = Query.get('local:object').filter_by('table', '==', self.type).select('column.name')
55 results = execute_query(self.request, query)
57 for r in results[0]['column'] :
58 self.properties.append(r['name'])
60 return error('db error')
63 def addFilters(self, properties):
64 selected_properties = []
66 if p in self.properties :
67 selected_properties.append(p)
68 self.properties = selected_properties
72 if self.id in self.properties :
73 self.properties.remove(self.id)
74 [self.id].extend(self.properties)
77 query = Query.get(self.type).select(self.properties)
79 for k, f in self.filters.iteritems() :
81 query.filter_by(k, '!=', f[1:])
82 elif (f[:2] == ">=") :
83 query.filter_by(k, '>=', f[2:])
85 query.filter_by(k, '>', f[1:])
86 elif (f[:2] == "<=") :
87 query.filter_by(k, '<=', f[2:])
89 query.filter_by(k, '<', f[1:])
91 query.filter_by(k, '==', f)
92 return execute_query(self.request, query)
94 def dispatch(request, object_type, object_name):
96 o = objectRequest(request, object_type, object_name)
98 if request.method == 'POST':
99 req_items = request.POST
100 elif request.method == 'GET':
101 req_items = request.GET
105 for el in req_items.items():
106 if el[0].startswith('filters'):
107 o.filters[el[0][8:-1]] = el[1]
108 elif el[0].startswith('columns'):
109 o.addFilters(req_items.getlist('columns[]'))
110 elif el[0].startswith('options'):
111 o.options = req_items.getlist('options[]')
113 response = o.execute()
115 if request.path.split('/')[1] == 'rest' :
116 response_data = response
117 return HttpResponse(json.dumps(response_data, cls=DecimalEncoder, default=DateEncoder), content_type="application/json")
118 elif request.path.split('/')[1] == 'table' :
119 return render_to_response('table-default.html', {'data' : response, 'properties' : o.properties, 'id' : o.id, 'options' : o.options})
120 elif request.path.split('/')[1] == 'datatable' :
122 response_data['columns'] = o.properties
123 response_data['labels'] = o.properties
124 response_data['data'] = []
125 response_data['total'] = len(response)
128 for p in o.properties :
130 response_data['data'].append(d)
132 return HttpResponse(json.dumps(response_data, cls=DecimalEncoder, default=DateEncoder), content_type="application/json")
135 return HttpResponse(json.dumps({'error' : msg}), content_type="application/json")