Commit Graph

6 Commits

Author SHA1 Message Date
Benjamin Dauvergne 437f4924d2 declare geolocation fields in schema files (fixes #14572)
It's declared as a measure whose value is the array aggregate of the points.
2017-03-01 17:01:11 +01:00
Benjamin Dauvergne af01f30313 create dates table as part of feeding (fixes #14961) 2017-02-21 23:58:47 +01:00
Benjamin Dauvergne 215ad230f2 README.rst: document creation of the dates table 2016-10-12 10:41:01 +02:00
Benjamin Dauvergne 7f46a1b8a8 standalone debian packaging 2016-06-24 15:47:37 +02:00
Benjamin Dauvergne 9314d9b9c6 bi-joe: BI engine and frontend for PostgreSQL 2016-05-25 01:24:07 +02:00
Benjamin Dauvergne ac3dc40a7a 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