[vz-dev] [volkszaehler/volkszaehler.org] cc369c: SQL improvements: binary tuple packaging, weighed ...

[GitHub]

  Branch: refs/heads/master
  Home:   https://github.com/volkszaehler/volkszaehler.org
  Commit: cc369c6b2c1c606119e50a1c51f6884666468004
      https://github.com/volkszaehler/volkszaehler.org/commit/cc369c6b2c1c606119e50a1c51f6884666468004
  Author: andig <cpuidle at 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