]> git.basschouten.com Git - openhab-addons.git/commit
[dbquery] Initial contribution (#8780)
authorJoan Pujol <joanpujol@gmail.com>
Sun, 17 Oct 2021 12:33:18 +0000 (14:33 +0200)
committerGitHub <noreply@github.com>
Sun, 17 Oct 2021 12:33:18 +0000 (14:33 +0200)
commit6cb565295518802d5db3e1362bbcd5d0a3c0662e
tree9ac78931807eaf2ea19bfe16dfe9ce8a58da1730
parent642a2b79dc42c381f452ad5179cbc47cf97422fc
[dbquery] Initial contribution (#8780)

* Initial commit

Intial work history lost due to the repository shrunk done at c53e4aed2627ec899c083170430399f8925e3345 (intially started from old unshrunked repo)

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Implement reconnect attempts

If database can be connected at bridge initialization schedule retry attempts.
Prevent  query execution scheduling if bridge isn't online

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Minor documentation changes and fix trigger channel name

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Fix NPE bug initializing ThingActions

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Implement query actions and another fixes

Implement actions to execute query and get last query result
Correctly serialize as JSON non scalar results to result channels

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update parameters and correct channel

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Fix formatting and forgot part on previous commit

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Improve documentation

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Add javadoc comment and license to all classes

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Code cleanup

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Untrack unused i18n file

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Fix log level for query actions trace information

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Add dbquery addon to bundles pom

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Temporary remove mqtt bindings that make travis build to fail

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Fix formatting issue

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Revert "Temporary remove mqtt bindings that make travis build to fail"

This reverts commit 21c09957b5850230e1cf1bd2a83a42a088641a45.

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Code clean up from static analysis

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update code to be compatible with 3.1.0

Update dependencies version
Update Copyright
Other minor changes for new static analysis validations.
Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Requested PR changes

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/JDBCBridgeHandler.java

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/DatabaseBridgeHandler.java

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Apply suggestions from code review

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Suggestions from code review

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update parent version

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/thing-types.xml

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/thing-types.xml

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/thing-types.xml

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/jdbc-bridge.xml

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Update bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/thing-types.xml

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* Changes asked in PR review

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Update bundles/org.openhab.binding.dbquery/README.md

Co-authored-by: Matthew Skinner <matt@pcmus.com>
* README documentation imporovements

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
* Fix format issue

Signed-off-by: Joan Pujol <joanpujol@gmail.com>
Co-authored-by: Matthew Skinner <matt@pcmus.com>
49 files changed:
CODEOWNERS
bom/openhab-addons/pom.xml
bundles/org.openhab.binding.dbquery/README.md [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/pom.xml [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/feature/feature.xml [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/action/ActionQueryResult.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/action/DBQueryActions.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/action/IDBQueryActions.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/ChannelStateUpdater.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/ChannelsToUpdateQueryResult.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/DBQueryBindingConstants.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/DBQueryHandlerFactory.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/DatabaseBridgeHandler.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/InfluxDB2BridgeHandler.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/JDBCBridgeHandler.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/QueryExecution.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/QueryHandler.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/QueryResultChannelUpdater.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/Value2StateConverter.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/config/InfluxDB2BridgeConfiguration.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/config/QueryConfiguration.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/StringSubstitutionParamsParser.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/Influx2Database.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/Influx2QueryFactory.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/Influx2QueryResultExtractor.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/InfluxDBClientFacade.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/InfluxDBClientFacadeImpl.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/DBQueryJSONEncoder.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/Database.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/ExecuteNonConfiguredQuery.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/Query.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/QueryFactory.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/QueryParameters.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/QueryResult.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/QueryResultExtractor.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/ResultRow.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/domain/ResultValue.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/error/DatabaseException.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/java/org/openhab/binding/dbquery/internal/error/UnnexpectedCondition.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/binding/binding.xml [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/influx2-bridge.xml [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/main/resources/OH-INF/thing/thing-types.xml [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/Influx2QueryResultExtractorTest.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/Value2StateConverterTest.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/dbimpl/StringSubstitutionParamsParserTest.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/Influx2DatabaseTest.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/dbimpl/influx2/InfluxDBClientFacadeMock.java [new file with mode: 0644]
bundles/org.openhab.binding.dbquery/src/test/java/org/openhab/binding/dbquery/internal/domain/QueryResultJSONEncoderTest.java [new file with mode: 0644]
bundles/pom.xml