@Override public boolean visit(SQLAlterTableDropColumnItem x) { for (int i = 0; i < x.getColumns().size(); ++i) { if (i != 0) { print0(", "); } SQLName columnn = x.getColumns().get(i); print0(ucase ? "DROP COLUMN " : "drop column "); columnn.accept(this); if (x.isCascade()) { print0(ucase ? " CASCADE" : " cascade"); } } return false; }
private boolean apply(SQLAlterTableDropColumnItem item) { for (SQLName column : item.getColumns()) { String columnName = column.getSimpleName(); for (int i = tableElementList.size() - 1; i >= 0; --i) { SQLTableElement e = tableElementList.get(i); if (e instanceof SQLColumnDefinition) { if (SQLUtils.nameEquals(columnName, ((SQLColumnDefinition) e).getName().getSimpleName())) { tableElementList.remove(i); } } } for (int i = tableElementList.size() - 1; i >= 0; --i) { SQLTableElement e = tableElementList.get(i); if (e instanceof SQLUnique) { SQLUnique unique = (SQLUnique) e; unique.applyDropColumn(column); if (unique.getColumns().size() == 0) { tableElementList.remove(i); } } else if (e instanceof MySqlTableIndex) { MySqlTableIndex index = (MySqlTableIndex) e; index.applyDropColumn(column); if (index.getColumns().size() == 0) { tableElementList.remove(i); } } } } return true; }
@Override public boolean visit(SQLAlterTableDropColumnItem x) { print0(ucase ? "DROP COLUMN " : "drop column "); this.printAndAccept(x.getColumns(), ", "); if (x.isCascade()) { print0(ucase ? " CASCADE" : " cascade"); } return false; }
lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); accept(Token.RPAREN); lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); } else if (lexer.token() == Token.PARTITION) {
lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); } else if (lexer.token == Token.LITERAL_ALIAS) { SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns());
@Override public boolean visit(SQLAlterTableDropColumnItem x) { for (int i = 0; i < x.getColumns().size(); ++i) { if (i != 0) { print0(", "); } SQLName columnn = x.getColumns().get(i); print0(ucase ? "DROP COLUMN " : "drop column "); columnn.accept(this); if (x.isCascade()) { print0(ucase ? " CASCADE" : " cascade"); } } return false; }
private boolean apply(SQLAlterTableDropColumnItem item) { for (SQLName column : item.getColumns()) { String columnName = column.getSimpleName(); for (int i = tableElementList.size() - 1; i >= 0; --i) { SQLTableElement e = tableElementList.get(i); if (e instanceof SQLColumnDefinition) { if (SQLUtils.nameEquals(columnName, ((SQLColumnDefinition) e).getName().getSimpleName())) { tableElementList.remove(i); } } } for (int i = tableElementList.size() - 1; i >= 0; --i) { SQLTableElement e = tableElementList.get(i); if (e instanceof SQLUnique) { SQLUnique unique = (SQLUnique) e; unique.applyDropColumn(column); if (unique.getColumns().size() == 0) { tableElementList.remove(i); } } else if (e instanceof MySqlTableIndex) { MySqlTableIndex index = (MySqlTableIndex) e; index.applyDropColumn(column); if (index.getColumns().size() == 0) { tableElementList.remove(i); } } } } return true; }
@Override public boolean visit(SQLAlterTableDropColumnItem x) { print0(ucase ? "DROP COLUMN " : "drop column "); this.printAndAccept(x.getColumns(), ", "); if (x.isCascade()) { print0(ucase ? " CASCADE" : " cascade"); } return false; }
lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); } else if (lexer.token == Token.LITERAL_ALIAS) { SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns());
lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); accept(Token.RPAREN); lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); } else if (lexer.token() == Token.PARTITION) {
private void dropColumn(List<String> cols, SQLAlterTableDropColumnItem dropColumn, List<SQLAlterTableItem> newAlterItems) { for (SQLName dropName : dropColumn.getColumns()) { String dropColName = StringUtil.removeBackQuote(dropName.getSimpleName()); if (dropColName.equalsIgnoreCase(GlobalTableUtil.GLOBAL_TABLE_CHECK_COLUMN)) { continue; } removeOldCol(cols, dropColName); newAlterItems.add(dropColumn); } }
} else if (alterItem instanceof SQLAlterTableDropColumnItem) { SQLAlterTableDropColumnItem dropColumn = (SQLAlterTableDropColumnItem) alterItem; for (SQLName dropName : dropColumn.getColumns()) { System.out.println(sql + ":dropName:\n" + dropName.getClass().toString() + "\n");
columnList.add(((MySqlAlterTableModifyColumn) alterItem).getNewColumnDefinition().getName()); } else if (alterItem instanceof SQLAlterTableDropColumnItem) { columnList = ((SQLAlterTableDropColumnItem) alterItem).getColumns();