Esempio n. 1
0
  @Test
  public void testUpdateTableAlias() throws Exception {
    UpdateAnalyzedStatement.NestedAnalyzedStatement expectedAnalysis =
        analyze("update users set awesome=true where awesome=false").nestedStatements().get(0);
    UpdateAnalyzedStatement.NestedAnalyzedStatement actualAnalysis =
        analyze("update users as u set awesome=true where awesome=false").nestedStatements().get(0);

    assertEquals(expectedAnalysis.assignments(), actualAnalysis.assignments());
    assertEquals(
        ((Function) expectedAnalysis.whereClause().query()).arguments().get(0),
        ((Function) actualAnalysis.whereClause().query()).arguments().get(0));
  }
Esempio n. 2
0
 @Test
 public void testUpdateWhereClause() throws Exception {
   UpdateAnalyzedStatement.NestedAnalyzedStatement analysis =
       analyze("update users set other_id=9 where name='Trillian'").nestedStatements().get(0);
   assertThat(analysis.whereClause().hasQuery(), is(true));
   assertThat(analysis.whereClause().noMatch(), is(false));
 }
Esempio n. 3
0
  @Test
  public void testUpdateWithParameter() throws Exception {
    Map[] friends =
        new Map[] {
          new HashMap<String, Object>() {
            {
              put("name", "Slartibartfast");
            }
          },
          new HashMap<String, Object>() {
            {
              put("name", "Marvin");
            }
          }
        };
    UpdateAnalyzedStatement.NestedAnalyzedStatement analysis =
        analyze(
                "update users set name=?, other_id=?, friends=? where id=?",
                new Object[] {"Jeltz", 0, friends, "9"})
            .nestedStatements()
            .get(0);
    assertThat(analysis.assignments().size(), is(3));
    assertThat(
        analysis
            .assignments()
            .get(new Reference(USER_TABLE_INFO.getReferenceInfo(new ColumnIdent("name")))),
        isLiteral("Jeltz"));
    assertThat(
        analysis
            .assignments()
            .get(new Reference(USER_TABLE_INFO.getReferenceInfo(new ColumnIdent("friends")))),
        isLiteral(friends, new ArrayType(DataTypes.OBJECT)));
    assertThat(
        analysis
            .assignments()
            .get(new Reference(USER_TABLE_INFO.getReferenceInfo(new ColumnIdent("other_id")))),
        isLiteral(0L));

    assertThat(((Function) analysis.whereClause().query()).arguments().get(1), isLiteral(9L));
  }
Esempio n. 4
0
 @Test
 public void testNoMatchWhereClause() throws Exception {
   UpdateAnalyzedStatement.NestedAnalyzedStatement analysis =
       analyze("update users set other_id=9 where true=false").nestedStatements().get(0);
   assertThat(analysis.whereClause().noMatch(), is(true));
 }
Esempio n. 5
0
 @Test
 public void testNoWhereClause() throws Exception {
   UpdateAnalyzedStatement.NestedAnalyzedStatement analysis =
       analyze("update users set other_id=9").nestedStatements().get(0);
   assertThat(analysis.whereClause(), is(WhereClause.MATCH_ALL));
 }