-def slice(request, object_name, object_properties):
- query = Query().get('slice').filter_by('user.user_hrn', '==', '$user_hrn').select(object_properties)
- return send(request, execute_query(request, query), object_properties)
+ if ((self.type == 'platform') or (self.type == 'testbed')) :
+ self.type = 'local:platform'
+ self.id = 'platform'
+ self.properties = ['platform', 'platform_longname', 'platform_url', 'platform_description','gateway_type'];
+ self.filters['disabled'] = '0'
+ self.filters['gateway_type'] = 'sfa'
+ self.filters['platform'] = '!myslice'
+ else :
+ self.id = 'hrn'
+ 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('db error')
+ return None
+
+ def addFilters(self, properties):
+ selected_properties = []
+ for p in properties :
+ if p in self.properties :
+ selected_properties.append(p)
+ self.properties = selected_properties
+ self.setId()
+
+ def setId(self):
+ if self.id in self.properties :
+ self.properties.remove(self.id)
+ [self.id].extend(self.properties)
+
+ def execute(self):
+ query = Query.get(self.type).select(self.properties)
+ 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)
+ return execute_query(self.request, query)