} else if (lexer.token == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); item.setCascade(true); lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); item.setCascade(true); lexer.nextToken();
@Override protected void accept0(SQLASTVisitor visitor) { if (visitor.visit(this)) { acceptChild(visitor, columns); } visitor.endVisit(this); }
@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; }
} else if (lexer.token() == Token.LPAREN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); accept(Token.RPAREN); } else if (lexer.token() == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); } else if (lexer.token() == Token.PARTITION) {
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; }
} else if (lexer.token() == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); item.addColumn(name); stmt.addItem(dropPartition); } else if (lexer.token() == Token.IDENTIFIER) { SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); item.addColumn(name); stmt.addItem(item);
lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); item.setColumnName(this.exprParser.name()); stmt.getItems().add(item);
SQLName columnName = dropColumn.getColumnName(); String cname = parseName(columnName); if (field == null) { throw new UnsupportedException("Unsupported Do not find this column " + SQLUtils.toSQLString(((SQLAlterTableDropColumnItem) item).getColumnName()));
} else if (lexer.token() == Token.LPAREN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); accept(Token.RPAREN); } else if (lexer.token() == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); stmt.addItem(item); } else if (lexer.token() == Token.PARTITION) {
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; }
} else if (lexer.token() == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); item.addColumn(name); stmt.addItem(dropPartition); } else if (lexer.token() == Token.IDENTIFIER) { SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); item.addColumn(name); stmt.addItem(item);
} else if (lexer.token == Token.COLUMN) { lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); item.setCascade(true); lexer.nextToken(); SQLAlterTableDropColumnItem item = new SQLAlterTableDropColumnItem(); this.exprParser.names(item.getColumns()); item.setCascade(true); lexer.nextToken();
@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 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); } }
@Override protected void accept0(SQLASTVisitor visitor) { if (visitor.visit(this)) { acceptChild(visitor, columns); } visitor.endVisit(this); }
@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; }
} else if (alterItem instanceof SQLAlterTableDropColumnItem) { SQLAlterTableDropColumnItem dropColumn = (SQLAlterTableDropColumnItem) alterItem; for (SQLName dropName : dropColumn.getColumns()) { System.out.println(sql + ":dropName:\n" + dropName.getClass().toString() + "\n");
@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; }
columnList.add(((MySqlAlterTableModifyColumn) alterItem).getNewColumnDefinition().getName()); } else if (alterItem instanceof SQLAlterTableDropColumnItem) { columnList = ((SQLAlterTableDropColumnItem) alterItem).getColumns();