+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 ui.topmenu import topmenu_items_live, the_user
from plugins.raw import Raw
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
#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
page.add_js_files ( [ "js/common.functions.js" ] )
page.add_js_chunks ('$(function() { messages.debug("sliceview: jQuery version " + $.fn.jquery); });')
page.add_js_chunks ('$(function() { messages.debug("sliceview: users turned %s"); });'%("on" if do_query_users else "off"))
+ page.add_js_chunks ('$(function() { messages.debug("sliceview: leases turned %s"); });'%("on" if do_query_leases else "off"))
config=Config()
page.add_js_chunks ('$(function() { messages.debug("manifold URL %s"); });'%(config.manifold_url()))
+
page.expose_js_metadata()
-
+
metadata = page.get_metadata()
resource_md = metadata.details_by_object('resource')
resource_fields = [column['name'] for column in resource_md['column']]
main_query = Query.get('slice').filter_by('slice_hrn', '=', slicename)
main_query.select(
'slice_hrn',
- 'resource.hrn', 'resource.hostname', 'resource.type',
+ #'resource.hrn', 'resource.urn',
+ 'resource.hostname', 'resource.type',
'resource.network_hrn',
- #'lease.urn',
+ 'lease.urn',
'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 = '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,
+ # 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,
+ title = 'Scheduler',
+ domid = 'scheduler',
+ query = sq_resource,
+ query_all_resources = query_resource_all,
+ query_lease = sq_lease,
+ )
+
# with the new 'Filter' stuff on top, no need for anything but the querytable
resources_as_list_area = resources_as_list
+ resources_sons = [
+ resources_as_gmap,
+ resources_as_3dmap,
+ resources_as_scheduler,
+ resources_as_list_area,
+ ] if do_query_leases else [
+ resources_as_gmap,
+ resources_as_3dmap,
+ resources_as_list_area,
+ ]
+ if insert_grid:
+ resources_sons.append(resources_as_grid)
+
resources_area = Tabs ( page=page,
domid="resources",
togglable=True,
title="Resources",
outline_complete=True,
- sons=[ resources_as_gmap,
- resources_as_3dmap,
- resources_as_list_area, ],
+ sons= resources_sons,
active_domid = 'resources-map',
+ persistent_active=True,
)
main_stack.insert (resources_area)
# --------------------------------------------------------------------------
# USERS
- if do_query_users:
+ if do_query_users and query_user_all is not None:
tab_users = Tabs(
page = page,
domid = 'users',
outline_complete = True,
))
-
# variables that will get passed to the view-unfold1.html template
template_env = {}
# more general variables expected in the template
template_env [ 'title' ] = '%(slicename)s'%locals()
# the menu items on the top
- template_env [ 'topmenu_items' ] = topmenu_items('Slice', request)
+ template_env [ 'topmenu_items' ] = topmenu_items_live('Slice', page)
# so we can sho who is logged
template_env [ 'username' ] = the_user (request)