使用指导

前提条件

数据库状态正常、连接正常。

使用方法示例

以tpcc数据库为例：

  1. gs_dbmind component sql_rewriter 5030 tpcc queries.sql --db-host 127.0.0.1 --db-user myname --schema public

queries.sql为需要改写的SQL，内容如下:

  1. select cfg_name from bmsql_config group by cfg_name having cfg_name='1';
  2. delete from bmsql_config;
  3. delete from bmsql_config where cfg_name='1';

结果为多个改写后的查询语句，显示在屏幕（无法改写的语句，显示为空），如下：

  1. +--------------------------------------------------------------------------+------------------------------+
  2. | Raw SQL                                                                  | Rewritten SQL                |
  3. +--------------------------------------------------------------------------+------------------------------+
  4. | select cfg_name from bmsql_config group by cfg_name having cfg_name='1'; | SELECT cfg_name              |
  5. |                                                                          | FROM bmsql_config            |
  6. |                                                                          | WHERE cfg_name = '1';        |
  7. | delete from bmsql_config;                                                | TRUNCATE TABLE bmsql_config; |
  8. | delete from bmsql_config where cfg_name='1';                             |                              |
  9. +--------------------------------------------------------------------------+------------------------------+