当前位置: 首页>>代码示例>>Java>>正文


Java TableNode.delete方法代码示例

本文整理汇总了Java中com.taobao.tddl.optimizer.core.ast.query.TableNode.delete方法的典型用法代码示例。如果您正苦于以下问题:Java TableNode.delete方法的具体用法?Java TableNode.delete怎么用?Java TableNode.delete使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在com.taobao.tddl.optimizer.core.ast.query.TableNode的用法示例。


在下文中一共展示了TableNode.delete方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: testPreparedDeleteSql

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
@Test
public void testPreparedDeleteSql() throws SqlParserException {
    String sql = "DELETE FROM TABLE1 WHERE ID>=? AND ID<=?";
    DeleteNode dn = delete(sql);

    Map<Integer, ParameterContext> currentParameter = new HashMap<Integer, ParameterContext>();
    ParameterContext p1 = new ParameterContext(ParameterMethod.setObject1, new Object[] { 0, 3 });
    ParameterContext p2 = new ParameterContext(ParameterMethod.setObject1, new Object[] { 1, 5 });
    currentParameter.put(1, p1);
    currentParameter.put(2, p2);

    Parameters parameterSettings = new Parameters(currentParameter, false);
    dn.assignment(parameterSettings);
    dn.build();

    TableNode table1 = new TableNode("TABLE1");
    DeleteNode dnExpected = table1.delete();
    table1.query("ID>=3 AND ID<=5");
    dnExpected.build();
    assertEquals(dn, dnExpected);
}
 
开发者ID:loye168,项目名称:tddl5,代码行数:22,代码来源:SqlParserTest.java

示例2: testPreparedDeleteSql

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
@Test
public void testPreparedDeleteSql() throws SqlParserException, QueryException {
    String sql = "DELETE FROM TABLE1 WHERE ID>=? AND ID<=?";
    DeleteNode dn = delete(sql);

    Map<Integer, ParameterContext> parameterSettings = null;
    parameterSettings = new TreeMap<Integer, ParameterContext>();
    ParameterContext p1 = new ParameterContext(ParameterMethod.setObject1, new Object[] { 0, 3 });
    ParameterContext p2 = new ParameterContext(ParameterMethod.setObject1, new Object[] { 1, 5 });
    parameterSettings.put(1, p1);
    parameterSettings.put(2, p2);

    dn.assignment(parameterSettings);
    dn.build();

    TableNode table1 = new TableNode("TABLE1");
    DeleteNode dnExpected = table1.delete();
    table1.query("ID>=3 AND ID<=5");
    dnExpected.build();
    assertEquals(dn, dnExpected);
}
 
开发者ID:beebeandwer,项目名称:TDDL,代码行数:22,代码来源:SqlParserTest.java

示例3: visit

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
@Override
public void visit(DMLDeleteStatement node) {
    TableNode table = null;
    if (node.getTableNames().size() == 1) {
        table = getTableNode(node.getTableNames().get(0).getIdTextUpUnescape());
    } else {
        throw new NotSupportException("not support multi table delete");
    }

    Expression expr = node.getWhereCondition();
    if (expr != null) {
        handleCondition(expr, table);
    }

    this.deleteNode = table.delete();

    if (node.isIgnore()) {
        this.deleteNode.setIgnore(node.isIgnore());
    }

    if (node.isLowPriority()) {
        this.deleteNode.setLowPriority(node.isLowPriority());
    }

    if (node.isQuick()) {
        this.deleteNode.setQuick(node.isQuick());
    }

    Limit limit = node.getLimit();
    if (limit != null) {
        throw new IllegalArgumentException("tddl not support the delete sql with limit expression");

    }

    if (node.getOrderBy() != null) {
        throw new IllegalArgumentException("tddl not support the delete sql with limit expression or order by expression");
    }
}
 
开发者ID:loye168,项目名称:tddl5,代码行数:39,代码来源:MySqlDeleteVisitor.java

示例4: delete

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
@Test
public void testDelete_正常() throws SqlParserException {
    String sql = "DELETE FROM TABLE1 WHERE ID>=5 AND ID<=5";
    DeleteNode dn = delete(sql);
    dn.build();

    TableNode table1 = new TableNode("TABLE1");
    DeleteNode dnExpected = table1.delete();
    table1.query("ID>=5 AND ID<=5");
    dnExpected.build();

    assertEquals(dn, dnExpected);
}
 
开发者ID:loye168,项目名称:tddl5,代码行数:14,代码来源:SqlParserTest.java

示例5: visit

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
public void visit(DMLDeleteStatement node) {
    TableNode table = null;
    if (node.getTableNames().size() == 1) {
        table = getTableNode(node.getTableNames().get(0).getIdTextUpUnescape());
    } else {
        throw new NotSupportException("not support multi table delete");
    }

    Expression expr = node.getWhereCondition();
    if (expr != null) {
        handleCondition(expr, table);
    }

    this.deleteNode = table.delete();
}
 
开发者ID:beebeandwer,项目名称:TDDL,代码行数:16,代码来源:MySqlDeleteVisitor.java

示例6: delete

import com.taobao.tddl.optimizer.core.ast.query.TableNode; //导入方法依赖的package包/类
@Test
public void testDelete_正常() throws SqlParserException, QueryException {
    String sql = "DELETE FROM TABLE1 WHERE ID>=5 AND ID<=5";
    DeleteNode dn = delete(sql);
    dn.build();

    TableNode table1 = new TableNode("TABLE1");
    DeleteNode dnExpected = table1.delete();
    table1.query("ID>=5 AND ID<=5");
    dnExpected.build();

    assertEquals(dn, dnExpected);
}
 
开发者ID:beebeandwer,项目名称:TDDL,代码行数:14,代码来源:SqlParserTest.java


注:本文中的com.taobao.tddl.optimizer.core.ast.query.TableNode.delete方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。