public Column(List<String> nameParts) { this(nameParts.size() > 1 ? new Table(nameParts.subList(0, nameParts.size() - 1)) : null, nameParts.get(nameParts.size() - 1)); }
final public Table Table() throws ParseException { Table table = null; String name1 = null; String name2 = null; if (jj_2_4(3)) { name1 = RelObjectName(); jj_consume_token(81); name2 = RelObjectName(); table = new Table(name1, name2); } else { switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case S_IDENTIFIER: case S_QUOTED_IDENTIFIER: name1 = RelObjectName(); table = new Table(null, name1); break; default: jj_la1[21] = jj_gen; jj_consume_token(-1); throw new ParseException(); } } {if (true) return table;} throw new Error("Missing return statement in function"); }
jjtc000 = false; jjtn000.jjtSetLastToken(getToken(0)); Table table = new Table(data); return table; } catch (Throwable jjte000) {
final Table qualifiedTable = new Table(); final String databaseName; final String userName;
public Column(List<String> nameParts) { this(nameParts.size() > 1 ? new Table(nameParts.subList(0, nameParts.size() - 1)) : null, nameParts.get(nameParts.size() - 1)); }
/** * Add new entries to the table name map. * * @param originalName a table name that should be replaced * @param newName the value that originalName should be replaced with */ public void put(String originalName, String newName) { Table t = new Table(); String[] parts = newName.split("[.]"); if (parts.length == 1) { t.setName(parts[0]); } else if (parts.length == 2) { t.setSchemaName(parts[0]); t.setName(parts[1]); } else if (parts.length == 3) { t.setSchemaName(parts[0] + "." + parts[1]); t.setName(parts[2]); } else throw new IllegalArgumentException("expected new table name to have 1-3 parts, found " + parts.length); map.put(originalName, t); }
/** * Add new entries to the table name map. * * @param originalName a table name that should be replaced * @param newName the value that originalName should be replaced with */ public void put(String originalName, String newName) { Table t = new Table(); String[] parts = newName.split("[.]"); if (parts.length == 1) { t.setName(parts[0]); } else if (parts.length == 2) { t.setSchemaName(parts[0]); t.setName(parts[1]); } else if (parts.length == 3) { t.setSchemaName(parts[0] + "." + parts[1]); t.setName(parts[2]); } else throw new IllegalArgumentException("expected new table name to have 1-3 parts, found " + parts.length); map.put(originalName, t); }
/** * Return a SelectExpressionItem for a given Table and columnName * * @param table * @param columnName * @return */ private static SelectExpressionItem newSelectExpressionItem(Table table, String columnName) { Table siTable; String alias = table.getAlias(); if (alias != null && !alias.isEmpty()) siTable = new Table(null, alias); else siTable = table; Column column = new Column(siTable, columnName); SelectExpressionItem sei = new SelectExpressionItem(); sei.setExpression(column); return sei; }
final public Table Table() throws ParseException {Table table = null; String name1 = null; String name2 = null; if (jj_2_4(3)) { name1 = RelObjectName(); jj_consume_token(81); name2 = RelObjectName(); table = new Table(name1, name2); } else { switch ((jj_ntk==-1)?jj_ntk_f():jj_ntk) { case S_IDENTIFIER: case S_QUOTED_IDENTIFIER:{ name1 = RelObjectName(); table = new Table(null, name1); break; } default: jj_la1[21] = jj_gen; jj_consume_token(-1); throw new ParseException(); } } {if ("" != null) return table;} throw new Error("Missing return statement in function"); }
@Override public void visit(Column column) { net.sf.jsqlparser.schema.Table table = column.getTable(); if (table == null) { table = new net.sf.jsqlparser.schema.Table(mainAlias); column.setTable(table); } else { if (StringUtils.isBlank(table.getName())) { table.setName(mainAlias); } } } });
final Table qualifiedTable = new Table(); final String databaseName; final String userName;
@Override public void visit(Column column) { Table table = column.getTable(); if (table == null || StringUtils.isBlank(table.getName())) { Table t = new Table(tableName); if (tableAlias != null) { t.setAlias(new Alias(tableAlias, false)); } column.setTable(t); } } });
public Select createSelect(JdbcIngestionInfo ingestionInfo) throws JSQLParserException { Select select; if (ingestionInfo.getDataType() == JdbcIngestionInfo.DataType.TABLE) { String database = ingestionInfo.getDatabase(); String table = ingestionInfo.getQuery(); String tableName = (!table.contains(".") && database != null) ? database + "." + table : table; select = SelectUtils.buildSelectFromTable(new Table(tableName)); } else { net.sf.jsqlparser.statement.Statement parsedStmt = CCJSqlParserUtil.parse(ingestionInfo.getQuery()); if (!(parsedStmt instanceof Select)) { throw new JSQLParserException("query is not select"); } select = (Select) parsedStmt; } return select; }
/** * creates a query of the form SELECT * FROM viewName */ static ParsedSQLQuery createParsedSqlForGeneratedView(QuotedIDFactory idfac, RelationID viewId) { PlainSelect body = new PlainSelect(); List<SelectItem> list = new ArrayList<>(1); list.add(new AllColumns()); body.setSelectItems(list); // create SELECT * Table viewTable = new Table(viewId.getSchemaSQLRendering(), viewId.getTableNameSQLRendering()); body.setFromItem(viewTable); // create FROM viewTable Select select = new Select(); select.setSelectBody(body); ParsedSQLQuery queryParsed = null; try { queryParsed = new ParsedSQLQuery(select, false, idfac); } catch (JSQLParserException e) { if (e.getCause() instanceof ParseException) log.warn("Parse exception, check no SQL reserved keywords have been used "+ e.getCause().getMessage()); } return queryParsed; }
jj_consume_token(DOT); name2 = RelObjectName(); table = new Table(name1, name2); if (token.specialToken != null) { table.setComment(token.specialToken.image); case S_QUOTED_IDENTIFIER:{ name1 = RelObjectName(); table = new Table(null, name1); if (token.specialToken != null) { table.setComment(token.specialToken.image);
@Override public void visit(Table table) { //obtain the column names from the metadata RelationID tableID = idfac.createRelationID(table.getSchemaName(), table.getName()); RelationDefinition tableDefinition = metadata.getRelation(tableID); if (tableDefinition == null) throw new RuntimeException("Definition not found for table '" + table + "'."); Table tableName; if (aliasSubselect != null) tableName = new Table(aliasSubselect); else if (table.getAlias() != null) //use the alias if present tableName = new Table(table.getAlias().getName()); else tableName = table; for (Attribute att : tableDefinition.getAttributes()) { // ROMAN (9 Oct 2015) // the unquoted name is used for comparisons Column columnNameUnquoted = new Column(tableName, att.getID().getSQLRendering()); if (variables.contains(columnNameUnquoted.getFullyQualifiedName(), att.getID().getName())) { // properly quoted name if necessary Column columnName = new Column(tableName, att.getID().getSQLRendering()); columns.add(new SelectExpressionItem(columnName)); } } }
Table table = new Table(data); return table; } catch (Throwable jjte000) {