@Override public String toString() { return "DESCRIBE " + table.getFullyQualifiedName(); }
/** * Override to adapt the tableName generation (e.g. with / without schema). * * @param table * @return */ protected String extractTableName(Table table) { return table.getFullyQualifiedName(); }
public void visit(Table tableName) { String tableWholeName = tableName.getFullyQualifiedName(); tables.add(tableWholeName); }
@Override public void visit(AllTableColumns allTableColumns) { buffer.append(allTableColumns.getTable().getFullyQualifiedName()).append(".*"); }
@Override public String toString() { StringBuilder b = new StringBuilder(); b.append("ALTER TABLE ").append(table.getFullyQualifiedName()).append(" "); Iterator<AlterExpression> altIter = alterExpressions.iterator(); while (altIter.hasNext()) { b.append(altIter.next().toString()); // Need to append whitespace after each ADD or DROP statement // but not the last one if (altIter.hasNext()) { b.append(", "); } } return b.toString(); }
@Override public String toString() { return getFullyQualifiedName() + ((alias != null) ? alias.toString() : "") + ((pivot != null) ? " " + pivot : "") + ((hint != null) ? hint.toString() : ""); } }
@Override public String toString() { StringBuilder buffer = new StringBuilder(); buffer.append("CREATE "); if (index.getType() != null) { buffer.append(index.getType()); buffer.append(" "); } buffer.append("INDEX "); buffer.append(index.getName()); buffer.append(" ON "); buffer.append(table.getFullyQualifiedName()); if (index.getColumnsNames() != null) { buffer.append(" ("); for (Iterator iter = index.getColumnsNames().iterator(); iter.hasNext();) { String columnName = (String) iter.next(); buffer.append(columnName); if (iter.hasNext()) { buffer.append(", "); } } buffer.append(")"); } return buffer.toString(); }
/** * Get name with out without using aliases. * * @param aliases * @return */ public String getName(boolean aliases) { StringBuilder fqn = new StringBuilder(); if (table != null) { if (table.getAlias() != null && aliases) { fqn.append(table.getAlias().getName()); } else { fqn.append(table.getFullyQualifiedName()); } } if (fqn.length() > 0) { fqn.append('.'); } if (columnName != null) { fqn.append(columnName); } return fqn.toString(); }
public void deParse(CreateIndex createIndex) { Index index = createIndex.getIndex(); buffer.append("CREATE "); if (index.getType() != null) { buffer.append(index.getType()); buffer.append(" "); } buffer.append("INDEX "); buffer.append(index.getName()); buffer.append(" ON "); buffer.append(createIndex.getTable().getFullyQualifiedName()); if (index.getColumnsNames() != null) { buffer.append(" ("); for (Iterator iter = index.getColumnsNames().iterator(); iter.hasNext();) { String columnName = (String) iter.next(); buffer.append(columnName); if (iter.hasNext()) { buffer.append(", "); } } buffer.append(")"); } }
public void deParse(AlterView alterView) { if(alterView.isUseReplace()){ buffer.append("REPLACE "); }else{ buffer.append("ALTER "); } buffer.append("VIEW ").append(alterView.getView().getFullyQualifiedName()); if (alterView.getColumnNames() != null) { buffer.append(PlainSelect.getStringList(alterView.getColumnNames(), true, true)); } buffer.append(" AS "); alterView.getSelectBody().accept(selectVisitor); }
@Override public void visit(Table tableName) { buffer.append(tableName.getFullyQualifiedName()); Alias alias = tableName.getAlias(); if (alias != null) { buffer.append(alias); } Pivot pivot = tableName.getPivot(); if (pivot != null) { pivot.accept(this); } MySQLIndexHint indexHint = tableName.getIndexHint(); if (indexHint != null) { buffer.append(indexHint); } }
@Override public void visit(Column tableColumn) { final Table table = tableColumn.getTable(); String tableName = null; if (table != null) { if (table.getAlias() != null) { tableName = table.getAlias().getName(); } else { tableName = table.getFullyQualifiedName(); } } if (tableName != null && !tableName.isEmpty()) { buffer.append(tableName).append("."); } buffer.append(tableColumn.getColumnName()); }
buffer.append("IF NOT EXISTS "); buffer.append(createTable.getTable().getFullyQualifiedName()); if (createTable.getSelect() != null) { buffer.append(" AS ");
buffer.append("INTO "); buffer.append(replace.getTable().getFullyQualifiedName()); if (replace.getItemsList() != null) { if (replace.getColumns() != null) {
buffer.append("MATERIALIZED "); buffer.append("VIEW ").append(createView.getView().getFullyQualifiedName()); if (createView.getColumnNames() != null) { buffer.append(PlainSelect.getStringList(createView.getColumnNames(), true, true));
public void deParse(Delete delete) { buffer.append("DELETE"); if (delete.getTables() != null && delete.getTables().size() > 0) { for (Table table : delete.getTables()) { buffer.append(" ").append(table.getFullyQualifiedName()); } } buffer.append(" FROM ").append(delete.getTable().toString()); if (delete.getJoins() != null) { for (Join join : delete.getJoins()) { if (join.isSimple()) { buffer.append(", ").append(join); } else { buffer.append(" ").append(join); } } } if (delete.getWhere() != null) { buffer.append(" WHERE "); delete.getWhere().accept(expressionVisitor); } if (delete.getOrderByElements() != null) { new OrderByDeParser(expressionVisitor, buffer).deParse(delete.getOrderByElements()); } if (delete.getLimit() != null) { new LimitDeparser(buffer).deParse(delete.getLimit()); } }
public void deParse(Upsert upsert) { buffer.append("UPSERT INTO "); buffer.append(upsert.getTable().getFullyQualifiedName()); if (upsert.getColumns() != null) { appendColumns(upsert); } if (upsert.getItemsList() != null) { upsert.getItemsList().accept(this); } if (upsert.getSelect() != null) { appendSelect(upsert); } if (upsert.isUseDuplicate()) { appendDuplicate(upsert); } }
/** * Override to adapt the tableName generation (e.g. with / without schema). * * @param table * @return */ protected String extractTableName(Table table) { return table.getFullyQualifiedName(); }
@Override public void visit(Table table) { if (!withTCEs.contains(table.getFullyQualifiedName().toLowerCase())) { RelationID relationId = idfac.createRelationID(table.getSchemaName(), table.getName()); relations.add(relationId); } }
@Override public void visit(Table table) { if (!withTCEs.contains(table.getFullyQualifiedName().toLowerCase())) { RelationID relationId = idfac.createRelationID(table.getSchemaName(), table.getName()); relations.add(relationId); } }