List of quoteStringLiteral() Examples

Examples of quoteStringLiteral()

de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor.quoteStringLiteral()
Handles special characters in strings. Most databases wrap the string in single quotes, and escape single quotes by doubling them. Some databases also require doubling of backslashes. @param s An arbitrary character string @return A quoted and escaped version safe for use in SQL statements
mondrian.spi.Dialect.quoteStringLiteral()
Appends to a buffer a single-quoted SQL string.
For example, in the default dialect, quoteStringLiteral(buf, "Can't") appends "'Can''t'" to buf. @param buf Buffer to append to @param s Literal

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

  public void testSingleQuoteEscape() {
    Vendor vendor = Vendor.SQL92;
    assertEquals("'a'", vendor.quoteStringLiteral("a"));
    assertEquals("''''", vendor.quoteStringLiteral("'"));
    assertEquals("'\\'", vendor.quoteStringLiteral("\\"));
    assertEquals("'Joe''s'", vendor.quoteStringLiteral("Joe's"));
    assertEquals("'\\''\\''\\'", vendor.quoteStringLiteral("\\'\\'\\"));
    assertEquals("'\"'", vendor.quoteStringLiteral("\""));
    assertEquals("'`'", vendor.quoteStringLiteral("`"));
  }

View Full Code Here

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

    Vendor vendor = Vendor.SQL92;
    assertEquals("'a'", vendor.quoteStringLiteral("a"));
    assertEquals("''''", vendor.quoteStringLiteral("'"));
    assertEquals("'\\'", vendor.quoteStringLiteral("\\"));
    assertEquals("'Joe''s'", vendor.quoteStringLiteral("Joe's"));
    assertEquals("'\\''\\''\\'", vendor.quoteStringLiteral("\\'\\'\\"));
    assertEquals("'\"'", vendor.quoteStringLiteral("\""));
    assertEquals("'`'", vendor.quoteStringLiteral("`"));
  }


  public void testQuoteIdentifierEscape() {

View Full Code Here

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

    assertEquals("'a'", vendor.quoteStringLiteral("a"));
    assertEquals("''''", vendor.quoteStringLiteral("'"));
    assertEquals("'\\'", vendor.quoteStringLiteral("\\"));
    assertEquals("'Joe''s'", vendor.quoteStringLiteral("Joe's"));
    assertEquals("'\\''\\''\\'", vendor.quoteStringLiteral("\\'\\'\\"));
    assertEquals("'\"'", vendor.quoteStringLiteral("\""));
    assertEquals("'`'", vendor.quoteStringLiteral("`"));
  }


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

View Full Code Here

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

    assertEquals("''''", vendor.quoteStringLiteral("'"));
    assertEquals("'\\'", vendor.quoteStringLiteral("\\"));
    assertEquals("'Joe''s'", vendor.quoteStringLiteral("Joe's"));
    assertEquals("'\\''\\''\\'", vendor.quoteStringLiteral("\\'\\'\\"));
    assertEquals("'\"'", vendor.quoteStringLiteral("\""));
    assertEquals("'`'", vendor.quoteStringLiteral("`"));
  }


  public void testQuoteIdentifierEscape() {
    Vendor db = Vendor.SQL92;
    assertEquals("\"a\"", db.quoteIdentifier("a"));

View Full Code Here

Examples of mondrian.spi.Dialect.quoteStringLiteral()

                + " group by "
                + dialect.quoteIdentifier("customer", "fname")
                + " having "
                + dialect.quoteIdentifier("customer", "fname")
                + " LIKE ");
        dialect.quoteStringLiteral(sb, "%");
        if (!dialect.requiresHavingAlias()) {
            final ResultSet resultSet =
                getConnection().createStatement().executeQuery(sb.toString());
            assertTrue(resultSet.next());
            resultSet.close();

View Full Code Here

0 1

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.