sqlsimx

Documentation

Index

• Variables
• func SqlSimX(opt string, inputDMLPath string, inputDDLPath string, outputPath string, ...)

Variables

var SimDMLFuncs = []func(sql string, result *connector.Result, conn *connector.Connector) (string, error){
	rmBinOp01,
	rmFields,
}

do not adjust the order!

Functions

func SqlSimX

func SqlSimX(opt string, inputDMLPath string, inputDDLPath string, outputPath string,
	host string, port int, username string, password string, dbname string, specDmlFunc string)

SqlSimX: more powerful, flexible sql simplification tool.

You can only provide one sql statement in `inputDMLPath`!

If you use `dml`, we will try to remove each node in your sql statement, simplify if the result does not change.
If you use `ddl`, we will remove unused tables, columns (only consider `CREATE TABLE` and `INSERT INTO VALUES`, may error).

Then write the simplified sql to `outputPath`.