Package com.pv.mf.db.mock.lang

Examples of com.pv.mf.db.mock.lang.IQuery

224
225
226
227
228
229
230
231
232
233
234
235
     
      builder.columns(user.getId(), user.getUserName());
     
      builder.and(user.getId(),new Long(1L));
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
     
      builder.columns(user.getId(), user.getUserName());
     
      builder.andNotEqual(user.getId(), 1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id != ?",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
     
      builder.and(user.getId(), 1L);
     
      builder.orderBy(user.getUserName());
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName"
            + " FROM user_mx_14.user"
            + " WHERE user.id = ?"
            + " ORDER BY user.userName",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
348
349
350
351
352
353
354
355
356
357
358
359
      DeleteBuilder builder = (DeleteBuilder)_annotationFactory.delete();
      User user = builder.mock(User.class);
     
      builder.and(user.getId(),new Long(1L));
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "DELETE FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
47
48
49
50
51
52
53
54
      return this;
   };
  
  
   public int execute() {
      IQuery query = buildQuery();
      return _builder.getEntityHandler().executeQuery(_builder.getController(), query, SqlMode.INSERT);
   }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
      User user = builder.mock(User.class);
     
      builder.columns(user.getId(), user.getUserName());
      user.setId(1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
   public void delete() {
      DeleteBuilder builder = (DeleteBuilder)_annotationFactory.delete();
      User user = builder.mock(User.class);
      user.setId(1L);
     
      IQuery statment = builder.build();
      Assert.assertEquals(
            "DELETE FROM user_mx_14.user WHERE user.id = ?",
            statment.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, statment.getParameterValues());
     
   }
View Full Code Here
149
150
151
152
153
154
155
156
157
      return this;
   }
  
   @SuppressWarnings("unchecked")
   public <M> M queryForObject(){
      IQuery q = buildQuery();
      _builder.getEntityHandler().executeQuery(_builder.getController(), q, SqlMode.SELECT);
      return (M)_builder.mock();
   }
View Full Code Here
165
166
167
168
169
170
171
172
173
      if ( _builder.getQuery().getColumns().isEmpty() ){
         columns();
      }     
      _builder.getQuery().addTable(_builder.getLastInvokedTable());
      _builder.cleanInvokedColumn();
      IQuery q = _builder.getEntityHandler().generateQuery(_builder.getQuery(), SqlMode.SELECT);
      _builder.reset();
      return q;
   }
View Full Code Here
72
73
74
75
76
77
78
79
      }
     
   }
  
   public int execute() {
      IQuery query = buildQuery();
      return _builder.getEntityHandler().executeQuery(_builder.getController(), query, SqlMode.DELETE);
   }
View Full Code Here
TOP

Related Classes of com.pv.mf.db.mock.lang.IQuery

  • com.pv.mf.db.mock.impl.MockBuilderSettersTest
  • com.pv.mf.db.mock.impl.MockBuilderTest
  • com.pv.mf.db2.impl.Delete
  • com.pv.mf.db2.impl.Insert
  • com.pv.mf.db2.impl.MockBuilderTest
  • com.pv.mf.db2.impl.Select
  • com.pv.mf.db2.impl.Update
    • 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.