def table_collection(tables_themes_id, active_tab): tables_themes_id = int(tables_themes_id) theme_id = tree.get_property('Tables_Themes', tables_themes_id, 'ID', 'ThemeID') table_id = tree.get_property('Tables_Themes', tables_themes_id, 'ID', 'TableID') identifier = tree.get_property('Tables', table_id, 'ID', 'Identifier') breadcrumbs = tree.get_parents(theme_id) children = tree.get_children(theme_id) if request.method == 'POST': session['collections'] = request.form.getlist('collections') query_options = {'UntypedDataSet':'$top=100', 'TypedDataSet':'$top=100'} if active_tab == 'Description': table = Table(identifier) else: table = Table(identifier, collections = [active_tab], query_options = query_options) table.set_feeds() context = {'theme_id':theme_id, 'tree':tree, 'children':children, 'breadcrumbs':breadcrumbs, 'tables_themes_id':tables_themes_id, \ 'table_id':table_id, 'table':table, 'collections':session['collections'], 'active_tab':active_tab} return render_template('table_show.html', **context)
def example_table(): """Example Table""" print '\n--- example module cbs : Table - service document ---\n' identifier = '81162eng' # other examples: 82220ned, 70072ned, 03759NED, 82172ned table = Table(identifier = identifier, query_options = {'UntypedDataSet':'?$top=1'}) table.set_feeds() # service document print 'Url service document = ', table.url print 'The service exposes {0} collections:'.format(len(table.collections)) for i, collection in enumerate(table.collections, 1): feed = table.feeds[collection] print '-', collection, '->', len(feed.entries), 'entries' # feed print '\n--- example module cbs : Table - feed or collection ---\n' collection = 'DataProperties' feed = table.feeds[collection] print 'Url feed = ', feed.url print 'The Feed {0} contains {1} entries, properties first entry:'.format(collection, len(feed.entries)) print "- names = ", feed.property_names print "- values = ", feed.entries[0].values() # dimensions dimensions = table.get_dimensions_dataset() print '\nThe table has {0} dimensions:'.format(len(dimensions)) for i, dimension in enumerate(dimensions, 1): print '-', dimension, '->', len(dimensions[dimension]), 'entries' dimension = list(dimensions)[0] print '\nDimension {0} contains {1} entries, key-value pairs:'.format(dimension, len(dimensions[dimension])) for key in list(dimensions[dimension])[0:3]: print '-', key, ':', dimensions[dimension][key] # variables variables = table.get_variables_dataset() print '\nThe table has {0} variables, top 3 variables:'.format(len(variables)) for variable in variables[0:3]: print '-', ', '.join([variable['name'], variable['label'], variable['type']]) # typed data set dataset = table.get_typed_dataset() print '\nThe table has {0} data entries, first entry (max top 5 variables):'.format(len(dataset)) for variable, value in zip(variables, dataset[0])[0:5]: print '-', variable, '=', value, '(type={0})'.format(type(value)) # untyped data set dataset = table.get_untyped_dataset() print '\nThe table has {0} data entries, first entry (max top 5 variables):'.format(len(dataset)) for variable, value in zip(variables, dataset[0])[0:5]: print '-', variable, '=', value, '(type={0})'.format(type(value))