Package org.apache.metamodel.query

Examples of org.apache.metamodel.query.FromItem

88
89
90
91
92
93
94
95
96
    }

    protected String createSqlStatement() {
        StringBuilder sb = new StringBuilder();
        sb.append("DELETE FROM ");
        sb.append(_queryRewriter.rewriteFromItem(new FromItem(getTable())));
        sb.append(JdbcUtils.createWhereClause(getWhereItems(), _queryRewriter, _inlineValues));
        return sb.toString();
    }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    private String createSqlStatement(boolean inlineValues) {
        final Object[] values = getValues();
        final Table table = getTable();
        final StringBuilder sb = new StringBuilder();

        final String tableLabel = _queryRewriter.rewriteFromItem(new FromItem(table));

        sb.append("UPDATE ");
        sb.append(tableLabel);
        sb.append(" SET ");
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
282
        Schema schema = getExampleSchema();
        Table contributorTable = schema.getTableByName(TABLE_CONTRIBUTOR);
        Table projectTable = schema.getTableByName(TABLE_PROJECT);
        Table projectContributorTable = schema.getTableByName(TABLE_PROJECT_CONTRIBUTOR);

        FromItem sqFromItem = new FromItem(new Query().from(projectTable).from(projectContributorTable));
        FromItem fromItem = new FromItem(JoinType.INNER, new FromItem(contributorTable), sqFromItem, new SelectItem[0],
                new SelectItem[0]);
        Query q = new Query().from(fromItem);

        FromItem[] fromItems = MetaModelHelper.getTableFromItems(q);
        assertEquals(3, fromItems.length);
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
        }
    JdbcDataContext dataContext = getDataContext();
        Schema schema = dataContext.getDefaultSchema();
    Table departmentTable = schema.getTableByName("DEPARTMENT");
    Table employeeTable = schema.getTableByName("EMPLOYEE");
    Query q = new Query().from(new FromItem(JoinType.INNER, departmentTable.getRelationships(employeeTable)[0]));
    q.select(departmentTable.getColumns()[1]);
    q.select(new SelectItem(employeeTable.getColumns()[4]).setAlias("hire-date"));
    assertEquals(
        "SELECT \"DEPARTMENT\".\"DEPARTMENT\", \"EMPLOYEE\".\"HIRE_DATE\" AS hire-date FROM \"EMPLOYEE\" INNER JOIN \"DEPARTMENT\" ON \"EMPLOYEE\".\"EMP_NO\" = \"DEPARTMENT\".\"MNGR_NO\"",
        q.toString());
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
        Relationship relationship = employeeTable.getRelationships(departmentsTable)[0];
        assertEquals(
                "Relationship[primaryTable=EMPLOYEES,primaryColumns={EMPLOYEE_ID},foreignTable=DEPARTMENTS,foreignColumns={MANAGER_ID}]",
                relationship.toString());

        Query q = new Query().from(new FromItem(JoinType.INNER, relationship)).select(
                employeeTable.getColumnByName("EMAIL"), departmentsTable.getColumnByName("DEPARTMENT_NAME"));
        q.getSelectClause().getItem(0).setAlias("e-mail");

        assertEquals(
                "SELECT \"EMPLOYEES\".\"EMAIL\" AS e-mail, \"DEPARTMENTS\".\"DEPARTMENT_NAME\" FROM HR.\"EMPLOYEES\" INNER JOIN HR.\"DEPARTMENTS\" ON \"EMPLOYEES\".\"EMPLOYEE_ID\" = \"DEPARTMENTS\".\"MANAGER_ID\"",
View Full Code Here
31
32
33
34
35
36
37
38
    private FromItem fromItem;

    public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) {
        super(query, dataContext);

        fromItem = new FromItem(table);
        query.from(fromItem);
    }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
        JdbcDataContext dc = new JdbcDataContext(_connection);
        Schema schema = dc.getDefaultSchema();
        Table productsTable = schema.getTableByName("PRODUCTS");
        Table factTable = schema.getTableByName("ORDERFACT");

        Query q = new Query().from(new FromItem(JoinType.INNER, productsTable.getRelationships(factTable)[0])).select(
                productsTable.getColumns()[0], factTable.getColumns()[0]);
        assertEquals(
                "SELECT \"PRODUCTS\".\"PRODUCTCODE\", \"ORDERFACT\".\"ORDERNUMBER\" FROM PUBLIC.\"PRODUCTS\" INNER JOIN PUBLIC.\"ORDERFACT\" ON \"PRODUCTS\".\"PRODUCTCODE\" = \"ORDERFACT\".\"PRODUCTCODE\"",
                q.toString());
        assertEquals(25000, dc.getFetchSizeCalculator().getFetchSize(q));
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
    Relationship relationship = relationships[0];
    assertEquals(
        "Relationship[primaryTable=PRODUCTS,primaryColumns=[PRODUCTCODE],foreignTable=ORDERFACT,foreignColumns=[PRODUCTCODE]]",
        relationship.toString());

    Query q = new Query().from(new FromItem(JoinType.LEFT, relationship))
        .select(relationship.getForeignColumns())
        .select(relationship.getPrimaryColumns());
    assertEquals(
        "SELECT _ORDERFACT_._PRODUCTCODE_, _PRODUCTS_._PRODUCTCODE_ FROM PUBLIC._PRODUCTS_ LEFT JOIN PUBLIC._ORDERFACT_ ON _PRODUCTS_._PRODUCTCODE_ = _ORDERFACT_._PRODUCTCODE_",
        q.toString().replace('\"', '_'));
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
    sq.select(empSelectItem, custSelectItem);
    assertEquals(
        "SELECT e._EMPLOYEENUMBER_, c._CUSTOMERNUMBER_ FROM PUBLIC._EMPLOYEES_ e, PUBLIC._CUSTOMERS_ c",
        sq.toString().replace('\"', '_'));
    Query q = new Query();
    FromItem sqItem = new FromItem(sq).setAlias("sq");

    custSelectItem.setAlias("c_num");
    empSelectItem.setAlias("e_num");

    q.from(sqItem);
View Full Code Here
534
535
536
537
538
539
540
541
542
543
544
        }

        Query q = new Query();
        q.select(primaryColumns.toArray(new Column[primaryColumns.size()]));
        q.select(foreignColumns.toArray(new Column[foreignColumns.size()]));
        q.from(new FromItem(JoinType.LEFT, relationship));
        if (logger.isDebugEnabled()) {
            logger.debug("Setting table data for '{}' to query result: {}", primaryTableName, q.toString());
        }
        List<Object[]> tableRows = executeQuery(q).toObjectArrays();
View Full Code Here
TOP

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

  • org.apache.metamodel.dialects.PostgresqlQueryRewriterTest
  • org.apache.metamodel.dialects.SQLServerQueryRewriterTest
  • org.apache.metamodel.FirebirdTest
  • org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter
  • org.apache.metamodel.jdbc.dialects.DB2QueryRewriter
  • org.apache.metamodel.jdbc.HsqldbTest
  • org.apache.metamodel.jdbc.integrationtests.FirebirdTest
  • org.apache.metamodel.jdbc.integrationtests.MysqlTest
  • org.apache.metamodel.jdbc.integrationtests.OracleTest
  • org.apache.metamodel.jdbc.JdbcDeleteBuilder
    • 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.