entrouvert
/
bijoe
17
0
Fork 0
Code Issues Pull Requests Releases Activity
252 Commits 19 Branches 109 Tags 5.5 MiB
Commit Graph

44 Commits

Author SHA1 Message Date
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 ebb9cb3e39 visualization: add warehouse slug support (#38596) 2020-01-15 15:27:32 +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
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 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 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 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 90a5bb49c4 Revert "utils: cache warehouses (#27412)" 
This reverts commit ba2c0c4fab.
 2019-11-25 15:06:20 +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
Benjamin Dauvergne 09c52ca6c3 views: export duration as numbers in JSON API (#36770) 2019-10-13 22:44:29 +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
Frédéric Péters 9fbda03caf misc: require authentication to download ods (#35447) 2019-08-19 14:39:03 +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
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 4796c5cf2e api: add json view of visualization data (#26847) 2019-03-19 08:03:32 +01:00
Frédéric Péters 85112b4ec8 tests: update for ods being a view (#30865) 2019-03-01 16:06:21 +01:00
Benjamin Dauvergne a0192447b4 tests: add test on timestamp column 2019-01-18 23:06:14 +01:00
Benjamin Dauvergne 3eba242597 correctly export numbers to ODS (fixes #28058) 2019-01-16 11:03:01 +01:00
Benjamin Dauvergne 5abfc1d236 schemas: add by year/month grouping (fixes #27406) 2019-01-16 11:00:50 +01:00
Benjamin Dauvergne 6974f1f56e add support for string columns (fixes #29768) 2019-01-16 10:57:21 +01:00
Benjamin Dauvergne 973f793f0a add support for boolean values (fixes #16346) 2019-01-15 17:13:04 +01:00
Benjamin Dauvergne 8d28b5012c visualization: add truncated previous year range (fixes #27407) 
It goes from 01/01 to 31/12 of previous year, i.e. if we are the
01/01/2019 it matches 01/01/2018-31/12/2018.
 2019-01-15 13:01:21 +01:00
Benjamin Dauvergne 86b169bd6c visualization: add setting to disable cache (#27407) 2019-01-15 13:01:21 +01:00
Benjamin Dauvergne 0dce40e5e9 engine: make Dimension.order_by a list (fixes #28175) 2018-12-10 11:39:38 +01:00
Benjamin Dauvergne 8d4a718c95 tests: add more real tests 2018-12-08 12:52:14 +01:00
Benjamin Dauvergne a1d572dbf8 tests: factorize get_table 2018-12-06 21:06:27 +01:00
Benjamin Dauvergne e9a4301542 engine: allow dimensions without joins (fixes #28191) 2018-12-06 17:28:45 +01:00
Benjamin Dauvergne cde575ce88 tests: add real ones with fixtures (fixes #27482) 2018-12-06 17:28:45 +01:00
Benjamin Dauvergne 626f5190dc support relative date ranges (fixes #13245) 
Modify DateRangeWidget so that it can return relative date strings instead of
ISO8691 date strings. Those strings are interpreted by a new class
bijoe.relative_time.RelativeDate.
 2016-09-22 10:42:05 +02:00
Benjamin Dauvergne a6959ccdab add missing tests and templates 2016-07-14 19:23:03 +02:00
Benjamin Dauvergne b6df6a2a35 bi-joe: BI engine and frontend for PostgreSQL 2016-05-25 01:24:07 +02:00