Commit Graph

259 Commits

Author SHA1 Message Date
Benjamin Dauvergne 06ac4ed296 utils: use schema mtime as cache key (#39153) 2020-02-06 15:39:51 +01:00
Frédéric Péters 0d8b5bd8ef misc: remove PNG export button (#38731)
It doesn't work anymore in Chrom* as top-frame navigation has been
removed.
2020-01-21 10:45:26 +01:00
Benjamin Dauvergne f0f976c470 visualization: adapt geojson view to change in data structures (#38965) 2020-01-21 10:44:04 +01:00
Benjamin Dauvergne 86a8568cd6 tests: really report SQL fixture errors (#38965)
Without the ON_ERROR_STOP flag `psql` does not report SQL errors thourgh
its exist status.
2020-01-21 10:43:13 +01:00
Benjamin Dauvergne d5aa874116 visualization: use formatting instead of unicode() (#38908) 2020-01-17 14:54:11 +01:00
Benjamin Dauvergne 7e858006b6 visualization: format axis members before JSON serialization (#38908) 2020-01-17 14:54:11 +01:00
Benjamin Dauvergne 0ddd5530ac tests: add test on javascript data rendering (#38908) 2020-01-17 14:54:02 +01:00
Benjamin Dauvergne 5473870dc2 visualisation: return 0.0 for None measures in json_data (#38913) 2020-01-15 23:42:20 +01:00
Benjamin Dauvergne 5b72a4be6d engine: force join to right when looking for members (#38913) 2020-01-15 23:42:20 +01:00
Benjamin Dauvergne f2b6ab958a tests: add test on json_data for None measures (#38913) 2020-01-15 23:42:20 +01:00
Valentin Deniaud f93d42834e scripts: populate warehouse_slug visualization parameter (#38596) 2020-01-15 15:30:23 +01:00
Valentin Deniaud ebb9cb3e39 visualization: add warehouse slug support (#38596) 2020-01-15 15:27:32 +01:00
Valentin Deniaud 9004d49fb7 schemas: remove duplicate key (#38596) 2020-01-15 15:27:32 +01:00
Valentin Deniaud d305de24fe hobo: give cubes a slug (#38596)
This also reverts commit 3e956befb4,
which was buggy since new is file scoped and cubes_slug config-section
scoped.
2020-01-15 15:27:32 +01:00
Benjamin Dauvergne 126ddfa812 engine: add missing parenthesis around ->> operator (#38932) 2020-01-14 10:52:57 +01:00
Benjamin Dauvergne 16b60621d4 engine: remove use of cross join (#38691)
It prevented reporting of NULL values.
2020-01-06 22:07:37 +01:00
Benjamin Dauvergne 8f204362a4 engine: simplifiy equivalent code (#38691)
The two branches built the same string.
2020-01-06 22:07:36 +01:00
Frédéric Péters dbe3ff07e3 translation update 2019-12-30 14:31:59 +01:00
Serghei Mihai 74a41d13ac utils: handle proxy objects in ods export (#38641) 2019-12-19 15:00:57 +01:00
Valentin Deniaud 6d790559a4 views: add pagination to visualizations list (#27410) 2019-12-17 10:18:03 +01:00
Benjamin Dauvergne 79a965f328 engine: add setting for postgresql init statements (#38462) 2019-12-12 15:41:53 +01:00
Valentin Deniaud 4f9c50badd visualization: use correct Visualization object (#38356) 2019-12-10 16:48:52 +01:00
Benjamin Dauvergne 980cb76aae settings: improve tests runtime by turning DEBUG off (#38067) 2019-12-04 19:30:58 +01:00
Benjamin Dauvergne 10b4405fd1 engine: propagate filters to dimension's members enumeration (#38067) 2019-12-04 19:30:42 +01:00
Benjamin Dauvergne 72e8d4c83e overhaul of query to table transformation (#38067)
* during query obtain dimension id and label if a different projection
is defined
* use object to materialize query results : Cells, DimensionCell,
MeasureCell
* handle stringification in the *Cell classes
* never ignore NULL dimension's values (it's detected in
Visualization.data() and added to the list of dimension members)
* sum of columns is only computed if there are more than one column
* sum of rows is only computed if there are more than one row
* full sum is only computed if there are more thant one column and more
than one row
* 1 dimension table are computed in the same maner as 2 dimensions
tables, no more discrepancies
* JSON web-service now use the same base methods table_2d() and table_1d()
as the native rendering in bijoe
* EngineDimension.members is specialized for bool dimensions (as it's
always True/False)
2019-12-03 21:04:01 +01:00
Benjamin Dauvergne 6402c7ea99 visualization/utils: remove dead import (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne e8e1d573c5 schemas: add an absent_label property to Dimension (#38067)
Also force lazy strings to unicode in to_json().
2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 2422edd733 engine: use LEFT OUTER JOIN to join with inline json join table (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne d603f14860 engine: hide NULL values of json dimensions in inline join table (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 4701568437 engine: cache proxy descriptor result on engine's cubes (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 3f7bedf0d3 engine: do not hardcode cube's json field name (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne a868f11d42 engine: cache EngineDimension.members (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 33a8eabdba utils: cache get_warehouses() result based on schema files paths (#38067) 2019-12-03 16:53:25 +01:00
Benjamin Dauvergne 9cc619ee0d tests: add option to update tables during tests (#38067)
If table contents change, we can measure the change and eventually
accept by copying new_table.json to tables.json. To activate it, use
--bijoe-store-table .
2019-12-03 16:53:22 +01:00
Benjamin Dauvergne 65a78b93dc tests: reformat json files for easier update (#38067)
Add script format_json_fixtures.py to canonicalize every JSON files in
fixtures to simplify management of changes in visualization results.
2019-12-03 15:20:58 +01:00
Benjamin Dauvergne 0a612f24ac tests: use tabulate to compare tables (#38067)
Comparing strings with assert gives better diffs thant comparing list of
lists when using the pytest's `-vv` option.
2019-12-03 13:52:30 +01:00
Benjamin Dauvergne 7f4f373e89 tests: load schema2 fixture only one time (#38067)
Use special db fixture (using pytest-django primitives and
transaction.atomic()) to initialize bijoe visualization only one time
for all tests on the schema2 fixture. It improves tests run time.
2019-12-03 13:52:30 +01:00
Frédéric Péters 833449e236 api: export measure type (#37935) 2019-11-29 11:59:07 +01:00
Valentin Deniaud 6553db03ed visualization: share warehouses between visualizations (#37913) 2019-11-25 15:06:20 +01:00
Valentin Deniaud 90a5bb49c4 Revert "utils: cache warehouses (#27412)"
This reverts commit ba2c0c4fab.
2019-11-25 15:06:20 +01:00
Frédéric Péters 039e32fb83 misc: move loop after drilldown parameters (#16019) 2019-11-23 17:55:23 +01:00
Valentin Deniaud 5d68c543b8 translation update 2019-11-21 14:46:49 +01:00
Valentin Deniaud 370a8e73e3 templates: allow deleting visualization from listing (#27412) 2019-11-21 11:56:15 +01:00
Valentin Deniaud a0caedde62 views: grey out unavailable visualizations (#27412) 2019-11-21 11:56:14 +01:00
Valentin Deniaud ba2c0c4fab utils: cache warehouses (#27412)
Disk reads take a long long time.
2019-11-21 11:54:21 +01:00
Valentin Deniaud 7a5373c91e utils: get tenant from import rather than request (#27412) 2019-11-21 11:53:27 +01:00
Benjamin Dauvergne 6716a7594f engine: quote join's aliases (#37495) 2019-11-07 19:20:41 +01:00
Thomas NOËL a7737d32c1 create .gitignore (#37520) 2019-11-07 12:17:46 +01:00
Benjamin Dauvergne 09c52ca6c3 views: export duration as numbers in JSON API (#36770) 2019-10-13 22:44:29 +02:00
Christophe Siraut 7a235b8aa8 cron: start import-wcs-data earlier 2019-10-03 16:21:38 +02:00