Benjamin Dauvergne
f70c83aa08
add debian packaging
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne
9c44bb9711
wcs-olap: build a start schema from data exported by w.c.s. API
...
Given such an .INI file:
[https://demarches.triffouilly.fr/ ]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-19 11:13:12 +02:00
Benjamin Dauvergne
c8209c9c94
3m: convert bi_all_forms to a table
2016-05-19 11:12:59 +02:00
Benjamin Dauvergne
773eede548
fix bi_assainissement view in 3m_test.sql
2016-04-28 18:10:30 +02:00
Benjamin Dauvergne
d19233d2b7
fix typo
2016-04-28 15:13:30 +02:00
Benjamin Dauvergne
fef4726e92
remove eau potable and assainissement from global stats
2016-04-28 14:51:55 +02:00
Benjamin Dauvergne
3301318cef
3m: minimize downtime when updating bi database
2016-02-25 11:52:11 +01:00
Benjamin Dauvergne
d8de03a580
3m; remove encombrants from bi_all_forms view
2016-02-25 11:39:55 +01:00
Benjamin Dauvergne
9ed042e31c
3m: add missing line for Montpellier in poles.csv
2016-02-25 10:54:23 +01:00
Benjamin Dauvergne
c217cc2079
3m: update poles.csv
2016-02-22 10:29:48 +01:00
Benjamin Dauvergne
7921ec9e8d
3m: add cron script to update bi database each night
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
201827b171
3m: add bi_status view
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
5db2fc6699
3m: drop view bi_form before bi_all_forms as it depends on it
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
c8fee0c64d
3m: add status dimension
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
d90e09a1e2
3m: add production platform configuration slicer-prod.ini
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
aecd243b7d
3m: add script run-slicer.sh to run the slicer process
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
a560ea577e
3m: update poles.csv
2016-02-22 10:24:43 +01:00
Benjamin Dauvergne
8fdee376b7
add form and canal dimensions, add production platform sql script
2016-01-26 18:40:44 +01:00
Benjamin Dauvergne
1cf04b5035
3m: adapt model to schema change
2016-01-10 14:30:22 +01:00
Benjamin Dauvergne
03933109a4
3m: rename bi_poles.commune to pole_commune and views.commune to views.pole
...
_commune_ref
2016-01-10 14:29:27 +01:00
Benjamin Dauvergne
7713af2666
3m: add formdef_id to views
2016-01-10 14:29:03 +01:00
Benjamin Dauvergne
21d1b607e7
3m: remove poles from views as it's now directly joined by cubes
2016-01-10 14:28:38 +01:00
Benjamin Dauvergne
9e6f22cf32
3m: rebuild bi_all_forms containing only the current 7 forms
...
In order to see the common field commune.
2016-01-10 14:27:06 +01:00
Benjamin Dauvergne
331b5e634a
start of wcs olap importer
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
2397311591
3m: add bi_dates dimension table, add dimension nature_demande, exclude drafts
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
4ca7d45597
3m: fix db name for test platform
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
2c6a9c8f2b
3m: add cube bi_proprete
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
3d1b6375a4
3m: complete model.json for all voirie/public space forms
2016-01-09 22:06:12 +01:00
root
0bca3a1d82
mix commune and pole in a hierarchy, add weekday to other receipt_time hiearchies
2016-01-09 22:06:12 +01:00
Benjamin Dauvergne
f91737e9d4
add cubes configuration for 3m
2016-01-09 22:06:12 +01:00