Package com.mysema.query.sql

Examples of com.mysema.query.sql.SQLQuery

13
14
15
16
17
18
19
20
21
   
    private QSurvey survey = new QSurvey("survey");
   
    @Before
    public void setUp() {
        query = new SQLQuery(null, new H2Templates() {{
            newLineToSingleSpace();
        }});
    }
View Full Code Here
13
14
15
16
17
18
19
20
21
   
    private QSurvey survey = new QSurvey("survey");
   
    @Before
    public void setUp() {
        query = new SQLQuery(null, new H2Templates() {{
            newLineToSingleSpace();
        }});
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
    @Test
    public void test() throws IOException, SecurityException,
            IllegalArgumentException, NoSuchMethodException,
            IllegalAccessException, InvocationTargetException {
        SQLQuery query = new SQLQuery(connection, new DerbyTemplates());
        query.from(survey);
        query.addListener(new TestLoggingListener());
        new QueryMutability(query).test(survey.id, survey.name);
    }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
        new QueryMutability(query).test(survey.id, survey.name);
    }

    @Test
    public void Clone() {
        SQLQuery query = new SQLQuery(new DerbyTemplates()).from(survey);
        SQLQuery query2 = query.clone(connection);
        assertEquals(query.getMetadata().getJoins(), query2.getMetadata().getJoins());
        assertEquals(query.getMetadata().getWhere(), query2.getMetadata().getWhere());
        query2.list(survey.id);
    }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
        Runner.run("qdsl by id", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {           
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf);
                    query.from(companies).where(companies.id.eq((long)i))
                        .list(companies.name);           
                }               
            }           
        });   
    }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
149
        Runner.run("qdsl by id (iterated)", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {           
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf);
                    CloseableIterator<String> it = query.from(companies)
                            .where(companies.id.eq((long)i)).iterate(companies.name);
                    try {
                        while (it.hasNext()) {
                            it.next();
                        }   
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
        Runner.run("qdsl by id (result set access)", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {           
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf);
                    ResultSet rs = query.from(companies)
                            .where(companies.id.eq((long)i)).getResults(companies.name);         
                    try {
                        while (rs.next()) {
                            rs.getString(1);
                        }
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
        Runner.run("qdsl by id (no validation)", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {           
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf, new DefaultQueryMetadata().noValidate());
                    query.from(companies).where(companies.id.eq((long)i))
                        .list(companies.name);           
                }               
            }           
        });   
    }
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
        Runner.run("qdsl by id (two cols)", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf);
                    query.from(companies).where(companies.id.eq((long)i))
                        .list(companies.id, companies.name);           
                }               
            }           
        });           
    }
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
223
        Runner.run("qdsl by name", new Benchmark() {
            @Override
            public void run(int times) throws Exception {
                for (int i = 0; i < times; i++) {           
                    QCompanies companies = QCompanies.companies;
                    SQLQuery query = new SQLQuery(conn, conf);
                    query.from(companies).where(companies.name.eq(String.valueOf(i)))
                        .list(companies.name);           
                }               
            }           
        });   
    }
View Full Code Here
TOP

Related Classes of com.mysema.query.sql.SQLQuery

  • com.mysema.query.DefaultQueryMetadata
  • com.mysema.query.QueryMutabilityTest
  • com.mysema.query.QueryPerformanceTest
  • com.mysema.query.sql.h2.H2QueryTest
  • com.mysema.query.sql.hsqldb.HsqldbQueryTest
    • 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.