| name | dbclient-testmode-query |
| description | Generic logic for DBClient query test mode: DatabaseTester.execute(), QueryResult wrapping, and format branches in TestExecutor.formatQueryResult(). Use this skill when modifying query execution or result output for any engine.
|
DBClient Test Mode: Query
Call Chain
OneClient.createConfig()
-> TestExecutor.executeTest(tester, config)
-> tester.connect()
-> tester.execute(connection, query)
-> formatQueryResult(queryResult, dbType)
Core Files
| File | Responsibility |
|---|
src/main/java/com/apecloud/dbtester/commons/DatabaseTester.java | execute() interface |
src/main/java/com/apecloud/dbtester/commons/QueryResult.java | Unified query result wrapper |
src/main/java/com/apecloud/dbtester/commons/MongoDBResult.java | MongoDB-specific result wrapper |
src/main/java/com/apecloud/dbtester/commons/TestExecutor.java | formatQueryResult() branches |
src/main/java/com/apecloud/dbtester/commons/ResultSetPrinter.java | Table printing helper |
formatQueryResult Branches
mongodb: Converts MongoDBResult.getDocuments() into a JSON array.redis: Joins getRawResults() with newlines; empty results return a hint.- Qdrant: Reads the
result column from the ResultSet and concatenates.
- Generic JDBC
ResultSet: Prints column names + rows (tab-separated).
- No
ResultSet: Returns Update count: N.
Common Issues
| Symptom | Investigation Point |
|---|
| Empty result | Check whether the query matches; Redis explicitly hints key may not exist |
| Misaligned format | ResultSetMetaData.getColumnName(i) and rs.getString(i) use 1-based indexes |
| MongoDB error | Confirm the returned type is MongoDBResult, not a generic QueryResult |
| Qdrant empty result | See the dbType.toLowerCase().equals("qdrant") branch in TestExecutor |
Minimal Example
java -jar build/libs/oneclient-1.0-all.jar \
-h 127.0.0.1 -P 3306 -u root -p password -d test \
-e mysql -t query -q "SELECT 1 AS one"
Maintenance Notes
- When adding an engine that needs special formatting, update
TestExecutor.formatQueryResult().
- When modifying the
QueryResult interface, update every Tester result wrapper accordingly.
