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