Package com.alvazan.orm.parser.antlr

Examples of com.alvazan.orm.parser.antlr.ExpressionNode

91
92
93
94
95
96
97
98
99
  }
 
  @Test
  public void testRewriteJoin() {
    String sql = "select p FROM TABLE as p INNER JOIN p.security as s where p.numShares = :shares and s.securityType = :type";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  }
View Full Code Here
98
99
100
101
102
103
104
105
106
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  }
  @Test
  public void testJoinJoinOnSame() {
    String sql = "select p FROM TABLE as p INNER JOIN p.security as s INNER JOIN p.something as t where p.numShares = :shares and s.securityType = :type";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  }
  @Test
  public void testJoinJoinOnChain() {
    String sql = "select p FROM TABLE as p INNER JOIN p.security as s INNER JOIN s.something as t where p.numShares = :shares and s.securityType = :type";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  } 
View Full Code Here
112
113
114
115
116
117
118
119
120
    Assert.assertEquals("(s.securityType = :type and(innerjoin) p.numShares = :shares)", result);
  } 
  @Test
  public void testNoRewrite() {
    String sql = "select p FROM TABLE as p INNER JOIN p.security as s where p.numShares = :shares and p.something = :something";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("(p.numShares = :shares and p.something = :something)", result);
  }
View Full Code Here
120
121
122
123
124
125
126
127
128
  }
 
  @Test
  public void testSingleOrderBy() {
    String sql = "select p FROM TABLE as p INNER JOIN p.security as s where p.numShares = :shares and p.something = :something ORDER BY something ASC";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("(p.numShares = :shares and p.something = :something)", result);
  }
View Full Code Here
131
132
133
134
135
136
137
138
139
  public void testLargeTree() {
    String sql = "select a FROM TABLE as a INNER JOIN a.security as d INNER JOIN a.something as b INNER JOIN b.some as e" +
        " INNER JOIN b.two as g INNER JOIN g.two as f INNER JOIN f.try as h" +
        " where ( ((a.y>:a and d.y>:a) or (a.z>:a and b.z>:a)) and (b.x>:a and e.y>:a) )" +
        " and ( ((f.x>:a and f.y>:a) or (g.x>:a and g.y>:a)) and h.f>:a )";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = ""+newTree;
    Assert.assertEquals("((h.f > :a and(innerjoin) ((f.x > :a and f.y > :a) or(innerjoin) (g.x > :a and g.y > :a))) and(innerjoin) (((d.y > :a and(innerjoin) a.y > :a) or (b.z > :a and(innerjoin) a.z > :a)) and (e.y > :a and(innerjoin) b.x > :a)))", result);
  }
View Full Code Here
139
140
141
142
143
144
145
146
147
  }

  @Test
  public void testDelteTree() {
    String sql = "delete from TABLE where id = \"acc1\"";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = "" + newTree;
    Assert.assertEquals("id = \"acc1\"", result);
  }
View Full Code Here
147
148
149
150
151
152
153
154
155
  }

  @Test
  public void testMultiUpdateTree() {
    String sql = "update TABLE set (name=\"test\",account=\"ac\") where id = \"acc1\"";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = "" + newTree;
    Assert.assertEquals("id = \"acc1\"", result);
  }
View Full Code Here
155
156
157
158
159
160
161
162
163
  }

  @Test
  public void testAliasUpdateTree() {
    String sql = "update table as a inner join a.account as b set(a.users=\"test\") where (a.id=\"acc1\")";
    ExpressionNode newTree = scanner.compileSql(sql, wiring, facade);
    String result = "" + newTree;
    Assert.assertEquals("a.id = \"acc1\"", result);
  }
View Full Code Here
58
59
60
61
62
63
64
    return toOne;
  }

  @Override
  public ParsedNode createExpression(int nodeType) {
    return new ExpressionNode(nodeType);
  }
View Full Code Here
TOP

Related Classes of com.alvazan.orm.parser.antlr.ExpressionNode

  • com.alvazan.orm.layer5.query.MetaFacadeImpl
  • com.alvazan.orm.layer5.query.ScannerForQuery
  • com.alvazan.orm.layer5.query.SpiIndexQueryImpl
  • com.alvazan.test.MockFacade
  • com.alvazan.test.TestGrammar
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.