Missing features of integration test framework

[waynexia]

List

• Interceptor
  • [ ] support ignore interceptor #107
  • [ ] support echo interceptor
  • [ ] able to handle random things https://github.com/CeresDB/ceresdb/issues/114#issuecomment-1218949297
• UI
  • [ ] can only run specified cases
  • [ ] redirect server's log to the specified place
  • [ ] Keep original SQL indents
• Runner
  • [ ] customizable config file in dir level (e.g. tests/cases/config.toml and tests/cases/01_dummy/config.toml)

Additional context

[jiacai2050]

List below are features I want to have:

• Able to set config file
• Keep original SQL indents. This is what looks like now:

input

CREATE TABLE `03_dml_select_order_table1` (
    `timestamp` timestamp NOT NULL,
    `value` int,
    timestamp KEY (timestamp)) ENGINE=Analytic
WITH(
	 enable_ttl='false'
);

output

CREATE TABLE `03_dml_select_order_table1` (    `timestamp` timestamp NOT NULL,    `value` int,    timestamp KEY (timestamp)) ENGINE=AnalyticWITH(	 enable_ttl='false');

affected_rows: 0

[waynexia]

List below are features I want to have:

Updated to the description 👍

[jiacai2050]

• /cases/local/07_optimizer/optimizer.sql This testcase contains a random result, so we need a interceptor which can replace text before do equality check

[jiacai2050]

This test framework is migrated to https://github.com/CeresDB/sqlness, and this issue is kinds of stale, so close it.

New issues can be created in new repo.