Java Delete类代码示例

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
private static Select createSelect(CloudSpannerConnection connection, Delete delete) throws SQLException
{
	TableKeyMetaData table = connection.getTable(CloudSpannerDriver.unquoteIdentifier(delete.getTable().getName()));
	List<String> keyCols = table.getKeyColumns().stream()
			.map(x -> CloudSpannerDriver.quoteIdentifier(delete.getTable().getName()) + "."
					+ CloudSpannerDriver.quoteIdentifier(x))
			.collect(Collectors.toList());
	StringBuilder sql = new StringBuilder();
	sql.append("SELECT ").append(String.join(", ", keyCols));
	sql.append("\nFROM ").append(CloudSpannerDriver.quoteIdentifier(delete.getTable().getName()));
	sql.append("\nWHERE ").append(delete.getWhere().toString());

	try
	{
		return (Select) CCJSqlParserUtil.parse(sql.toString());
	}
	catch (JSQLParserException e)
	{
		throw new CloudSpannerSQLException("Could not parse generated SELECT statement: " + sql,
				Code.INVALID_ARGUMENT);
	}
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
private Mutation createDeleteMutation(Delete delete, boolean generateParameterMetaData) throws SQLException
{
	String table = unquoteIdentifier(delete.getTable().getFullyQualifiedName());
	getParameterStore().setTable(table);
	Expression where = delete.getWhere();
	if (where == null)
	{
		// Delete all
		return Mutation.delete(table, KeySet.all());
	}
	else
	{
		// Delete one
		DeleteKeyBuilder keyBuilder = new DeleteKeyBuilder(getConnection().getTable(table),
				generateParameterMetaData);
		visitDeleteWhereClause(where, keyBuilder, generateParameterMetaData);
		return Mutation.delete(table, keyBuilder.getKeyBuilder().build());
	}
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
public JSQLParserAdapter(String sql, ShardRouter shardRouter, boolean enableLimitCheck) {
    this.sql = sql;
    this.shardRouter = shardRouter;
    this.enableLimitCheck = enableLimitCheck;
    try {
        this.statement = CCJSqlParserUtil.parse(sql);
    } catch (Throwable e) {
        throw new SQLSyntaxErrorException("sql is [" + sql + "]", e);
    }
    if (statement instanceof Select //
        || statement instanceof Update//
        || statement instanceof Insert//
        || statement instanceof Delete) {
        // ok
    } else {
        throw new UnsupportedSQLExpressionException(
                                                    "Sql ["
                                                            + sql
                                                            + "] is not supported in shard sql. Only support 'select' 'insert' 'update' and 'delete' sql statement");
    }
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
/**
 * mysql 'delete' doesn't support alais
 */
@Override
public void visit(Delete delete) {
    if (enableLimitCheck && delete.getLimit() == null) {
        throw new IllegalStateException("no limit in sql: " + sql);
    }
    this.getStack().push(new FrameContext());
    ShardRouteConfig routeConfig = shardRouter.getRouteConfig(delete.getTable().getSchemaName(),
                                                              delete.getTable().getName());
    if (routeConfig != null) {
        TableWrapper tab = new TableWrapper(delete.getTable(), routeConfig);
        delete.setTable(tab);
        addRoutedTableIntoContext(tab, routeConfig, false);
    }
    super.visit(delete);
    afterVisitBaseStatement();
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
public synchronized void visit(Delete del) {
   controlEventMap.put(sql, ControlEvent.DELETE);
   targetMap.put(sql, del.getTable().getName());

   List<SqlParameter> paramList = new ArrayList<SqlParameter>();
   parameterMap.put(sql, paramList);
   List<SqlParameter> updList = new ArrayList<SqlParameter>();
   insUpdColumnsMap.put(sql, updList);

   parseWhere(del.getWhere(), 0);
   if (primaryKeys.get(sql) == null) {
      // no unique primary key condition. Not controlled
      controlEventMap.put(sql, null);
      emptyPrimaryKey(SqlParameterType.WHERE_PARAMETER);
   }
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
public Set<String> parse(Delete delete) {
	
	Set<String> tableSet = new HashSet<String>();
	
	if (delete != null) {
		Table table = delete.getTable();
		if (table != null) {
			tableSet.add(table.getName());
		}
		
		Expression expression = delete.getWhere();
		if (expression != null) {
			tableSet.addAll(parseExpression(expression));
		}
	}
	return tableSet;
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
protected Statement parseVerifyQuery(Delete delete) {
    // We verify delete so that we can revoke all deleted serial numbers
    Table table = delete.getTable();

    // Get all columns, because we are deleting the entire row
    Select select = SelectUtils.buildSelectFromTableAndSelectItems(table, new AllColumns());

    // Apply the where clause to the SELECT
    PlainSelect plainSelect = (PlainSelect) select.getSelectBody();
    plainSelect.setWhere(delete.getWhere());

    plainSelect.setLimit(delete.getLimit());
    plainSelect.setOrderByElements(delete.getOrderByElements());

    return select;
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
protected Statement parseVerifyQuery(Delete delete) {
    // We verify delete so that we can revoke all deleted serial numbers
    Table table = delete.getTable();

    Select select = SelectUtils.buildSelectFromTableAndSelectItems(table, new AllColumns());

    // Apply the where clause to the SELECT
    PlainSelect plainSelect = (PlainSelect) select.getSelectBody();
    plainSelect.setWhere(delete.getWhere());

    plainSelect.setLimit(delete.getLimit());
    plainSelect.setOrderByElements(delete.getOrderByElements());

    return select;
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
public void checkParseAndDeparse(String statementText) throws JSQLParserException {
    Statement statement = parserManager.parse(new StringReader(statementText));
    assertNotNull(statement);
    StringBuilder buffer = new StringBuilder();
    StatementDeParser deparser = new StatementDeParser(buffer);
    if (statement instanceof Select) {
        deparser.visit((Select) statement);
    } else if (statement instanceof Delete) {
        deparser.visit((Delete) statement);
    } else if (statement instanceof Insert) {
        deparser.visit((Insert) statement);
    } else {
        throw new JSQLParserException("Unknown type of parsed statement");
    }
    assertEquals(buffer.toString().toLowerCase().replaceAll(ExpressionDeParser.LINE_SEPARATOR, ""), statementText.toLowerCase().replaceAll(ExpressionDeParser.LINE_SEPARATOR, ""));
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
public CloudSpannerParameterMetaData getParameterMetaData() throws SQLException
{
	// parse the SQL statement without executing it
	try
	{
		if (isDDLStatement())
		{
			throw new CloudSpannerSQLException("Cannot get parameter meta data for DDL statement",
					Code.INVALID_ARGUMENT);
		}
		Statement statement = CCJSqlParserUtil.parse(sanitizeSQL(sql));
		if (statement instanceof Insert || statement instanceof Update || statement instanceof Delete)
		{
			// Create mutation, but don't do anything with it. This
			// initializes column names of the parameter store.
			createMutations(sql, false, true);
		}
		else if (statement instanceof Select)
		{
			// Create select builder, but don't do anything with it. This
			// initializes column names of the parameter store.
			createSelectBuilder(statement, sql);
		}
	}
	catch (JSQLParserException | TokenMgrError e)
	{
		throw new CloudSpannerSQLException(PARSE_ERROR + sql + ": " + e.getLocalizedMessage(),
				Code.INVALID_ARGUMENT, e);
	}
	return new CloudSpannerParameterMetaData(this);
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
private DeleteWorker createDeleteWorker(Delete delete) throws SQLException
{
	if (delete.getTable() == null || (delete.getTables() != null && delete.getTables().size() > 0))
	{
		throw new CloudSpannerSQLException("DELETE statement must contain only one table", Code.INVALID_ARGUMENT);
	}
	return new DeleteWorker(getConnection(), delete, getConnection().isAllowExtendedMode());
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
public void visit(Delete delete) {
    SelectDeParser selectDeParser = new SelectDeParser();
    selectDeParser.setBuffer(buffer);
    ExpressionDeParser expressionDeParser = new ExpressionDeParser(selectDeParser, buffer);
    selectDeParser.setExpressionVisitor(expressionDeParser);
    DeleteDeParser deleteDeParser = new DeleteDeParser(expressionDeParser, buffer);
    deleteDeParser.deParse(delete);
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
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());
	}

}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
public void visit(Delete delete) {
    tables.add(delete.getTable().getName());
    if (delete.getWhere() != null) {
        delete.getWhere().accept(this);
    }
}
 

import net.sf.jsqlparser.statement.delete.Delete; //导入依赖的package包/类
@Override
public void visit(Delete delete) {
    tables.add(delete.getTable(), table -> table.getName());
    if (delete.getWhere() != null) {
        delete.getWhere().accept(this);
    }
}