Package com.mysql.clusterj.query

Examples of com.mysql.clusterj.query.QueryBuilder

130
131
132
133
134
135
136
137
138
139
140
141
        AnnotatedTBasic instance = session.find(AnnotatedTBasic.class, 0);
        validateInstance(instance);
    }

    private void lookup() {
        QueryBuilder builder = session.getQueryBuilder();
        QueryDomainType<TBasic> queryTBasic = builder.createQueryDefinition(TBasic.class);
        queryTBasic.where(queryTBasic.get("magic").equal(queryTBasic.param("magic")));
        Query<TBasic> query = session.createQuery(queryTBasic);
        query.setParameter("magic", 1);
        TBasic instance = query.getResultList().get(0);
        validateInstance(instance);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
151
        TBasic instance = query.getResultList().get(0);
        validateInstance(instance);
    }

    private void query() {
        QueryBuilder builder = session.getQueryBuilder();
        QueryDomainType<TBasic> queryTBasic = builder.createQueryDefinition(TBasic.class);
        queryTBasic.where(queryTBasic.get("name").equal(queryTBasic.param("name")));
        Query<TBasic> query = session.createQuery(queryTBasic);
        query.setParameter("name", "2");
        TBasic instance = query.getResultList().get(0);
        validateInstance(instance);
View Full Code Here
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
                public void run(int nOps) {
                    if (mode != CrundDriver.XMode.INDY) {
                        beginTransaction();
                    }
                    // QueryBuilder is the sessionFactory for queries
                    final QueryBuilder builder
                        = session.getQueryBuilder();
                    // QueryDomainType is the main interface
                    final QueryDomainType<IB0> dobj
                        = builder.createQueryDefinition(IB0.class);
                    // filter by aid
                    dobj.where(dobj.get("aid").equal(dobj.param("aid")));
                    query = session.createQuery(dobj);
                    for (int i = 0; i < nOps; i++) {
                        // find B0s by query
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
    }
    public void uniqueKeyEqualQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand param = dobj.param("eid");
        // property name
        PredicateOperand column = dobj.get("eid");
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
    public void uniqueKeyGreaterThanQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand param = dobj.param("eid");
        // property name
        PredicateOperand column = dobj.get("eid");
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
    public void uniqueKeyGreaterEqualQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand param = dobj.param("eid");
        // property name
        PredicateOperand column = dobj.get("eid");
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
189
190
    public void uniqueKeyLessThanQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand param = dobj.param("eid");
        // property name
        PredicateOperand column = dobj.get("eid");
View Full Code Here
217
218
219
220
221
222
223
224
225
226
227
228
229
    public void uniqueKeyLessEqualQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand param = dobj.param("eid");
        // property name
        PredicateOperand column = dobj.get("eid");
View Full Code Here
256
257
258
259
260
261
262
263
264
265
266
267
268
    public void uniqueKeyBetweenQuery() {

        tx.begin();
        // QueryBuilder is the sessionFactory for queries
        QueryBuilder builder = session.getQueryBuilder();
        // QueryDomainType is the main interface
        QueryDomainType dobj = builder.createQueryDefinition(Dn2id.class);

        // parameter name
        PredicateOperand lower = dobj.param("lower");
        // parameter name
        PredicateOperand upper = dobj.param("upper");
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
    }

    protected void query() {
        tx = session.currentTransaction();
        tx.begin();
        QueryBuilder builder = session.getQueryBuilder();
        QueryDomainType dobj = builder.createQueryDefinition(NotPersistentTypes.class);
        dobj.where(dobj.get("id").equal(dobj.param("id")));
        Query query = session.createQuery(dobj);
        query.setParameter("id", 0);
        List<NotPersistentTypes> result = query.getResultList();
        int resultSize = result.size();
View Full Code Here
TOP

Related Classes of com.mysql.clusterj.query.QueryBuilder

  • com.mysql.cluster.crund.ClusterjLoad
  • testsuite.clusterj.AutoCommitTest
  • testsuite.clusterj.DynamicObjectTest
  • testsuite.clusterj.NotPersistentTest
  • testsuite.clusterj.QueryExplainTest
  • testsuite.clusterj.QueryMultipleParameterTest
  • testsuite.clusterj.QueryPrimaryKeyTest
  • testsuite.clusterj.QueryTableScanTest
  • testsuite.clusterj.QueryUniqueKeyTest
    • 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.