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-10 16:53:17 +02:00
|
|
|
w.c.s. OLAP
|
2016-05-12 21:31:16 +02:00
|
|
|
~~~~~~~~~~~
|
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-10 16:53:17 +02:00
|
|
|
|
|
|
|
Tool to export w.c.s. data in a database with star schema for making an OLAP
|
2016-05-12 21:31:16 +02:00
|
|
|
cube.
|
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-10 16:53:17 +02:00
|
|
|
|
2016-05-12 21:31:16 +02:00
|
|
|
::
|
|
|
|
|
|
|
|
usage: wcs-olap [--no-feed] [-a | --url URL] [-h] [--orig ORIG] [--key KEY]
|
|
|
|
[--pg-dsn PG_DSN] [--schema SCHEMA]
|
|
|
|
[config_path]
|
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-10 16:53:17 +02:00
|
|
|
|
|
|
|
Export W.C.S. data as a star schema in a postgresql DB
|
|
|
|
|
2016-05-12 21:31:16 +02:00
|
|
|
positional arguments:
|
|
|
|
config_path
|
|
|
|
|
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-10 16:53:17 +02:00
|
|
|
optional arguments:
|
2016-05-12 21:31:16 +02:00
|
|
|
--no-feed only produce the model
|
|
|
|
-a, --all synchronize all wcs
|
|
|
|
--url URL url of the w.c.s. instance
|
|
|
|
-h, --help show this help message and exit
|
|
|
|
--orig ORIG origin of the request for signatures
|
|
|
|
--key KEY HMAC key for signatures
|
|
|
|
--pg-dsn PG_DSN Psycopg2 DB DSN
|
|
|
|
--schema SCHEMA schema name
|
2017-03-01 16:59:15 +01:00
|
|
|
|
|
|
|
Requirements
|
|
|
|
------------
|
|
|
|
|
|
|
|
PostgreSQL > 9.4 is required.
|