X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=portal%2Fsliceresourceview.py;h=3fe521ad30cab5cbc844743dcf5f7fe3d45c67d7;hb=261afa50a6fade31685a23b104ab919bebaf25ef;hp=e66de0aeb770351c778b54a66d356a0747109960;hpb=b1e5d283ad0b1e97d227d235d966f4a92492cefc;p=myslice.git diff --git a/portal/sliceresourceview.py b/portal/sliceresourceview.py index e66de0ae..3fe521ad 100644 --- a/portal/sliceresourceview.py +++ b/portal/sliceresourceview.py @@ -1,23 +1,309 @@ -from django.template import RequestContext -from django.shortcuts import render_to_response +from django.template import RequestContext +from django.shortcuts import render_to_response from manifold.core.query import Query, AnalyzedQuery from manifoldapi.manifoldapi import execute_query +import json -from django.views.generic.base import TemplateView +from django.views.generic.base import TemplateView -from unfold.loginrequired import LoginRequiredView +from unfold.loginrequired import LoginRequiredView from django.http import HttpResponse from django.shortcuts import render -from unfold.page import Page -from manifold.core.query import Query, AnalyzedQuery -from manifoldapi.manifoldapi import execute_query +from unfold.page import Page + +from myslice.configengine import ConfigEngine -from theme import ThemeView +from plugins.apply import ApplyPlugin +from plugins.querytable import QueryTable +from plugins.googlemap import GoogleMap +# from plugins.queryupdater import QueryUpdaterPlugin +from plugins.filter_status import FilterStatusPlugin +from plugins.testbeds import TestbedsPlugin +from plugins.scheduler2 import Scheduler2 +from plugins.columns_editor import ColumnsEditor +from plugins.sladialog import SlaDialog +from plugins.lists.simplelist import SimpleList + +from myslice.theme import ThemeView class SliceResourceView (LoginRequiredView, ThemeView): template_name = "slice-resource-view.html" def get(self, request, slicename): - return render_to_response(self.template, {"slice": slicename, "theme": self.theme, "username": request.user, "section":"resources"}, context_instance=RequestContext(request)) + + if request.GET.get('message') : + msg = "Slice successfully updated" + else : + msg = None + + page = Page(request) + metadata = page.get_metadata() + page.expose_js_metadata() + + resource_md = metadata.details_by_object('resource') + resource_fields = [column['name'] for column in resource_md['column']] + + user_md = metadata.details_by_object('user') + user_fields = ['user_hrn'] # [column['name'] for column in user_md['column']] + + # 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.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', + + #'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' + aq = AnalyzedQuery(main_query, metadata=metadata) + page.enqueue_query(main_query, analyzed_query=aq) + sq_resource = aq.subquery('resource') + sq_lease = aq.subquery('lease') + + 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 + + list_resources = QueryTable( + page = page, + domid = 'resources-list', + title = 'List view', + query = sq_resource, + query_all = query_resource_all, + init_key = "urn", + checkboxes = True, + datatables_options = { + 'iDisplayLength': 25, + 'bLengthChange' : True, + 'bAutoWidth' : True, + }, + ) + + + # -------------------------------------------------------------------------- + # RESERVED RESOURCES LIST + # resources as a list using datatable plugin + + list_reserved_resources = SimpleList( + title = None, + page = page, + key = 'urn', + query = sq_resource, + ) + + list_reserved_leases = SimpleList( + title = None, + page = page, + key = 'resource', + query = sq_lease, + ) + +# list_reserved_resources = QueryTable( +# page = page, +# domid = 'resources-reserved-list', +# title = 'List view', +# query = sq_resource, +# query_all = sq_resource, +# init_key = "urn", +# checkboxes = True, +# datatables_options = { +# 'iDisplayLength': 25, +# 'bLengthChange' : True, +# 'bAutoWidth' : True, +# }, +# ) + + # -------------------------------------------------------------------------- + # COLUMNS EDITOR + # list of fields to be applied on the query + # this will add/remove columns in QueryTable plugin + + filter_column_editor = ColumnsEditor( + page = page, + query = sq_resource, + query_all = query_resource_all, + title = "Select Columns", + domid = 'select-columns', + ) + + # -------------------------------------------------------------------------- + # RESOURCES MAP + # the resources part is made of a Tabs (Geographic, List), + + map_resources = GoogleMap( + page = page, + title = 'Geographic view', + domid = 'resources-map', + # tab's sons preferably turn this off + togglable = False, + query = sq_resource, + # this key is the one issued by google + googlemap_api_key = ConfigEngine().googlemap_api_key(), + # the key to use at init-time + init_key = main_query_init_key, + checkboxes = True, + + # To center around Europe : 53,9 / 3 + latitude = 53., + longitude = 9., + zoom = 3, + ) + + # -------------------------------------------------------------------------- + # LEASES Nitos Scheduler + # Display the leases reservation timeslots of the resources + + resources_as_scheduler2 = Scheduler2( + page = page, + domid = 'scheduler', + title = 'Scheduler', + # this is the query at the core of the slice list + query = sq_resource, + query_lease = sq_lease, + ) + + # -------------------------------------------------------------------------- + # QueryUpdater (Pending Operations) + +# pending_resources = QueryUpdaterPlugin( +# page = page, +# title = 'Pending operations', +# query = main_query, +# togglable = False, +# # start turned off, it will open up itself when stuff comes in +# toggled = False, +# domid = 'pending', +# outline_complete = True, +# username = request.user, +# ) + + # -------------------------------------------------------------------------- + # NETWORKS + # testbeds as a list of filters + + network_md = metadata.details_by_object('network') + network_fields = [column['name'] for column in network_md['column']] + + #query_networks = Query.get('network').select(network_fields) + #page.enqueue_query(query_networks) + + filter_testbeds = TestbedsPlugin( + page = page, + domid = 'testbeds-filter', + title = 'Filter by testbeds', + query = sq_resource, + #query_networks = query_networks, + #init_key = "network_hrn", + #checkboxes = True, + #datatables_options = { + # 'iDisplayLength': 25, + # 'bLengthChange' : True, + # 'bAutoWidth' : True, + # }, + ) + + filter_status = FilterStatusPlugin( + page = page, + domid = "filter-status", + query = sq_resource, + ) + apply = ApplyPlugin( + page = page, + domid = "apply", + query = main_query, + username = request.user, + ) + + + # -------------------------------------------------------------------------- + # SLA View and accept dialog + + sla_dialog = SlaDialog( + page = page, + title = 'sla dialog', + query = main_query, + togglable = False, + # start turned off, it will open up itself when stuff comes in + toggled = True, + domid = 'sla_dialog', + outline_complete = True, + username = request.user, + ) + + ## check user is pi or not + platform_query = Query().get('local:platform').select('platform_id','platform','gateway_type','disabled') + account_query = Query().get('local:account').select('user_id','platform_id','auth_type','config') + platform_details = execute_query(self.request, platform_query) + account_details = execute_query(self.request, account_query) + + # XXX When session has expired, this is None and thus not iterable + for platform_detail in platform_details: + for account_detail in account_details: + if platform_detail['platform_id'] == account_detail['platform_id']: + if 'config' in account_detail and account_detail['config'] is not '': + account_config = json.loads(account_detail['config']) + if 'myslice' in platform_detail['platform']: + acc_auth_cred = account_config.get('delegated_authority_credentials','N/A') + # assigning values + if acc_auth_cred == {} or acc_auth_cred == 'N/A': + pi = "is_not_pi" + else: + pi = "is_pi" + + template_env = {} + template_env['list_resources'] = list_resources.render(self.request) + template_env['list_reserved_resources'] = list_reserved_resources.render(self.request) + template_env['list_reserved_leases'] = list_reserved_leases.render(self.request) + + template_env['columns_editor'] = filter_column_editor.render(self.request) + + template_env['filter_testbeds'] = filter_testbeds.render(self.request) + template_env['filter_status'] = filter_status.render(self.request) + template_env['apply'] = apply.render(self.request) + + template_env['map_resources'] = map_resources.render(self.request) + template_env['scheduler'] = resources_as_scheduler2.render(self.request) +# template_env['pending_resources'] = pending_resources.render(self.request) + template_env['sla_dialog'] = '' # sla_dialog.render(self.request) + template_env["theme"] = self.theme + template_env["username"] = request.user + template_env["pi"] = pi + template_env["slice"] = slicename + template_env["section"] = "resources" + template_env["msg"] = msg + template_env.update(page.prelude_env()) + + return render_to_response(self.template, template_env, context_instance=RequestContext(request))