Examples of IQuery

com.google.enterprise.connector.dctm.dfcwrap.IQuery
com.pv.mf.db.mock.lang.IQuery
com.salas.bb.domain.query.IQuery
Query object. Consists of several criteria records. Query can join the criteria with "AND" or "OR" to get the final match answer. Each particular implementation of query knows how to handle specific type of objects. It provides the list of all available properties it supports. When building the query this information is enough to create criteria objects on the fly using the provided meta-information. When rebuilding the query during deserialization it's possible to get the properties by their descriptors.
net.floodlightcontroller.storage.IQuery
Representation of a database query. For SQL queries this maps to a prepared statement, so it will be more efficient than if you use the methods in IStorageSource that bypass the IQuery. For many NoSQL storage sources there won't be any performance improvement from keeping around the query. The query interface also supports parameterized queries (i.e. which maps to using ? values in a SQL query). The values of the parameters are set using the setParameter method. In the storage source API the parameters are named rather than positional. The format of the parameterized values in the query predicates is the parameter name bracketed with question marks (e.g. ?MinimumSalary? ). @author rob
org.eclipse.persistence.jpa.jpql.spi.IQuery
The external representation of a JPQL query. @version 2.3 @since 2.3 @author Pascal Filion
org.eclipse.persistence.jpa.jpql.tools.spi.IQuery
The external representation of a JPQL query.
Provisional API: This interface is part of an interim API that is still under development and expected to change significantly before reaching stability. It is available at this early stage to solicit feedback from pioneering adopters on the understanding that any code that uses this API will almost certainly be broken (repeatedly) as the API evolves. @version 2.3 @since 2.3 @author Pascal Filion
org.saiku.olap.query.IQuery
IQuery.

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

   
   @Test
   public void buildSelectAndNotEqual() {
      
      IBuilder<User> builder = _annotationFactory.createBuilder(User.class);
      IQuery q= builder.select().
                                 columns(builder.mock().getId(), builder.mock().getUserName()).
                                 where().
                                    andNotEqual(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.andNotEqual(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

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

      
      builder.columns(user.getId(), user.getUserName());
      
      builder.and(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());
      
//      Assert.assertEquals(
//            "SELECT id,userName FROM user_mx_14.user WHERE  id = ?  ",
//            statment);
//      Assert.assertArrayEquals(new Object[] {1L}, sql.getParameters());

View Full Code Here

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




   @Test
   public void orderBy() {
      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().
                                    orderBy(builder.mock().getUserName()).
                                    buildQuery();
      
      Assert.assertEquals(
            "SELECT user.id,user.userName"
            + " FROM user_mx_14.user"
            + " WHERE user.id = ?"
            + " ORDER BY user.userName",
            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);
      sel.orderBy(builder.mock().getUserName());
      q = sel.buildQuery();
      
      Assert.assertEquals(
               "SELECT user.id,user.userName"
               + " FROM user_mx_14.user"
               + " WHERE user.id = ?"
               + " ORDER BY user.userName",
               q.getSql());
         Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());
   }

View Full Code Here

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

      
      builder.columns(user.getId(), user.getUserDetails().getEmail());
      
      builder.and(user.getId(), 1L);
      
      IQuery statment = builder.build();
      Assert.assertEquals(
            "SELECT user_details.email,user.id FROM user_mx_14.user_role,user_mx_14.user_details,user_mx_14.user WHERE user_role.userId = ? AND user_details.userId = ? AND user.id = ?",
            statment.getSql());
      Assert.assertEquals(
            "user.id",
            statment.getParameterValues()[0].toString());
      Assert.assertEquals(
            "user.id",
            statment.getParameterValues()[1].toString());
      Assert.assertEquals(
            1L,
            statment.getParameterValues()[2]);
   }

View Full Code Here

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

   }
   
   @Test
   public void limit() {
      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().
                                    limit(14).
                                    buildQuery();
      
      Assert.assertEquals(
            "SELECT user.id,user.userName"
            + " FROM user_mx_14.user"
            + " WHERE user.id = ?"
            + " LIMIT 14",
            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);
      sel.limit(14);
      q = sel.buildQuery();
      
      Assert.assertEquals(
               "SELECT user.id,user.userName"
               + " FROM user_mx_14.user"
               + " WHERE user.id = ?"
               + " LIMIT 14",
               q.getSql());
         Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());
   }

View Full Code Here

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

//            builder.normalize(user.getRoles()).getRoleId(),
//            builder.normalize(user.getRoles()).getUserId());
      
      builder.and(user.getId(), 1L);
      
      IQuery statment = builder.build();
      Assert.assertEquals(
//            "SELECT user_role.roleId,user_role.userId,user.id FROM user_mx_14.user_role,user_mx_14.user WHERE user_role.userId = ? AND user.id = ?",
            "SELECT user.id,user_role.userId,user_role.roleId FROM user_mx_14.user_role,user_mx_14.user_details,user_mx_14.user WHERE user_role.userId = ? AND user_details.userId = ? AND user.id = ?",
            statment.getSql());
      Assert.assertEquals(
            "user.id",
            statment.getParameterValues()[0].toString());
      Assert.assertEquals(
            "user.id",
            statment.getParameterValues()[1].toString());
      Assert.assertEquals(
            1L,
            statment.getParameterValues()[2]);
   }

View Full Code Here

Examples of com.salas.bb.domain.query.IQuery

    /**
     * Tests adding criteria to the tail of the query when "Add" button is pressed.
     */
    public void testAddCriteria()
    {
        IQuery query = new DummyStringQuery();
        builder.setQuery(query);


        ICriteria defaultCriteria = query.getCriteriaAt(0);


        builder.addEmptyCriteria();
        assertEquals("Criteria should be added to query.",
            2, query.getCriteriaCount());
        assertFalse("Wrong criteria object in the tail.",
            defaultCriteria == query.getCriteriaAt(1));
    }

View Full Code Here

Examples of com.salas.bb.domain.query.IQuery

     * Tests removing the criteria by its index and protecting the last criteria from
     * being removed.
     */
    public void testRemoveCriteria()
    {
        IQuery query = new DummyStringQuery();
        builder.setQuery(query);
        builder.addEmptyCriteria();
        ICriteria defaultCriteria = query.getCriteriaAt(0);


        builder.removeCriteria(0);
        assertEquals("Criteria should be removed.", 1, query.getCriteriaCount());
        assertFalse("Wrong criteria removed.", defaultCriteria == query.getCriteriaAt(0));


        builder.removeCriteria(0);
        assertEquals("The last criteria should not be removed.", 1, query.getCriteriaCount());
    }

View Full Code Here

Examples of net.floodlightcontroller.storage.IQuery

        Object[][] expectedResults = {
                {"Lisa", "Jones"},
                {"Susan", "Jones"}
        };
        IPredicate predicate = new OperatorPredicate(PERSON_LAST_NAME, OperatorPredicate.Operator.EQ, "Jones");
        IQuery query = storageSource.createQuery(PERSON_TABLE_NAME, columnList, predicate, new RowOrdering(PERSON_SSN));
        IResultSet resultSet = storageSource.executeQuery(query);
        checkExpectedResults(resultSet, columnList, expectedResults);
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.spi.IQuery

      Annotation[] annotations = type.getAnnotations();
      NamedQueries namedQueries = getAnnotation(annotations, NamedQueries.class);


      if (namedQueries != null) {
        for (NamedQuery namedQuery : namedQueries.value()) {
          IQuery query = buildQuery(namedQuery);
          queries.put(namedQuery.name(), query);
        }
      }
      else {
        NamedQuery namedQuery = getAnnotation(annotations, NamedQuery.class);
        if (namedQuery != null) {
          IQuery query = buildQuery(namedQuery);
          queries.put(namedQuery.name(), query);
        }
      }
    }
    catch (Exception e) {

View Full Code Here

0 1 2 3 4 5

TOP

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.