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))
