/
NikolayIvkin
/
sqlancer2
Обзор
Документация
Войти
/
NikolayIvkin
/
sqlancer2
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/sqlancer/mysql/gen/tblmaintenance/MySQLOptimize.java
40 строк
1 KB
Manuel Rigger
Fix JavaDoc issues
21 янв 2021, 01:47
21 янв 2021, 01:47
e118824
Код
Авторство
О чём код?
package sqlancer.mysql.gen.tblmaintenance; import java.util.List; import java.util.stream.Collectors; import sqlancer.Randomly; import sqlancer.common.query.SQLQueryAdapter; import sqlancer.mysql.MySQLGlobalState; import sqlancer.mysql.MySQLSchema.MySQLTable; /** * @see <a href="https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html">OPTIMIZE TABLE Statement</a> */ public class MySQLOptimize { private final List<MySQLTable> tables; private final StringBuilder sb = new StringBuilder(); public MySQLOptimize(List<MySQLTable> tables) { this.tables = tables; } public static SQLQueryAdapter optimize(MySQLGlobalState globalState) { return new MySQLOptimize(globalState.getSchema().getDatabaseTablesRandomSubsetNotEmpty()).optimize(); } // OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] // TABLE tbl_name [, tbl_name] ... private SQLQueryAdapter optimize() { sb.append("OPTIMIZE"); if (Randomly.getBoolean()) { sb.append(" "); sb.append(Randomly.fromOptions("NO_WRITE_TO_BINLOG", "LOCAL")); } sb.append(" TABLE "); sb.append(tables.stream().map(t -> t.getName()).collect(Collectors.joining(", "))); return new SQLQueryAdapter(sb.toString()); } }