메뉴
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 직업 분류 기준
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.
| 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.