Examples of IQuery


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

     
      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

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

      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

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

      return this;
   };
  
  
   public int execute() {
      IQuery query = buildQuery();
      return _builder.getEntityHandler().executeQuery(_builder.getController(), query, SqlMode.INSERT);
   }
View Full Code Here

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

      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

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

   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

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

      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

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

      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

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

      }
     
   }
  
   public int execute() {
      IQuery query = buildQuery();
      return _builder.getEntityHandler().executeQuery(_builder.getController(), query, SqlMode.DELETE);
   }
View Full Code Here

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

      _builder.getController().setValue(_builder.getLastInvokedColumn().getSetterMethod(), value);
      return this;
   }

   public int execute() {
      IQuery query = buildQuery();
      return _builder.getEntityHandler().executeQuery(_builder.getController(), query, SqlMode.UPDATE);
   }
View Full Code Here

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

  
   @Test
   public void buildSelectAndEqual() {
     
      IBuilder<User> builder = _annotationFactory.createBuilder(User.class);
      IQuery q = builder.select().
                                 columns(builder.mock().getId(), builder.mock().getUserName()).
                                 where().
                                    and(builder.mock().getId(), 1L).parent().buildQuery();

      Assert.assertEquals(
               "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
               q.getSql());
         Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());

      Select sel = builder.select();
      sel.columns(builder.mock().getId(), builder.mock().getUserName());
      Where w = sel.where();
      w.and(builder.mock().getId(), 1L);
     
      q = sel.buildQuery();
     
      Assert.assertEquals(
            "SELECT user.id,user.userName FROM user_mx_14.user WHERE user.id = ?",
            q.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());
   }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.