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

Package de.fuberlin.wiwiss.d2rq.sql.vendor

Class de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor

Examples of de.fuberlin.wiwiss.d2rq.sql.vendor.Vendor.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

  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

    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

    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

    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

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.