List of quoteIdentifier() Examples

Examples of quoteIdentifier()

de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor.quoteIdentifier()
Handles special characters in identifiers. SQL 92 puts identifiers in double quotes, but MySQL uses backticks. @param identifier An identifier, such as a table or column name @return Quoted form of the identifier for use in SQL statements
mondrian.spi.Dialect.quoteIdentifier()
Encloses an identifier in quotation marks appropriate for this Dialect.
For example, quoteIdentifier("emp") yields a string containing "emp" in Oracle, and a string containing [emp] in Access. @param val Identifier @return Quoted identifier
org.eigenbase.sql.SqlDialect.quoteIdentifier()
Encloses an identifier in quotation marks appropriate for the current SQL dialect.
For example, quoteIdentifier("emp") yields a string containing "emp" in Oracle, and a string containing [emp] in Access. @param val Identifier to quote @return Quoted identifier

Examples of de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor.quoteIdentifier()

    Vendor db = Vendor.MySQL;
    assertEquals("`a`", db.quoteIdentifier("a"));
    assertEquals("````", db.quoteIdentifier("`"));
    assertEquals("`\\\\`", db.quoteIdentifier("\\"));
    assertEquals("`Joe``s`", db.quoteIdentifier("Joe`s"));
    assertEquals("`\\\\``\\\\``\\\\`", db.quoteIdentifier("\\`\\`\\"));
    assertEquals("`'`", db.quoteIdentifier("'"));
  }


  public void testAttributeQuoting() {
    Vendor db = Vendor.SQL92;

View Full Code Here

Examples of de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor.quoteIdentifier()

    assertEquals("`a`", db.quoteIdentifier("a"));
    assertEquals("````", db.quoteIdentifier("`"));
    assertEquals("`\\\\`", db.quoteIdentifier("\\"));
    assertEquals("`Joe``s`", db.quoteIdentifier("Joe`s"));
    assertEquals("`\\\\``\\\\``\\\\`", db.quoteIdentifier("\\`\\`\\"));
    assertEquals("`'`", db.quoteIdentifier("'"));
  }


  public void testAttributeQuoting() {
    Vendor db = Vendor.SQL92;
    assertEquals("\"schema\".\"table\".\"column\"",

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

            final String alias = "d" + i;
            innerSqlQuery.addSelect(expr, alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            final String quotedAlias = dialect.quoteIdentifier(alias);
            outerSqlQuery.addSelectGroupBy(quotedAlias);
        }


        // add predicates not associated with columns
        extraPredicates(innerSqlQuery);

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

                innerSqlQuery.addGroupBy(expr, alias);
            }
            outerSqlQuery.addSelect(
                measure.getAggregator().getNonDistinctAggregator()
                    .getExpression(
                    dialect.quoteIdentifier(alias)));
        }
        outerSqlQuery.addFrom(innerSqlQuery, "dummyname", true);
    }


    /**

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

                    ((RolapSchema) connection.getSchema()).getDialect();
                // FIXME: Include schema name, if specified.
                // FIXME: Deal with relations that are not tables.
                final StringBuilder buf = new StringBuilder();
                buf.append("SELECT * FROM ");
                dialect.quoteIdentifier(buf, tableName);
                buf.append(" WHERE 1=2");
                String sql = buf.toString();
                ResultSet rs = stmt.executeQuery(sql);
                ResultSetMetaData rsMeta = rs.getMetaData();
                for (int j = 1; j <= rsMeta.getColumnCount(); j++) {

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

                String orderBySql = sql.generateTopCountOrderBy(orderByExpr);
                Dialect dialect = sqlQuery.getDialect();
                boolean nullable = deduceNullability(orderByExpr);
                if (dialect.requiresOrderByAlias()) {
                    String alias = sqlQuery.nextColumnAlias();
                    alias = dialect.quoteIdentifier(alias);
                    sqlQuery.addSelect(orderBySql, alias);
                    sqlQuery.addOrderBy(alias, ascending, true, nullable);
                } else {
                    sqlQuery.addOrderBy(orderBySql, ascending, true, nullable);
                }

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

            String alias = "d" + i;
            alias = innerSqlQuery.addSelect(expr, null, alias);
            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            final String quotedAlias = dialect.quoteIdentifier(alias);
            outerSqlQuery.addSelectGroupBy(quotedAlias, null);
            // Add this alias to the map of grouping sets aliases
            groupingSetsAliases.put(
                expr,
                dialect.quoteIdentifier(

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

            final String quotedAlias = dialect.quoteIdentifier(alias);
            outerSqlQuery.addSelectGroupBy(quotedAlias, null);
            // Add this alias to the map of grouping sets aliases
            groupingSetsAliases.put(
                expr,
                dialect.quoteIdentifier(
                    "dummyname." + alias));
        }


        // add predicates not associated with columns
        extraPredicates(innerSqlQuery);

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

            if (databaseProduct == Dialect.DatabaseProduct.GREENPLUM) {
                innerSqlQuery.addGroupBy(expr, alias);
            }
            outerSqlQuery.addSelect(
                measure.getAggregator().getNonDistinctAggregator()
                    .getExpression(dialect.quoteIdentifier(alias)),
                measure.getInternalType());
        }
        outerSqlQuery.addFrom(innerSqlQuery, "dummyname", true);
        return groupingSetsAliases;
    }

View Full Code Here

Examples of mondrian.spi.Dialect.quoteIdentifier()

        boolean nullsLast) throws SQLException
    {
        Dialect dialect = getDialect();
        String query =
            "select "
            + dialect.quoteIdentifier("store_manager")
            + " from "
            + dialect.quoteIdentifier("store")
            + " order by "
            + dialect.generateOrderItem(
                dialect.quoteIdentifier("store_manager"),

View Full Code Here

0 1 2 3 4 5

TOP

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.