Examples of org.apache.metamodel.query.QueryParameter

org.apache.metamodel.query.QueryParameter
Represents a query parameter, in SQL represented with a '?' symbol. Parameters are values in the query that will be defined at execution time, not parsing/preparation time. @see CompiledQuery @see DataContext#compileQuery(Query)

        data.close();
    }


    public void testCompiledQueryParameterInWhereClause() throws Exception {
        DataContext dc = getDataContext();
        QueryParameter param1 = new QueryParameter();
        CompiledQuery compiledQuery = dc.query().from(table1).select("name").where(COLUMN_CONTRIBUTOR_COUNTRY)
                .eq(param1).compile();
        try {
            assertEquals(1, compiledQuery.getParameters().size());
            assertSame(param1, compiledQuery.getParameters().get(0));

View Full Code Here

    }


    public void testCompiledQueryParameterInSubQuery() throws Exception {
        final DataContext dc = getDataContext();


        final QueryParameter param1 = new QueryParameter();
        final Query subQuery = dc.query().from(table1).select("name").where(COLUMN_CONTRIBUTOR_COUNTRY).eq(param1)
                .toQuery();


        final FromItem subQueryFromItem = new FromItem(subQuery);
        final Query query = new Query().select(new SelectItem(subQuery.getSelectClause().getItem(0), subQueryFromItem))

View Full Code Here

        Connection connection = getTestDbConnection();
        JdbcDataContext dataContext = new JdbcDataContext(connection,
                new TableType[] { TableType.TABLE, TableType.VIEW }, null);
        Schema schema = dataContext.getSchemaByName(dataContext.getDefaultSchemaName());


        QueryParameter queryParameter = new QueryParameter();


        Query q = new Query();
        Table table = schema.getTables()[0];
        q.select(table.getColumns());
        q.from(table, "a");

View Full Code Here


        final JdbcDataContext dataContext = new JdbcDataContext(ds,
                new TableType[] { TableType.TABLE, TableType.VIEW }, null);


        final JdbcCompiledQuery compiledQuery = (JdbcCompiledQuery) dataContext.query().from("CUSTOMERS")
                .select("CUSTOMERNAME").where("CUSTOMERNUMBER").eq(new QueryParameter()).compile();


        assertEquals(0, compiledQuery.getActiveLeases());
        assertEquals(0, compiledQuery.getIdleLeases());


        final String compliedQueryString = compiledQuery.toSql();

View Full Code Here

      }
      if (!inlineValues) {
        if (isPreparedParameterCandidate(whereItem)) {
          // replace operator with parameter
          whereItem = new FilterItem(whereItem.getSelectItem(),
              whereItem.getOperator(), new QueryParameter());
        }
      }
      final String whereItemLabel = queryRewriter
          .rewriteFilterItem(whereItem);
      sb.append(whereItemLabel);

View Full Code Here

      }
      if (!inlineValues) {
        if (isPreparedParameterCandidate(whereItem)) {
          // replace operator with parameter
          whereItem = new FilterItem(whereItem.getSelectItem(),
              whereItem.getOperator(), new QueryParameter());
        }
      }
      final String whereItemLabel = queryRewriter
          .rewriteFilterItem(whereItem);
      sb.append(whereItemLabel);

View Full Code Here

        Connection connection = getTestDbConnection();
        JdbcDataContext dataContext = new JdbcDataContext(connection,
                new TableType[] { TableType.TABLE, TableType.VIEW }, null);
        Schema schema = dataContext.getSchemaByName(dataContext.getDefaultSchemaName());


        QueryParameter queryParameter = new QueryParameter();


        Query q = new Query();
        Table table = schema.getTables()[0];
        q.select(table.getColumns());
        q.from(table, "a");

View Full Code Here

        data.close();
    }


    public void testCompiledQueryParameterInWhereClause() throws Exception {
        DataContext dc = getDataContext();
        QueryParameter param1 = new QueryParameter();
        CompiledQuery compiledQuery = dc.query().from(table1).select("name").where(COLUMN_CONTRIBUTOR_COUNTRY)
                .eq(param1).compile();
        try {
            assertEquals(1, compiledQuery.getParameters().size());
            assertSame(param1, compiledQuery.getParameters().get(0));

View Full Code Here

    }


    public void testCompiledQueryParameterInSubQuery() throws Exception {
        final DataContext dc = getDataContext();


        final QueryParameter param1 = new QueryParameter();
        final Query subQuery = dc.query().from(table1).select("name").where(COLUMN_CONTRIBUTOR_COUNTRY).eq(param1)
                .toQuery();


        final FromItem subQueryFromItem = new FromItem(subQuery);
        final Query query = new Query().select(new SelectItem(subQuery.getSelectClause().getItem(0), subQueryFromItem))

View Full Code Here

TOP

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

org.apache.metamodel.jdbc.JdbcDataContextTest

org.apache.metamodel.jdbc.JdbcUtils

org.apache.metamodel.QueryPostprocessDataContextTest

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.