Package org.apache.metamodel.query

Examples of org.apache.metamodel.query.Query

80
81
82
83
84
85
86
87
88
89
90
91
    DataContext converted = Converters.addTypeConverter(source, fooColumn,
        new StringToIntegerConverter());

    // only select "bar" which is not converted
    Table table = converted.getDefaultSchema().getTableByName("table");
    Query query = converted.query().from(table).select("bar").toQuery();
    assertEquals("SELECT table.bar FROM schema.table", query.toSql());

    DataSet ds = converted.executeQuery(query);
    assertEquals(InMemoryDataSet.class, ds.getClass());

  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
        final Table table = dc.getDefaultSchema().getTables()[0];
        Map<Column, TypeConverter<?, ?>> converters = Converters.autoDetectConverters(dc, table, 1000);
        assertEquals(1, converters.size());
        dc = Converters.addTypeConverters(dc, converters);

        final Query q = dc.query().from(table).select("foo").toQuery();
        assertEquals("SELECT table.foo FROM schema.table", q.toSql());
        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        assertEquals(1, ds.getRow().getValue(0));
        assertTrue(ds.next());
        assertEquals(2, ds.getRow().getValue(0));
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    dc = Converters.addTypeConverter(dc, fooColumn,
        new StringToIntegerConverter());

    Table table = dc.getDefaultSchema().getTableByName("table");
    Query query = dc.query().from(table).select(table.getColumns())
        .toQuery();
    assertEquals("SELECT table.foo, table.bar FROM schema.table",
        query.toSql());

    DataSet ds = dc.executeQuery(query);
    assertEquals(ConvertedDataSet.class, ds.getClass());

    assertTrue(ds.next());
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
        ds.getRow().toString());
    assertFalse(ds.next());
    ds.close();

    // perform a constrained query
    Query q = dc.query().from(table).select("row_id").and("/groupId")
        .where("/scope").isNotNull().toQuery();
    q.setMaxRows(2);
    ds = dc.executeQuery(q);

    assertTrue(ds.next());
    assertEquals("Row[values=[0, joda-time]]", ds.getRow().toString());
    assertTrue(ds.next());
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
      Column orgId = organizationTable.getColumnByName("row_id");
      assertNotNull(orgId);
      Column orgName = organizationTable.getColumnByName("/name");
      assertNotNull(orgName);

      Query q = dc.query().from(employeeTable)
          .innerJoin(organizationTable).on(fk, orgId).select(empName)
          .as("employee").select(orgName).as("company").toQuery();

      assertEquals(
          "SELECT /employee./name AS employee, /organization./name AS company "
              + "FROM /root./employee INNER JOIN /root./organization "
              + "ON /employee.index(/root/organization) = /organization.row_id",
          q.toSql());

      DataSet ds = dc.executeQuery(q);
      assertTrue(ds.next());
      assertEquals("Row[values=[John Doe, Company A]]", ds.getRow()
          .toString());
View Full Code Here
152
153
154
155
156
157
158
159
     * {@inheritDoc}
     */
    @Override
    public Query parseQuery(final String queryString) throws MetaModelException {
        final QueryParser parser = new QueryParser(this, queryString);
        final Query query = parser.parse();
        return query;
    }
View Full Code Here
166
167
168
169
170
171
172
173
174
    @Override
    public DataSet executeQuery(CompiledQuery compiledQuery, Object... values) {
        assert compiledQuery instanceof DefaultCompiledQuery;

        final DefaultCompiledQuery defaultCompiledQuery = (DefaultCompiledQuery) compiledQuery;
        final Query query = defaultCompiledQuery.cloneWithParameterValues(values);

        return executeQuery(query);
    }
View Full Code Here
176
177
178
179
180
181
182
183
184
    /**
     * {@inheritDoc}
     */
    @Override
    public final DataSet executeQuery(final String queryString) throws MetaModelException {
        final Query query = parseQuery(queryString);
        final DataSet dataSet = executeQuery(query);
        return dataSet;
    }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
            System.err.println(getInvalidConfigurationMessage());
            return;
        }
        dataContext = new SugarCrmDataContext(BASE_URL + "/", getUsername(), getPassword(), "Test");

        Query query = dataContext.query().from("Employees").select("id", "name").toQuery();
        query.setMaxRows(3);
        final DataSet ds = dataContext.executeQuery(query);

        assertNotNull(ds);
        assertTrue(ds instanceof MaxRowsDataSet);
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
        if (!result && _queryIterator.hasNext()) {
            if (_currentDataSet != null) {
                logger.debug("currentDataSet.close()");
                _currentDataSet.close();
            }
            Query q = _queryIterator.next();
            _currentDataSet = _dataContext.executeQuery(q);
            if (logger.isDebugEnabled()) {
                _queryIndex++;
                logger.debug("Executing query #{}", _queryIndex);
            }
View Full Code Here
TOP

Related Classes of org.apache.metamodel.query.Query

  • org.apache.metamodel.AbstractDataContext
  • org.apache.metamodel.CompositeDataContextTest
  • org.apache.metamodel.CompositeQueryDelegate
  • org.apache.metamodel.convert.ConvertedDataSetInterceptorTest
  • org.apache.metamodel.convert.Converters
  • org.apache.metamodel.convert.ConvertersTest
  • org.apache.metamodel.csv.CsvBigFileMemoryTest
  • org.apache.metamodel.csv.CsvDataContextTest
  • org.apache.metamodel.DB2Test
  • org.apache.metamodel.dbmains.PostgresqlMain
    • 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.