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

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

53
54
55
56
57
58
59
60
61
            NoSuchMethodException, IllegalAccessException,
            InvocationTargetException, IOException {
        entityManager.persist(new Cat("Beck", 1));
        entityManager.flush();

        SAnimal cat = new SAnimal("cat");
        JPASQLQuery query = query().from(cat);
        new QueryMutability(query).test(cat.id, cat.name);
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        new QueryMutability(query).test(cat.id, cat.name);
    }

    @Test
    public void Clone() {
        SAnimal cat = new SAnimal("cat");
        JPASQLQuery query = query().from(cat).where(cat.name.isNotNull());
        JPASQLQuery query2 = query.clone(entityManager);
        assertEquals(query.getMetadata().getJoins(), query2.getMetadata().getJoins());
        assertEquals(query.getMetadata().getWhere(), query2.getMetadata().getWhere());
        query2.list(cat.id);
View Full Code Here
45
46
47
48
49
50
51
52
53
    @Test
    @Ignore
    public void QueryMutability() throws SecurityException, IllegalArgumentException,
            NoSuchMethodException, IllegalAccessException,
            InvocationTargetException, IOException {
        SAnimal cat = new SAnimal("cat");
        HibernateSQLQuery query = query().from(cat);
        new QueryMutability(query).test(cat.id, cat.name);
    }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
        new QueryMutability(query).test(cat.id, cat.name);
    }

    @Test
    public void Clone() {
        SAnimal cat = new SAnimal("cat");
        HibernateSQLQuery query = query().from(cat).where(cat.name.isNotNull());
        HibernateSQLQuery query2 = query.clone(session);
        assertEquals(query.getMetadata().getJoins(), query2.getMetadata().getJoins());
        assertEquals(query.getMetadata().getWhere(), query2.getMetadata().getWhere());
        //query2.list(cat.id);
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
    @Test
    public void In() {
        Configuration conf = new Configuration(new MySQLTemplates());
        NativeSQLSerializer serializer = new NativeSQLSerializer(conf, true);
        DefaultQueryMetadata md = new DefaultQueryMetadata();
        SAnimal cat = SAnimal.animal_;
        md.addJoin(JoinType.DEFAULT, cat);
        md.addWhere(cat.name.in("X", "Y"));
        md.addProjection(cat.id);
        serializer.serialize(md, false);
        assertEquals("select animal_.id\n" +
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        }
    }

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

        Query query = query().from(cat).createQuery(catEntity);
        assertEquals(6, query.list().size());
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    }

    @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.list().size());
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        }
    }

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

        List<Cat> cats = query().from(cat)
                .innerJoin(mate).on(cat.mateId.eq(mate.id))
                .where(cat.dtype.eq("C"), mate.dtype.eq("C"))
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
    @Test
    @NoBatooJPA
    @NoEclipseLink
    public void EntityQueries5() {
        QCat catEntity = QCat.cat;
        SAnimal otherCat = new SAnimal("otherCat");
        QCat otherCatEntity = new QCat("otherCat");
        List<Tuple> cats = query().from(cat, otherCat).list(catEntity, otherCatEntity);
        assertEquals(36, cats.size());

        for (Tuple tuple : cats) {
View Full Code Here
246
247
248
249
250
251
252
253
        }
    }

    @Test
    public void Projections_DuplicateColumns() {
        SAnimal cat = new SAnimal("cat");
        assertEquals(1, query().from(cat).list(new QList(cat.count(), cat.count())).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.