メニュー
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.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
| 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. |
OneClient.createConfig()
-> TestExecutor.executeTest(tester, config)
-> tester.connect()
-> tester.execute(connection, query)
-> formatQueryResult(queryResult, dbType)
| 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 |
mongodb: Converts MongoDBResult.getDocuments() into a JSON array.redis: Joins getRawResults() with newlines; empty results return a hint.result column from the ResultSet and concatenates.ResultSet: Prints column names + rows (tab-separated).ResultSet: Returns Update count: N.| 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 |
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"
TestExecutor.formatQueryResult().QueryResult interface, update every Tester result wrapper accordingly.Practical guide for adding a new database or middleware engine to DBClient. Use this skill when you need to introduce a new dbType.
Cross-cutting core mechanisms of DBClient: CLI argument parsing, DBConfig, TesterFactory, TestExecutor, and the DatabaseTester interface. Use this skill when modifying generic flows or adding engine registration, validation, or dependencies.
KV / coordination engines in DBClient: Redis, RedisCluster, Redis Sentinel, Camellia-Proxy, Etcd, and Zookeeper. Use this skill when adding, debugging, or modifying such a Tester.
Message-queue engines in DBClient: Kafka, Pulsar, RabbitMQ, and RocketMQ. Use this skill when adding, debugging, or modifying such a Tester.
Relational / JDBC-protocol-compatible engines in DBClient. Covers MySQL-compatible, PostgreSQL-compatible, Oracle, SQLServer, domestic / regulated databases, and analytical databases such as StarRocks, Doris, and ClickHouse. Use this skill when adding, debugging, or modifying such a Tester.
Search / log-retrieval engines in DBClient: Elasticsearch 8.x and OpenSearch. Use this skill when adding, debugging, or modifying such a Tester.