-from manifold.core.query import Query
-
from django.views.generic.base import TemplateView
from django.shortcuts import render_to_response
from manifold.core.query import Query, AnalyzedQuery
from manifoldapi.manifoldapi import execute_query
-from string import join
-import decimal
-import datetime
-import json
-
-# handles serialization of datetime in json
-DateEncoder = lambda obj: obj.strftime("%B %d, %Y %H:%M:%S") if isinstance(obj, datetime.datetime) else None
-
-# support converting decimal in json
-json.encoder.FLOAT_REPR = lambda o: format(o, '.2f')
-
-# handles decimal numbers serialization in json
-class DecimalEncoder(json.JSONEncoder):
- def _iterencode(self, o, markers=None):
- if isinstance(o, decimal.Decimal):
- return (str(o) for o in [o])
- return super(DecimalEncoder, self)._iterencode(o, markers)
-
-class objectRequest(object):
-
- def __init__(self, request, object_type, object_name):
- self.type = object_type
- self.name = object_name
- # params required in update
- self.params = []
- self.properties = []
- self.filters = {}
- self.options = None
-
- self.request = request
-
- # What about key formed of multiple fields???
- query = Query.get('local:object').filter_by('table', '==', self.type).select('key')
- results = execute_query(self.request, query)
- print "key of object = %s" % results
- if results :
- for r in results[0]['key'] :
- self.id = r
- else :
- return error('Manifold db error')
+from rest import ObjectRequest, error, success
- query = Query.get('local:object').filter_by('table', '==', self.type).select('column.name')
- results = execute_query(self.request, query)
- if results :
- for r in results[0]['column'] :
- self.properties.append(r['name'])
- else :
- return error('Manifold db error')
+from string import join
- def execute(self):
- query = Query.update(self.type)
- if self.filters :
- for k, f in self.filters.iteritems() :
- if (f[:1] == "!") :
- query.filter_by(k, '!=', f[1:])
- elif (f[:2] == ">=") :
- query.filter_by(k, '>=', f[2:])
- elif (f[:1] == ">") :
- query.filter_by(k, '>', f[1:])
- elif (f[:2] == "<=") :
- query.filter_by(k, '<=', f[2:])
- elif (f[:1] == "<") :
- query.filter_by(k, '<', f[1:])
- else :
- query.filter_by(k, '==', f)
- else:
- raise Exception, "Filters are required for update"
- if self.params :
- query.set(self.params)
- else:
- raise Exception, "Params are required for update"
-
+import json
- return execute_query(self.request, query)
def dispatch(request, object_type, object_name):
- o = objectRequest(request, object_type, object_name)
-
- object_filters = {}
- object_params = {}
- result = {}
+ o = ObjectRequest(request, object_type, object_name)
if request.method == 'POST':
req_items = request.POST
elif request.method == 'GET':
- #return HttpResponse(json.dumps({'error' : 'only post request is supported'}), content_type="application/json")
+ #return error('only post request is supported')
req_items = request.GET
-
+ print req_items
for el in req_items.items():
+
+ print "#===============>",el
if el[0].startswith('filters'):
o.filters[el[0][8:-1]] = el[1]
elif el[0].startswith('params'):
- o.addParams(req_items.getlist('params[]'))
- elif el[0].startswith('columns'):
- o.addFilters(req_items.getlist('columns[]'))
+ print "#======> 0 ", el[0]
+ print "#======> 1 ", req_items.getlist(el[0])
+
+ if (el[0][-2:] == '[]') :
+ # when receiving params[key][] = 'value1' ...
+ #o.params.append({el[0][7:-3]:",".join(req_items.getlist(el[0]))})
+ o.params.append({el[0][7:-3]:req_items.getlist(el[0])})
+ else :
+ # when receiving params[key] = 'value'
+ o.params.append({el[0][7:-1]:el[1]})
+
+ print "o.params = ",o.params
+
+ elif el[0].startswith('fields'):
+ o.fields=req_items.getlist('fields[]')
elif el[0].startswith('options'):
o.options = req_items.getlist('options[]')
-
+
try:
- response = o.execute()
+ response = o.update()
if response :
- return HttpResponse(json.dumps({'success' : 'record updated'}), content_type="application/json")
+ return success('record updated')
else :
- return HttpResponse(json.dumps({'error' : 'an error has occurred'}), content_type="application/json")
+ return error('an error has occurred')
except Exception, e:
- return HttpResponse(json.dumps({'error' : str(e)}), content_type="application/json")
+ return error("exception:"+str(e))