Examples of addRoot()


Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q1);
    }

    public void testNew() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        DomainObject order = customer.join("orders");
        q.where(order.get("count").greaterThan(100))
         .select(q.newInstance(Customer.class, customer.get("id"),
                                               customer.get("status"),
                                               order.get("count")));
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q);
    }
   
    public void testKeyValueOperatorPath() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject v = q.addRoot(VideoStore.class);
        DomainObject i = v.join("videoInventory");
        q.where(v.get("location").get("zipCode").equal("94301").and(
            i.value().greaterThan(0)));
        q.select(v.get("location").get("street"), i.key().get("title"), i
            .value());
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q);
    }
   
    public void testGroupByHaving() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        q.select(customer.get("status"), customer.get("filledOrderCount").avg(),
                 customer.count())
         .groupBy(customer.get("status"))
         .having(customer.get("status").in(1, 2));
       
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q);
    }
   
    public void testGroupByHaving2() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        q.select(customer.get("country"), customer.count())
         .groupBy(customer.get("country"))
         .having(customer.count().greaterThan(30));
       
        String jpql = "SELECT c.country, COUNT(c)"
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q);
    }
   
    public void testOrderBy() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        DomainObject order = customer.join("orders");
        DomainObject address = customer.join("address");
        q.where(address.get("state").equal("CA"))
        .select(order)
        .orderBy(order.get("quantity").desc(), order.get("totalcost"));
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, q);
    }
   
    public void testOrderBy2() {
        QueryDefinition q = qb.createQueryDefinition();
        DomainObject customer = q.addRoot(Customer.class);
        DomainObject order = customer.join("orders");
        DomainObject address = customer.join("address");
        q.where(address.get("state").equal("CA"))
        .select(order.get("quantity"), address.get("zipCode"))
        .orderBy(order.get("quantity").desc(), address.get("zipCode"));
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, o);
    }
   
    public void testCorrelatedSubquery() {
        QueryDefinition q1 = qb.createQueryDefinition();
        DomainObject emp = q1.addRoot(Employee.class);
       
        QueryDefinition q2 = qb.createQueryDefinition();
        DomainObject spouseEmp = q2.addRoot(Employee.class);
       
        q2.where(spouseEmp.equal(emp.get("spouse"))).select(spouseEmp);
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

    public void testCorrelatedSubquery() {
        QueryDefinition q1 = qb.createQueryDefinition();
        DomainObject emp = q1.addRoot(Employee.class);
       
        QueryDefinition q2 = qb.createQueryDefinition();
        DomainObject spouseEmp = q2.addRoot(Employee.class);
       
        q2.where(spouseEmp.equal(emp.get("spouse"))).select(spouseEmp);
        q1.selectDistinct(emp).where(q2.exists());
       
        String jpql = "SELECT DISTINCT e "
View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.addRoot()

        compare(jpql, e);
    }
   
    public void testOperatorPath() {
        QueryDefinition qdef = qb.createQueryDefinition();
        DomainObject item = qdef.addRoot(Item.class);
        DomainObject photo = item.join("photos");
        qdef.select(item.get("name"), photo.value())
            .where(photo.key().like("egret"));
       
       
View Full Code Here

Examples of org.grouplens.lenskit.core.LenskitConfiguration.addRoot()

    LenskitRecommender recommender;

    @Before
    public void createRecommender() throws RecommenderBuildException {
        LenskitConfiguration config = new LenskitConfiguration();
        config.addRoot(ItemDAO.class);
        config.bind(ItemDAO.class).to(FixedItemDAO.class);
        config.bind(EventDAO.class).to(EventCollectionDAO.create(Collections.<Rating>emptyList()));
        recommender = LenskitRecommender.build(config);
    }
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.