mirror of
https://gitee.com/pnoker/iot-dc3.git
synced 2026-10-31 10:11:49 +08:00
pnoker
46f8243c07
Add the first driver integration test: spins a real PostgreSQL container and verifies the shared JDBC read path returns stored values and that the write path binds the point value as a parameter — a SQL-injection payload is stored verbatim and cannot drop the table, confirming the parameterised-write fix end-to-end. Set the Failsafe classesDirectory so integration tests run against the plain compiled classes instead of the Spring Boot repackaged fat jar.
DC3 Driver PostgreSQL
Overview
dc3-driver-postgresql is the PostgreSQL database driver of the IoT DC3 platform. It connects to a PostgreSQL
database via JDBC, reads point values by executing configured SQL SELECT queries on a schedule, and writes /
executes SQL for write commands. It builds on the shared AbstractJdbcDriverCustomService from dc3-common-sql,
which constructs the JDBC URL jdbc:postgresql://<host>:<port>/<database> using the org.postgresql.Driver.
Module Information
- Group ID: io.github.pnoker
- Artifact ID: dc3-driver-postgresql
- Version: 2026.5.22
- Driver Name: PostgreSQL Driver
Driver Attributes (Device-level)
| Attribute | Code | Type | Default | Description |
|---|---|---|---|---|
| Host | host | STRING | localhost | PostgreSQL host |
| Port | port | INT | 5432 | PostgreSQL port |
| Database | database | STRING | PostgreSQL database name | |
| Username | username | STRING | root | PostgreSQL username |
| Password | password | STRING | PostgreSQL password | |
| Query Timeout | queryTimeout | INT | 30 | SQL query timeout in seconds |
Point Attributes
| Attribute | Code | Type | Description |
|---|---|---|---|
| Read Query | readQuery | STRING | SQL SELECT query for reading point value |
| Write Query | writeQuery | STRING | SQL UPDATE/INSERT using a single ? placeholder for the value (bound as a parameter) |
Command Attributes (write)
| Attribute | Code | Type | Description |
|---|---|---|---|
| Execute Query | executeQuery | STRING | SQL query to execute for command |
Prerequisites
A reachable PostgreSQL database. The connection URL, credentials, and the SQL queries to run are all supplied through the driver and point attributes above — nothing is hardcoded.
Running Locally
1. Start Infrastructure and Center Services
podman compose -f dc3/docker-compose-db.yml up -d
java -jar dc3-center/dc3-center-manager/target/dc3-center-manager.jar
2. Build and Run
mvn -s .mvn/settings.xml clean package
java -jar dc3-driver/dc3-driver-postgresql/target/dc3-driver-postgresql.jar
Related Modules
dc3-common-driver— Driver SDK for registration, scheduling, and RabbitMQ integrationdc3-common-sql—AbstractJdbcDriverCustomServicebase class providing JDBC read/write logic
License
Copyright 2016-present the IoT DC3 original author or authors.
Licensed under the GNU Affero General Public License v3.0 (AGPL 3.0)