+import json
from django.template import RequestContext
from django.shortcuts import render_to_response
from unfold.page import Page
from manifold.core.query import Query, AnalyzedQuery
+from manifold.manifoldapi import execute_query
from ui.topmenu import topmenu_items, the_user
from plugins.stack import Stack
from plugins.tabs import Tabs
from plugins.querytable import QueryTable
+from plugins.querygrid import QueryGrid
from plugins.queryupdater import QueryUpdater
from plugins.googlemap import GoogleMap
from plugins.senslabmap import SensLabMap
from plugins.scheduler import Scheduler
from plugins.querycode import QueryCode
-from plugins.query_editor import QueryEditor
+# Thierry
+# stay away from query editor for now as it seems to make things go very slow
+# see https://lists.myslice.info/pipermail/devel-myslice/2013-December/000221.html
+#from plugins.query_editor import QueryEditor
from plugins.active_filters import ActiveFilters
from plugins.quickfilter import QuickFilter
from plugins.messages import Messages
tmp_default_slice='ple.upmc.myslicedemo'
# temporary : turn off the users part to speed things up
-#do_query_users=True
-do_query_users=False
+do_query_users=True
+#do_query_users=False
#do_query_leases=True
do_query_leases=False
+insert_grid=False
+#insert_grid=True
+
insert_messages=False
#insert_messages=True
main_query = Query.get('slice').filter_by('slice_hrn', '=', slicename)
main_query.select(
'slice_hrn',
- 'resource.hrn', 'resource.urn', 'resource.hostname', 'resource.type',
+ #'resource.hrn', 'resource.urn',
+ 'resource.hostname', 'resource.type',
'resource.network_hrn',
'lease.urn',
'user.user_hrn',
)
# for internal use in the querytable plugin;
# needs to be a unique column present for each returned record
- #main_query_key = 'hrn'
+ main_query_init_key = 'hostname'
query_resource_all = Query.get('resource').select(resource_fields)
- if do_query_users:
- query_user_all = Query.get('user').select(user_fields)
-
+
aq = AnalyzedQuery(main_query, metadata=metadata)
page.enqueue_query(main_query, analyzed_query=aq)
page.enqueue_query(query_resource_all)
if do_query_users:
- page.enqueue_query(query_user_all)
+ # Required: the user must have an authority in its user.config
+ # XXX Temporary solution
+ user_query = Query().get('local:user').select('config','email')
+ user_details = execute_query(self.request, user_query)
+
+ # not always found in user_details...
+ config={}
+ for user_detail in user_details:
+ #email = user_detail['email']
+ if user_detail['config']:
+ config = json.loads(user_detail['config'])
+ user_detail['authority'] = config.get('authority',"Unknown Authority")
+
+ if user_detail['authority'] is not None:
+ sub_authority = user_detail['authority'].split('.')
+ root_authority = sub_authority[0]
+ query_user_all = Query.get(root_authority+':user').select(user_fields)
+
+ # XXX TODO this filter doesn't work - to be improved in Manifold
+ #.filter_by('authority.authority_hrn', '=', user_detail['authority'])
+
+ page.enqueue_query(query_user_all)
+ else:
+ print "authority of the user is not in local:user db"
+ query_user_all = Query.get('user').select(user_fields)
+ # query_user_all = None
# ... and for the relations
# XXX Let's hardcode resources for now
# --------------------------------------------------------------------------
# Filter Resources
- filter_query_editor = QueryEditor(
- page = page,
- query = sq_resource,
- query_all = query_resource_all,
- title = "Select Columns",
- domid = 'select-columns',
- )
+# turn off for now -- see above
+# filter_query_editor = QueryEditor(
+# page = page,
+# query = sq_resource,
+# query_all = query_resource_all,
+# title = "Select Columns",
+# domid = 'select-columns',
+# )
filter_active_filters = ActiveFilters(
page = page,
query = sq_resource,
page = page,
title = 'Filter Resources',
domid = 'filters',
- sons = [filter_query_editor, filter_active_filters],
+ sons = [# filter_query_editor,
+ filter_active_filters],
togglable = True,
toggled = 'persistent',
outline_complete = True,
togglable = False,
query = sq_resource,
query_all = query_resource_all,
+ # this key is the one issued by google
googlemap_api_key = Config().googlemap_api_key(),
+ # the key to use at init-time
+ init_key = main_query_init_key,
checkboxes = True,
# center on Paris
latitude = 49.,
# this is the query at the core of the slice list
query = sq_resource,
query_all = query_resource_all,
- # safer to use 'hrn' as the internal unique key for this plugin
- #id_key = main_query_key,
+ # use 'hrn' as the internal unique key for this plugin
+ init_key = main_query_init_key,
checkboxes = True,
datatables_options = {
'iDisplayLength': 25,
},
)
+ if insert_grid:
+ resources_as_grid = QueryGrid(
+ page = page,
+ domid = 'resources-grid',
+ title = 'Grid view',
+ # this is the query at the core of the slice list
+ query = sq_resource,
+ query_all = query_resource_all,
+ # use 'hrn' as the internal unique key for this plugin
+ # xxx todo on querygrid as well
+ # init_key = main_query_init_key,
+ checkboxes = True,
+ )
+
if do_query_leases:
resources_as_scheduler = Scheduler(
page = page,
resources_as_3dmap,
resources_as_list_area,
]
+ if insert_grid:
+ resources_sons.append(resources_as_grid)
resources_area = Tabs ( page=page,
domid="resources",
# --------------------------------------------------------------------------
# USERS
- if do_query_users:
+ if do_query_users and query_user_all is not None:
tab_users = Tabs(
page = page,
domid = 'users',