def export_communes(request):
entries = get_communes('73')
entries = flatten(entries).get('entries')
add_header_row(entries, 'Commune', years_p, years_t)
return {
"rows": array(entries).transpose(),
"filename": 'export_communes.csv'
}
def export_zonessensibles(request):
global years_p, years_t
DBSession.execute('SET search_path TO cables73, public')
query = DBSession.query(TVZonesSensibles)
if request.params.has_key('ids'):
ids = map(int, request.params.get('ids').split(','))
query = query.filter(TVZonesSensibles.id_zone_sensible.in_(ids))
years_p = tuple(sorted(
map(to_int, DBSession.query(year_extract_p).distinct().all())))
years_t = tuple(sorted(
map(to_int, DBSession.query(year_extract_t).distinct().all())))
entries = map(zs_to_dict, query)
add_header_row(entries, 'nom', years_p, years_t)
return array(entries).transpose()
def export_departements(request):
grouped = 'group' in request.params
flattened = flatten(get_communes(u'73') + get_communes(u'74'),
compute_years=True)
entries = flattened.get('entries')
if grouped:
entries73, entries74 = [
sum_dept_values(entries, d) for d in [u'73', u'74']
]
entries = concatenate(([entries73], [entries74]), axis=0).tolist()
add_header_row(entries, u'Département' if grouped else
(u'Département', u'Commune'), flattened.get('p_years'),
flattened.get('t_years'))
return array(entries).transpose()
def export_life(request):
life = True if request.params['life'] == 'true' else False
flattened = flatten(get_communes(u'73', life=life) +
get_communes(u'74', life=life),
compute_years=True)
entries = sum_values(flattened.get('entries'), life).tolist()
entries[0] = 'Life' if life else 'Hors life'
entries = [entries]
add_header_row(entries, u'Life', flattened.get('p_years'),
flattened.get('t_years'))
return {
"rows": array(entries).transpose(),
"filename": 'export_life.csv' if life else 'export_hors_life.csv'
}
def export_communes(request):
entries = get_communes('73')
entries = flatten(entries).get('entries')
add_header_row(entries, 'Commune', years_p, years_t)
return array(entries).transpose()