GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing github.com — feat(DQE): Add Extensibility to DQE (#1272) · sqlancer/sqlancer@8eb5af4

File tree

Expand file treeCollapse file tree

Open diff view settings

Filter options

src/sqlancer
- common/oracle
  - DQEBase.java
- mysql/oracle
  - MySQLDQEOracle.java

Expand file treeCollapse file tree

Open diff view settings

Collapse file

`‎src/sqlancer/common/oracle/DQEBase.java‎`

Copy file name to clipboardExpand all lines: src/sqlancer/common/oracle/DQEBase.java

+7-11Lines changed: 7 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@`
`13`	`13`	`import sqlancer.common.query.SQLQueryAdapter;`
`14`	`14`	`import sqlancer.common.query.SQLQueryError;`
`15`	`15`	`import sqlancer.common.schema.AbstractRelationalTable;`
`16`		`-import sqlancer.mysql.MySQLSchema.MySQLTables;`
	`16`	`+import sqlancer.common.schema.AbstractTables;`
`17`	`17`
`18`	`18`	`/*`
`19`	`19`	`* In DBMSs, SELECT, UPDATE and DELETE queries utilize predicates (i.e., WHERE clauses) to specify which rows to retrieve, update or delete, respectively.`
`@@ -54,19 +54,15 @@ public DQEBase(S state) {`
`54`	`54`	`this.options = state.getOptions();`
`55`	`55`	`}`
`56`	`56`
`57`		`- public abstract String generateSelectStatement(MySQLTables tables, String tableName, String whereClauseStr);`
	`57`	`+ public abstract String generateSelectStatement(AbstractTables<?, ?> tables, String tableName,`
	`58`	`+ String whereClauseStr);`
`58`	`59`
`59`		`- public abstract String generateUpdateStatement(MySQLTables tables, String tableName, String whereClauseStr);`
	`60`	`+ public abstract String generateUpdateStatement(AbstractTables<?, ?> tables, String tableName,`
	`61`	`+ String whereClauseStr);`
`60`	`62`
`61`		`- public abstract String generateDeleteStatement(MySQLTables tables, String tableName, String whereClauseStr);`
	`63`	`+ public abstract String generateDeleteStatement(String tableName, String whereClauseStr);`
`62`	`64`
`63`		`- /**`
`64`		`- * Add auxiliary columns to the database A abstract method, subclasses need to implement it.`
`65`		`- *`
`66`		`- * @param table`
`67`		`- *`
`68`		`- * @throws SQLException`
`69`		`- */`
	`65`	`+ // Add auxiliary columns to the database A abstract method, subclasses need to implement it.`
`70`	`66`	`public abstract void addAuxiliaryColumns(AbstractRelationalTable<?, ?, ?> table) throws SQLException;`
`71`	`67`
`72`	`68`	`public void dropAuxiliaryColumns(AbstractRelationalTable<?, ?, ?> table) throws SQLException {`

Collapse file

`‎src/sqlancer/mysql/oracle/MySQLDQEOracle.java‎`

Copy file name to clipboardExpand all lines: src/sqlancer/mysql/oracle/MySQLDQEOracle.java

+10-7Lines changed: 10 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -22,6 +22,7 @@`
`22`	`22`	`import sqlancer.common.query.SQLancerResultSet;`
`23`	`23`	`import sqlancer.common.schema.AbstractRelationalTable;`
`24`	`24`	`import sqlancer.common.schema.AbstractTable;`
	`25`	`+import sqlancer.common.schema.AbstractTables;`
`25`	`26`	`import sqlancer.mysql.MySQLErrors;`
`26`	`27`	`import sqlancer.mysql.MySQLGlobalState;`
`27`	`28`	`import sqlancer.mysql.MySQLSchema;`
`@@ -57,16 +58,17 @@ public MySQLDQEOracle(MySQLGlobalState state) {`
`57`	`58`	`}`
`58`	`59`
`59`	`60`	`@Override`
`60`		`- public String generateSelectStatement(MySQLTables tables, String tableName, String whereClauseStr) {`
	`61`	`+ public String generateSelectStatement(AbstractTables<?, ?> tables, String tableName, String whereClauseStr) {`
`61`	`62`	`operateOnSingleTable = tables.getTables().size() == 1;`
`62`	`63`	`List<String> selectColumns = new ArrayList<>();`
`63`		`- for (MySQLTable table : tables.getTables()) {`
	`64`	`+ MySQLTables mySQLTables = (MySQLTables) tables;`
	`65`	`+ for (MySQLTable table : mySQLTables.getTables()) {`
`64`	`66`	`selectColumns.add(table.getName() + "." + COLUMN_ROWID);`
`65`	`67`	`}`
`66`	`68`	`if (operateOnSingleTable && Randomly.getBooleanWithSmallProbability()) {`
`67`	`69`	`generateOrderBy = true;`
`68`	`70`	`// generate order by columns`
`69`		`- for (MySQLColumn column : Randomly.nonEmptySubset(tables.getColumns())) {`
	`71`	`+ for (MySQLColumn column : Randomly.nonEmptySubset(mySQLTables.getColumns())) {`
`70`	`72`	`orderColumns.add(column.getFullQualifiedName());`
`71`	`73`	`}`
`72`	`74`
`@@ -88,9 +90,10 @@ public String generateSelectStatement(MySQLTables tables, String tableName, Stri`
`88`	`90`	`}`
`89`	`91`
`90`	`92`	`@Override`
`91`		`- public String generateUpdateStatement(MySQLTables tables, String tableName, String whereClauseStr) {`
	`93`	`+ public String generateUpdateStatement(AbstractTables<?, ?> tables, String tableName, String whereClauseStr) {`
`92`	`94`	`List<String> updateColumns = new ArrayList<>();`
`93`		`- for (MySQLTable table : tables.getTables()) {`
	`95`	`+ MySQLTables mySQLTables = (MySQLTables) tables;`
	`96`	`+ for (MySQLTable table : mySQLTables.getTables()) {`
`94`	`97`	`updateColumns.add(String.format("%s = 1", table.getName() + "." + COLUMN_UPDATED));`
`95`	`98`	`}`
`96`	`99`	`String updateStmt = String.format("UPDATE %s SET %s WHERE %s", tableName, Strings.join(",", updateColumns),`
`@@ -105,7 +108,7 @@ public String generateUpdateStatement(MySQLTables tables, String tableName, Stri`
`105`	`108`	`}`
`106`	`109`
`107`	`110`	`@Override`
`108`		`- public String generateDeleteStatement(MySQLTables tables, String tableName, String whereClauseStr) {`
	`111`	`+ public String generateDeleteStatement(String tableName, String whereClauseStr) {`
`109`	`112`	`String deleteStmt;`
`110`	`113`	`if (operateOnSingleTable) {`
`111`	`114`	`deleteStmt = String.format("DELETE FROM %s WHERE %s", tableName, whereClauseStr);`
`@@ -141,7 +144,7 @@ public void check() throws SQLException {`
`141`	`144`
`142`	`145`	`String updateStmt = generateUpdateStatement(tables, tableName, whereClauseStr);`
`143`	`146`
`144`		`- String deleteStmt = generateDeleteStatement(tables, tableName, whereClauseStr);`
	`147`	`+ String deleteStmt = generateDeleteStatement(tableName, whereClauseStr);`
`145`	`148`
`146`	`149`	`for (MySQLTable table : tables.getTables()) {`
`147`	`150`	`addAuxiliaryColumns(table);`

0 commit comments

Comments

0 (0)

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.