Branch: refs/heads/master
Home: https://github.com/volkszaehler/volkszaehler.org
Commit: cc369c6b2c1c606119e50a1c51f6884666468004
https://github.com/volkszaehler/volkszaehler.org/commit/cc369c6b2c1c606119e50a1c51f6884666468004
Author: andig <cpui...@gmx.de>
Date: 2018-03-28 (Wed, 28 Mar 2018)
Changed paths:
M composer.json
M lib/Interpreter/DataIterator.php
M lib/Interpreter/Interpreter.php
M lib/Interpreter/SQL/MySQLAggregateOptimizer.php
M lib/Interpreter/SQL/MySQLOptimizer.php
M lib/Interpreter/SQL/PostgreSQLOptimizer.php
M lib/Interpreter/SQL/SQLOptimizer.php
A lib/Interpreter/SQL/SensorInterpreterAverageTrait.php
M lib/Util/Aggregation.php
A lib/Util/ConsoleSQLLogger.php
M misc/tools/aggregate.php
M test/AggregationTest.php
M test/Data.php
M test/ProtocolTest.php
M test/RawTest.php
M test/SensorTest.php
Log Message:
-----------
SQL improvements: binary tuple packaging, weighed average, postgres support
(#682)
* Speedup tuple packaging
* Improve database compatibility and speed-up tuple packaging
* Improve aggregate ungrouped tuples=1 optimization
* Simplified weighed average implementation
* Simplify weighed average aggregation sql
* Ported weighed average sql to postgres
* Improve postgres compatibility
* Prevent double tuple packaging
* Cross-DB delete and PostgreSQL weighed average support
* Move buildGroupBySQL to optimizer
* Prevent SensorInterpreter from packaging twice
* Refactor and add packaging test
* Add time range to git clear
* Add SQL logging
* Add SQL formatting
* Fix merge artefact
* Rename since parameter
* Fix tuple packaging failing with ppm
