Package com.mysema.query.jpa.domain.sql

Examples of com.mysema.query.jpa.domain.sql.SAnimal

295
296
297
298
299
300
301
302
303
304
305
    }

    @Test
    @ExcludeIn(Target.DERBY)
    public void Union3() {
        SAnimal cat2 = new SAnimal("cat2");
        List<Tuple> rows = query().union(
            new SQLSubQuery().from(cat).innerJoin(cat2).on(cat2.id.eq(cat.id)).list(cat.id, cat2.id),
            new SQLSubQuery().from(cat).list(cat.id, null))
        .list();
View Full Code Here
322
323
324
325
326
327
328
329
330
331
332
    }

    @Test
    @ExcludeIn({Target.DERBY, Target.ORACLE})
    public void Union5() {
        SAnimal cat2 = new SAnimal("cat2");
        List<Tuple> rows = query().union(
            new SQLSubQuery().from(cat).join(cat2).on(cat2.id.eq(cat.id.add(1))).list(cat.id, cat2.id),
            new SQLSubQuery().from(cat).join(cat2).on(cat2.id.eq(cat.id.add(1))).list(cat.id, cat2.id))
        .list();
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
        }
    }

    @Test
    public void EntityQueries_CreateQuery() {
        SAnimal cat = new SAnimal("cat");
        QCat catEntity = QCat.cat;

        Query query = query().from(cat).createQuery(catEntity);
        assertEquals(6, query.getResultList().size());
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    }

    @Test
    @ExcludeIn(Target.MYSQL)
    public void EntityQueries_CreateQuery2() {
        SAnimal cat = new SAnimal("CAT");
        QCat catEntity = QCat.cat;

        Query query = query().from(cat).createQuery(catEntity);
        assertEquals(6, query.getResultList().size());
    }
View Full Code Here
TOP

Related Classes of com.mysema.query.jpa.domain.sql.SAnimal

  • com.mysema.query.AbstractSQLTest
  • com.mysema.query.HibernateSQLBase
  • com.mysema.query.jpa.JPAQueryMutabilityTest
  • com.mysema.query.jpa.NativeSQLSerializerTest
  • com.mysema.query.jpa.QueryMutabilityTest
  • com.mysema.query.JPASQLBase
    • 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.