scalikejdbc

SQLTemplateParser

object SQLTemplateParser extends JavaTokenParsers with LogSupport

SQL Template Parser.

This parser supports following templates.

Basic SQL Template:

select * from user where id = ? and user_name = ?

Anorm-like SQL Template:

select * from user where id = {id} and user_name = {userName}

Executable SQL Template:

select * from user where id = /*'id*/123 and user_name = /*'userName*/\'Alice'

ExecutableSQL is the template which contains parameter names just as comments with dummy values without specific syntax. The template is a valid SQL, so you can check it is correct before building into app.

Linear Supertypes
LogSupport, JavaTokenParsers, RegexParsers, Parsers, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SQLTemplateParser
  2. LogSupport
  3. JavaTokenParsers
  4. RegexParsers
  5. Parsers
  6. AnyRef
  7. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Type Members

  1. type Elem = Char

    Definition Classes
    RegexParsers → Parsers

  2. case class Error extends NoSuccess with Product with Serializable

    Definition Classes
    Parsers

  3. case class Failure extends NoSuccess with Product with Serializable

    Definition Classes
    Parsers

  4. type Input = Reader[Elem]

    Definition Classes
    Parsers

  5. sealed abstract class NoSuccess extends ParseResult[Nothing]

    Definition Classes
    Parsers

  6. trait OnceParser[+T] extends Parser[T]

    Definition Classes
    Parsers

  7. sealed abstract class ParseResult[+T] extends AnyRef

    Definition Classes
    Parsers

  8. abstract class Parser[+T] extends (Input) ⇒ ParseResult[T]

    Definition Classes
    Parsers

  9. case class Success[+T] extends ParseResult[T] with Product with Serializable

    Definition Classes
    Parsers

  10. case class ~[+a, +b] extends Product with Serializable

    Definition Classes
    Parsers

Value Members

  1. final def !=(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Definition Classes
    AnyRef → Any

  3. final def ==(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  4. def OnceParser[T](f: (Input) ⇒ ParseResult[T]): Parser[T] with OnceParser[T]

    Definition Classes
    Parsers

  5. def Parser[T](f: (Input) ⇒ ParseResult[T]): Parser[T]

    Definition Classes
    Parsers

  6. def accept[U](expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers

  7. def accept[ES](es: ES)(implicit arg0: (ES) ⇒ List[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers

  8. implicit def accept(e: Elem): Parser[Elem]

    Definition Classes
    Parsers

  9. def acceptIf(p: (Elem) ⇒ Boolean)(err: (Elem) ⇒ String): Parser[Elem]

    Definition Classes
    Parsers

  10. def acceptMatch[U](expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers

  11. def acceptSeq[ES](es: ES)(implicit arg0: (ES) ⇒ Iterable[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers

  12. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  13. def chainl1[T, U](first: ⇒ Parser[T], p: ⇒ Parser[U], q: ⇒ Parser[(T, U) ⇒ T]): Parser[T]

    Definition Classes
    Parsers

  14. def chainl1[T](p: ⇒ Parser[T], q: ⇒ Parser[(T, T) ⇒ T]): Parser[T]

    Definition Classes
    Parsers

  15. def chainr1[T, U](p: ⇒ Parser[T], q: ⇒ Parser[(T, U) ⇒ U], combine: (T, U) ⇒ U, first: U): Parser[U]

    Definition Classes
    Parsers

  16. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  17. def commit[T](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers

  18. def convertToSQLWithPlaceHolders(input: String): String

    Converts the SQL template to SQL template with place holders.

    Converts the SQL template to SQL template with place holders.

    input

    input SQL

    returns

    simplified SQL

  19. def decimalNumber: Parser[String]

    Definition Classes
    JavaTokenParsers

  20. def elem(e: Elem): Parser[Elem]

    Definition Classes
    Parsers

  21. def elem(kind: String, p: (Elem) ⇒ Boolean): Parser[Elem]

    Definition Classes
    Parsers

  22. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  23. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  24. def err(msg: String): Parser[Nothing]

    Definition Classes
    Parsers

  25. def extractAllParameters(input: String): List[Symbol]

    Extracts binding names from the SQL template.

    Extracts binding names from the SQL template.

    input

    input SQL

    returns

    extracted parameter names

  26. def failure(msg: String): Parser[Nothing]

    Definition Classes
    Parsers

  27. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  28. def floatingPointNumber: Parser[String]

    Definition Classes
    JavaTokenParsers

  29. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any

  30. def guard[T](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers

  31. def handleWhiteSpace(source: CharSequence, offset: Int): Int

    Attributes
    protected
    Definition Classes
    RegexParsers

  32. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  33. def ident: Parser[String]

    Definition Classes
    JavaTokenParsers

  34. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  35. implicit def literal(s: String): Parser[String]

    Definition Classes
    RegexParsers

  36. def log[T](p: ⇒ Parser[T])(name: String): Parser[T]

    Definition Classes
    Parsers

  37. val log: Log

    Logger

    Logger

    Attributes
    protected
    Definition Classes
    LogSupport

  38. def mkList[T]: (~[T, List[T]]) ⇒ List[T]

    Definition Classes
    Parsers

  39. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  40. def not[T](p: ⇒ Parser[T]): Parser[Unit]

    Definition Classes
    Parsers

  41. final def notify(): Unit

    Definition Classes
    AnyRef

  42. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  43. def opt[T](p: ⇒ Parser[T]): Parser[Option[T]]

    Definition Classes
    Parsers

  44. def parse[T](p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers

  45. def parse[T](p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers

  46. def parse[T](p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers

  47. def parseAll[T](p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers

  48. def parseAll[T](p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers

  49. def parseAll[T](p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers

  50. def phrase[T](p: Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers

  51. def positioned[T <: Positional](p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers

  52. implicit def regex(r: Regex): Parser[String]

    Definition Classes
    RegexParsers

  53. def rep[T](p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  54. def rep1[T](first: ⇒ Parser[T], p0: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers
    Annotations
    @migration
    Migration

    (Changed in version 2.9.0) The p0 call-by-name arguments is evaluated at most once per constructed Parser object, instead of on every need that arises during parsing.

  55. def rep1[T](p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  56. def rep1sep[T](p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers

  57. def repN[T](num: Int, p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers

  58. def repsep[T](p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers

  59. def skipWhitespace: Boolean

    Definition Classes
    RegexParsers

  60. def stringLiteral: Parser[String]

    Definition Classes
    JavaTokenParsers
    Annotations
    @migration
    Migration

    (Changed in version 2.10.0) stringLiteral allows escaping single and double quotes, but not forward slashes any longer.

  61. def success[T](v: T): Parser[T]

    Definition Classes
    Parsers

  62. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef

  63. def toString(): String

    Definition Classes
    AnyRef → Any

  64. def trimComments(input: String): String

    Trims comments

    Trims comments

    input

    SQL tempalte

    returns

    SQL template without comments

  65. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  66. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  67. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  68. val whiteSpace: Regex

    Attributes
    protected
    Definition Classes
    RegexParsers

  69. def wholeNumber: Parser[String]

    Definition Classes
    JavaTokenParsers

Inherited from LogSupport

Inherited from JavaTokenParsers

Inherited from RegexParsers

Inherited from Parsers

Inherited from AnyRef

Inherited from Any

Ungrouped