X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=rest%2Fupdate.py;h=fdd95783438f2fc37bb2f77c262a1e32562d4876;hb=deee82377a1f72626cede01fdfec5e9d7cc274ce;hp=6cdf782645286705cdcd4bc5b31b266311ab8a60;hpb=08392b3c77e5f666ff3cb419e5666db35e319d08;p=myslice.git diff --git a/rest/update.py b/rest/update.py index 6cdf7826..fdd95783 100644 --- a/rest/update.py +++ b/rest/update.py @@ -1,121 +1,58 @@ -from manifold.core.query import Query +from rest import ObjectRequest, error, success from django.views.generic.base import TemplateView from django.shortcuts import render_to_response +from django.http import HttpResponse from unfold.loginrequired import LoginRequiredView -from django.http import HttpResponse 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') - - 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') - - 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" - - - return execute_query(self.request, query) +from myslice.settings import logger 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 - + logger.debug(req_items) for el in req_items.items(): + + logger.debug("#===============> {}".format(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[]')) + logger.debug("#======> 0 {}".format(el[0])) + logger.debug("#======> 1 {}".format(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]}) + + logger.debug("o.params = {}".format(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))