user_md = metadata.details_by_object('user')
user_fields = ['user_hrn'] # [column['name'] for column in user_md['column']]
+ query_resource_all = Query.get('resource').select(resource_fields)
+ page.enqueue_query(query_resource_all)
+
+ # leases query
+ #lease_md = metadata.details_by_object('lease')
+ #lease_fields = [column['name'] for column in lease_md['column']]
+
+ #query_lease_all = Query.get('lease').select(lease_fields)
+ #page.enqueue_query(query_lease_all)
+
+ slice_md = metadata.details_by_object('slice')
+ slice_fields = [column['name'] for column in slice_md['column']]
+ print "SLICE RES VIEW fields = %s" % slice_fields
# TODO The query to run is embedded in the URL
# Example: select slice_hrn, resource.urn, lease.resource, lease.start_time, lease.end_time from slice where slice_hrn == "ple.upmc.myslicedemo"
main_query = Query.get('slice').filter_by('slice_hrn', '=', slicename)
- main_query.select(
- # SLICE
- 'slice_hrn',
- # - The record key is needed otherwise the storage of records
- # bugs !
- 'slice_urn',
- # RESOURCES
- 'resource',
- 'lease',
- 'resource.urn',
- 'resource.hostname', 'resource.type',
- # - The facility_name and testbed_name are required for the
- # testbeds plugin to properly work.
- 'resource.facility_name',
- 'resource.testbed_name',
- # LEASES
- 'lease.resource',
- 'lease.start_time',
- 'lease.end_time',
- # - The lease_id is important for NITOS identify already existing
- # leases
- 'lease.lease_id',
-
- # FLOWSPACE
- #'flowspace',
- # VMS
- #'vms',
-
-
- #'user.user_hrn',
- #'application.measurement_point.counter'
- )
+ main_query.select(slice_fields)
+ # # SLICE
+ # 'slice_hrn',
+ # # - The record key is needed otherwise the storage of records
+ # # bugs !
+ # 'slice_urn',
+ # # RESOURCES
+ # 'resource',
+ # 'lease',
+ # 'resource.urn',
+ # 'resource.hostname', 'resource.type',
+ # # - The facility_name and testbed_name are required for the
+ # # testbeds plugin to properly work.
+ # 'resource.facility_name',
+ # 'resource.testbed_name',
+ # # LEASES
+ # 'lease.resource',
+ # 'lease.start_time',
+ # 'lease.end_time',
+ # # - The lease_id is important for NITOS identify already existing
+ # # leases
+ # 'lease.lease_id',
+
+ # # FLOWSPACE
+ # #'flowspace',
+ # # VMS
+ # #'vms',
+
+
+ # #'user.user_hrn',
+ # #'application.measurement_point.counter'
+ #)
# for internal use in the querytable plugin;
# needs to be a unique column present for each returned record
main_query_init_key = 'urn'
#sq_flowspace = aq.subquery('flowspace')
#sq_vms = aq.subquery('vms')
- query_resource_all = Query.get('resource').select(resource_fields)
- page.enqueue_query(query_resource_all)
-
- # leases query
- #lease_md = metadata.details_by_object('lease')
- #lease_fields = [column['name'] for column in lease_md['column']]
-
- #query_lease_all = Query.get('lease').select(lease_fields)
- #page.enqueue_query(query_lease_all)
-
# --------------------------------------------------------------------------
# ALL RESOURCES LIST
# resources as a list using datatable plugin