Commit Graph

238 Commits

Author SHA1 Message Date
Serghei Mihai a5b82bf9f6 utils: handle proxy objects in ods export (#38641) 2019-12-19 15:04:32 +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
Emmanuel Cazenave d27a8a3b59 jenkins: use ci@entrouvert.org for notifications 2019-10-02 13:41:26 +02:00
Benjamin Dauvergne 690ea992d1 schema: add Cube.warnings support (#36576) 2019-10-01 13:35:46 +02:00
Benjamin Dauvergne 29932ac31c remove all explicit quoting (#36488)
The schemas must contain quoted names for fields and tables when
necessary.
2019-09-28 11:03:37 +02:00
Benjamin Dauvergne f92ae54d47 engine: remove duplicated line (#36488) 2019-09-28 02:56:24 +02:00
Frédéric Péters 6e3b0bde61 tox: limit to django 1.11 (#36136) 2019-09-16 10:27:12 +02:00
Frédéric Péters 6618a50ef7 misc: adapt "display as PNG" to find canvas in new HTML tags (#36006) 2019-09-11 11:39:58 +02:00
Frédéric Péters 3c0e2bab16 misc: don't add a js datepicker on top of HTML5 date inputs (#35997) 2019-09-11 11:35:24 +02:00
Frédéric Péters 789d2d2d9b misc: force labels to be text for json view (#35885) 2019-09-06 15:40:20 +02:00
Serghei Mihai 7bb07886b8 debian: add version for python-dependency (#35546) 2019-08-23 09:23:46 +02:00
Frédéric Péters 9fbda03caf misc: require authentication to download ods (#35447) 2019-08-19 14:39:03 +02:00
Frédéric Péters b3839357a7 api: use empty strings for None labels (#35448) 2019-08-19 14:39:03 +02:00
Frédéric Péters d38873bdd4 build: limit to django-jsonfield<1.3, for Python 2 support 2019-08-18 12:58:40 +02:00
Frédéric Péters eacd1a51f5 misc: account for slug default max length of 50 characters (#30855) 2019-08-13 08:16:27 +02:00
Benjamin Dauvergne c289591dd3 visualization: keep None value for dimension cells (#35295) 2019-08-12 20:18:19 +02:00
Benjamin Dauvergne 80332cfc1b schemas: handle case of an unique IS NULL filter (#32476) 2019-08-12 20:18:19 +02:00
Benjamin Dauvergne ace7a3407b engine: conserve table name case in SQL queries (#35130) 2019-08-12 20:18:19 +02:00
Frédéric Péters c196221f4b misc: add slugs to visualizations (#30855) 2019-08-12 20:15:23 +02:00
Frédéric Péters ad0e1065f0 debian: switch to uwsgi (#34659) 2019-07-08 21:38:19 +02:00
Frédéric Péters 84728f2236 jenkins: add support for hotfix releases (#34485) 2019-07-02 14:25:59 +02:00
Frédéric Péters 7ea6b54588 hobo deploy: don't skip secondary services that were declared (#33821) 2019-06-18 09:11:43 +02:00
Benjamin Dauvergne ac35b22162 templates: don't use gadjo popup for ODS links (#33035) 2019-05-13 11:12:22 +02:00