- 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 setId(self):
- if self.id in self.properties :
- self.properties.remove(self.id)
- [self.id].extend(self.properties)
-
- def execute(self):
- query = Query.delete(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 delete"
- return execute_query(self.request, query)