Commit Graph

82 Commits

Author SHA1 Message Date
Benjamin Dauvergne eda932f270 feeder: remove json_field of formdef cubes (fixes #28936) 2018-12-12 14:46:27 +01:00
Frédéric Péters 57d6536808 debian: fix syslog handler declaration (#27749) 2018-11-05 16:53:19 +01:00
Frédéric Péters 15aa7bcc59 ignore fields with dashes in their identifiers (#27755) 2018-11-05 16:53:19 +01:00
Benjamin Dauvergne 26dfb0d930 debian: configure logging in /etc/wcs-olap/config.init (fixes #19826)
Signed-off-by: Christophe Siraut <csiraut@entrouvert.com>
2018-09-22 13:35:12 +02:00
Emmanuel Cazenave 288d9c9d15 ease debugging (#26190) 2018-09-06 18:31:00 +02:00
Frédéric Péters bfe7b73cb4 feeder: feed evolutions to postgresql in reasonable chunks (#23399) 2018-04-25 13:39:31 +02:00
Frédéric Péters b43eaa2eb5 feeder: log WcsApiError (#23397) 2018-04-25 10:25:36 +02:00
Thomas NOËL f39ea073d5 cumulate global, site and user wcs-olap.ini config file (#17474) 2018-03-12 22:47:36 +01:00
Thomas NOËL f03b05cba9 fix last commit 2018-01-12 11:51:42 +01:00
Thomas NOËL 1c0f6a3b4c ignore formdata with unknown status (#21076) 2018-01-12 00:04:05 +01:00
Benjamin Dauvergne 4ff37ebaa2 wcs_api: adapt to change in formdefs API (fixes #20383) 2017-12-28 13:22:49 +01:00
Frédéric Péters 212bdeddf7 make batch size configurable (#17932) 2017-08-08 13:21:45 +02:00
Benjamin Dauvergne d5debf5200 remove tests from bijoe 2017-03-20 13:38:49 +01:00
Benjamin Dauvergne 8da1053e5a ignore locale errors (fixes #15511) 2017-03-20 13:37:48 +01:00
Benjamin Dauvergne b5d9c12fe9 activate json_field only if postgres version supports JSONB (fixes #15427) 2017-03-14 15:07:56 +01:00
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 c51d61e5ac remove create_dates.sql from install files 2017-02-28 09:49:47 +01:00
Benjamin Dauvergne 437efba63d add fax and email channels (fixes #15157) 2017-02-27 10:53:15 +01:00
Benjamin Dauvergne 3df888cb1d quote join names in field references 2017-02-26 01:30:10 +01:00
Benjamin Dauvergne 29738e16a0 Revert "improve date filters performance by filtering on the fact table (fixes #15068)"
This reverts commit 3eb2ffb196.
2017-02-26 01:29:06 +01:00
Benjamin Dauvergne c4e8f06b09 rename outer join to full outer join (fixes #11094) 2017-02-24 12:13:56 +01:00
Benjamin Dauvergne 3eb2ffb196 improve date filters performance by filtering on the fact table (fixes #15068) 2017-02-22 01:37:29 +01:00
Benjamin Dauvergne 1ab4dbf063 use outer join for optional fields (fixes #11094) 2017-02-22 01:37:24 +01:00
Benjamin Dauvergne ed9b1561cd allow filtering for all dimensions (fixes #14121) 2017-02-22 01:37:24 +01:00
Benjamin Dauvergne af01f30313 create dates table as part of feeding (fixes #14961) 2017-02-21 23:58:47 +01:00
Benjamin Dauvergne 0bf1faed1f add formdata.json_data column (fixes #14646)
It will be filled with unstructred representation of forms'datas.
2017-02-21 15:15:17 +01:00
Frédéric Péters a28b57fe53 don't consider field with duplicated varnames (#14503) 2017-01-05 14:25:54 +01:00
Benjamin Dauvergne 2bab882337 feeder: fix check for authorization errors 2016-12-11 01:17:44 +01:00
Benjamin Dauvergne 00f34ea1b1 If current status is invisible, search last one from evolutions (fixes #14257) 2016-12-10 10:19:29 +01:00
Benjamin Dauvergne 2bdd5ef6c2 add a fake parameter
It will build the temporary database but never copy it to the final name.

Signed-off-by: Benjamin Dauvergne <bdauvergne@entrouvert.com>
2016-12-09 16:40:26 +01:00
Benjamin Dauvergne c32a880373 feeder: empty the API cache before feeding each form
The cache grows too much without it.
2016-12-02 11:44:22 +01:00
Benjamin Dauvergne c3e14387b6 feeder: fix mismatch between insertion of generic evolutions and evolutions (#13028) 2016-11-12 10:57:28 +01:00
Benjamin Dauvergne a38f52b5fd feeder: skip evolutions with an unknown status (#13028) 2016-11-12 09:57:42 +01:00
Benjamin Dauvergne f517603aef cmd: do not clobber failure value after each run (#13733) 2016-11-12 09:57:20 +01:00
Benjamin Dauvergne 42753c1de3 feeder: import formdata evolutions in evolution* tables (fixes #13028) 2016-11-10 11:52:51 +01:00
Benjamin Dauvergne 688a2f0319 feeder: factorize computation of generic status (#13028) 2016-11-10 11:52:45 +01:00
Benjamin Dauvergne c89b7c8846 feeder: add primary key constraints on formdata_* tables (#13028) 2016-11-10 11:52:39 +01:00
Benjamin Dauvergne 561e91556f use multiprocessing to launch import in separate processes (fixes #13733) 2016-10-25 11:18:20 +02:00
Benjamin Dauvergne 18b023e91b add --slug parameter to command line (fixes #13665) 2016-10-19 09:47:28 +02:00
Benjamin Dauvergne ef41c85e6b fix conversion of geolocation to SQL (fixes #13666) 2016-10-19 09:46:13 +02:00
Benjamin Dauvergne d6d19c0326 exit with non-zero result on failure (fixes #13664) 2016-10-19 08:09:43 +02:00
Benjamin Dauvergne 2eb3cd2f6c revert geolocation support for now 2016-10-12 10:44:15 +02:00
Benjamin Dauvergne 215ad230f2 README.rst: document creation of the dates table 2016-10-12 10:41:01 +02:00
Benjamin Dauvergne aef72868f6 add support for workflow fields (fixes #13170) 2016-09-13 16:40:55 +02:00
Frédéric Péters f77e752ec1 get formdatas in batches of 1000 (#12724) 2016-08-27 16:05:54 +02:00
Benjamin Dauvergne 97b4230997 order categories, forms and agents by their label (fixes #12739) 2016-08-27 15:12:35 +02:00
Benjamin Dauvergne 9777ac8f05 ignore item fields having the anonymise flag 2016-08-01 17:12:35 +02:00
Benjamin Dauvergne fb610e82f7 export item fields without .options or .items array in their schema (fixes #12800)
It allows doing BI request on field feeded from a data source; beware that it
it will not work if the field's choice are in fact open and not closed (like a
list of things related to the user).
2016-07-29 17:49:29 +02:00
Benjamin Dauvergne 64a2204303 use the computed generic_status_id value 2016-07-29 17:46:45 +02:00
Benjamin Dauvergne eb8b36fd0f create a temporary schema and rename it to the final schema name if everything goes well (fixes #12801) 2016-07-29 17:46:17 +02:00