@Override public String toString() { String sql = "DROP " + type + " " + (ifExists ? "IF EXISTS " : "") + name.toString(); if (parameters != null && !parameters.isEmpty()) { sql += " " + PlainSelect.getStringList(parameters); } return sql; } }
b.append(" "); for (Table t : tables) { b.append(t.toString());
b.append(" USING "); if (usingTable != null) { b.append(usingTable.toString()); } else if (usingSelect != null) { b.append("(").append(usingSelect.toString()).append(")");
sql.append(" INTO "); for (Iterator<Table> iter = intoTables.iterator(); iter.hasNext();) { sql.append(iter.next().toString()); if (iter.hasNext()) { sql.append(", ");
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()); } }
buffer.append(insert.getTable().toString());
@Override public String toString() { String sql = "DROP " + type + " " + (ifExists ? "IF EXISTS " : "") + name.toString(); if (parameters != null && !parameters.isEmpty()) { sql += " " + PlainSelect.getStringList(parameters); } return sql; } }
public static List<String> name_update_table(String sql) throws JSQLParserException { net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql); Update updateStatement = (Update) statement; List<Table> update_table = updateStatement.getTables(); List<String> str_table = new ArrayList<>(); if (update_table != null) { for (int i = 0; i < update_table.size(); i++) { str_table.add(update_table.get(i).toString()); } } return str_table; }
public static List<String> name_delete_table(String sql) throws JSQLParserException { net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql); Delete updateStatement = (Delete) statement; Table update_table = updateStatement.getTable(); List<String> str_table = new ArrayList<>(); if (update_table != null) { str_table.add(update_table.toString()); } return str_table; }
b.append(" "); for (Table t : tables) { b.append(t.toString());
b.append(" USING "); if (usingTable != null) { b.append(usingTable.toString()); } else if (usingSelect != null) { b.append("(").append(usingSelect.toString()).append(")");
sql.append(" INTO "); for (Iterator<Table> iter = intoTables.iterator(); iter.hasNext();) { sql.append(iter.next().toString()); if (iter.hasNext()) { sql.append(", ");
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()); } }
buffer.append(insert.getTable().toString());
public Builder setJSqlParser(CCJSqlParser jSqlParser) throws com.github.vincentrussell.query.mongodb.sql.converter.ParseException, ParseException { final Statement statement = jSqlParser.Statement(); if (Select.class.isAssignableFrom(statement.getClass())) { sqlCommandType = SQLCommandType.SELECT; final PlainSelect plainSelect = (PlainSelect)(((Select)statement).getSelectBody()); SqlUtils.isTrue(plainSelect != null, "could not parseNaturalLanguageDate SELECT statement from query"); SqlUtils.isTrue(plainSelect.getFromItem()!=null,"could not find table to query. Only one simple table name is supported."); whereClause = plainSelect.getWhere(); isDistinct = (plainSelect.getDistinct() != null); isCountAll = SqlUtils.isCountAll(plainSelect.getSelectItems()); SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query. Only one simple table name is supported."); table = plainSelect.getFromItem().toString(); limit = SqlUtils.getLimit(plainSelect.getLimit()); orderByElements1 = plainSelect.getOrderByElements(); selectItems = plainSelect.getSelectItems(); joins = plainSelect.getJoins(); groupBys = SqlUtils.getGroupByColumnReferences(plainSelect); SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query. Only one simple table name is supported."); } else if (Delete.class.isAssignableFrom(statement.getClass())) { sqlCommandType = SQLCommandType.DELETE; Delete delete = (Delete)statement; SqlUtils.isTrue(delete.getTables().size() == 0, "there should only be on table specified for deletes"); table = delete.getTable().toString(); whereClause = delete.getWhere(); } return this; }