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*/23 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. Hide All
  2. Show all
  1. SQLTemplateParser
  2. LogSupport
  3. JavaTokenParsers
  4. RegexParsers
  5. Parsers
  6. AnyRef
  7. Any
Visibility
  1. Public
  2. All

Type Members

  1. type Elem = Char

    Definition Classes
    RegexParsers → Parsers
  2. type Input = Reader[Elem]

    Definition Classes
    Parsers

Value Members

  1. def != (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  2. def != (arg0: Any): Boolean

    Attributes
    final
    Definition Classes
    Any
  3. def ## (): Int

    Attributes
    final
    Definition Classes
    AnyRef → Any
  4. def == (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  5. def == (arg0: Any): Boolean

    Attributes
    final
    Definition Classes
    Any
  6. def OnceParser [T] (f: (Input) ⇒ ParseResult[T]): Parser[T] with OnceParser[T]

    Definition Classes
    Parsers
  7. def Parser [T] (f: (Input) ⇒ ParseResult[T]): Parser[T]

    Definition Classes
    Parsers
  8. def accept [U] (expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers
  9. def accept [ES] (es: ES)(implicit arg0: (ES) ⇒ List[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers
  10. implicit def accept (e: Elem): Parser[Elem]

    Attributes
    implicit
    Definition Classes
    Parsers
  11. def acceptIf (p: (Elem) ⇒ Boolean)(err: (Elem) ⇒ String): Parser[Elem]

    Definition Classes
    Parsers
  12. def acceptMatch [U] (expected: String, f: PartialFunction[Elem, U]): Parser[U]

    Definition Classes
    Parsers
  13. def acceptSeq [ES] (es: ES)(implicit arg0: (ES) ⇒ Iterable[Elem]): Parser[List[Elem]]

    Definition Classes
    Parsers
  14. def asInstanceOf [T0] : T0

    Attributes
    final
    Definition Classes
    Any
  15. def chainl1 [T, U] (first: ⇒ Parser[T], p: ⇒ Parser[U], q: ⇒ Parser[(T, U) ⇒ T]): Parser[T]

    Definition Classes
    Parsers
  16. def chainl1 [T] (p: ⇒ Parser[T], q: ⇒ Parser[(T, T) ⇒ T]): Parser[T]

    Definition Classes
    Parsers
  17. def chainr1 [T, U] (p: ⇒ Parser[T], q: ⇒ Parser[(T, U) ⇒ U], combine: (T, U) ⇒ U, first: U): Parser[U]

    Definition Classes
    Parsers
  18. def clone (): AnyRef

    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  19. def commit [T] (p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers
  20. 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

  21. def decimalNumber : Parser[String]

    Definition Classes
    JavaTokenParsers
  22. def elem (e: Elem): Parser[Elem]

    Definition Classes
    Parsers
  23. def elem (kind: String, p: (Elem) ⇒ Boolean): Parser[Elem]

    Definition Classes
    Parsers
  24. def eq (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  25. def equals (arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  26. def err (msg: String): Parser[Nothing]

    Definition Classes
    Parsers
  27. 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

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

    Definition Classes
    Parsers
  29. def finalize (): Unit

    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  30. def floatingPointNumber : Parser[String]

    Definition Classes
    JavaTokenParsers
  31. def getClass (): java.lang.Class[_]

    Attributes
    final
    Definition Classes
    AnyRef → Any
  32. def guard [T] (p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    Parsers
  33. def handleWhiteSpace (source: CharSequence, offset: Int): Int

    Attributes
    protected
    Definition Classes
    RegexParsers
  34. def hashCode (): Int

    Definition Classes
    AnyRef → Any
  35. def ident : Parser[String]

    Definition Classes
    JavaTokenParsers
  36. def isInstanceOf [T0] : Boolean

    Attributes
    final
    Definition Classes
    Any
  37. var lastNoSuccess : NoSuccess

    Definition Classes
    Parsers
  38. implicit def literal (s: String): Parser[String]

    Attributes
    implicit
    Definition Classes
    RegexParsers
  39. def log [T] (p: ⇒ Parser[T])(name: String): Parser[T]

    Definition Classes
    Parsers
  40. val log : Log

    Logger

    Logger

    Attributes
    protected
    Definition Classes
    LogSupport
  41. def mkList [T] : (~[T, List[T]]) ⇒ List[T]

    Definition Classes
    Parsers
  42. def ne (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  43. def not [T] (p: ⇒ Parser[T]): Parser[Unit]

    Definition Classes
    Parsers
  44. def notify (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
  45. def notifyAll (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
  46. def opt [T] (p: ⇒ Parser[T]): Parser[Option[T]]

    Definition Classes
    Parsers
  47. def parse [T] (p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers
  48. def parse [T] (p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers
  49. def parse [T] (p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers
  50. def parseAll [T] (p: Parser[T], in: CharSequence): ParseResult[T]

    Definition Classes
    RegexParsers
  51. def parseAll [T] (p: Parser[T], in: Reader): ParseResult[T]

    Definition Classes
    RegexParsers
  52. def parseAll [T] (p: Parser[T], in: Reader[Char]): ParseResult[T]

    Definition Classes
    RegexParsers
  53. def phrase [T] (p: Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers
  54. def positioned [T <: Positional] (p: ⇒ Parser[T]): Parser[T]

    Definition Classes
    RegexParsers → Parsers
  55. implicit def regex (r: Regex): Parser[String]

    Attributes
    implicit
    Definition Classes
    RegexParsers
  56. def rep [T] (p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers
  57. def rep1 [T] (first: ⇒ Parser[T], p0: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers
    Annotations
    @migration
    Migration

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

    Definition Classes
    Parsers
  59. def rep1sep [T] (p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers
  60. def repN [T] (num: Int, p: ⇒ Parser[T]): Parser[List[T]]

    Definition Classes
    Parsers
  61. def repsep [T] (p: ⇒ Parser[T], q: ⇒ Parser[Any]): Parser[List[T]]

    Definition Classes
    Parsers
  62. def skipWhitespace : Boolean

    Definition Classes
    RegexParsers
  63. def stringLiteral : Parser[String]

    Definition Classes
    JavaTokenParsers
  64. def success [T] (v: T): Parser[T]

    Definition Classes
    Parsers
  65. def synchronized [T0] (arg0: ⇒ T0): T0

    Attributes
    final
    Definition Classes
    AnyRef
  66. def toString (): String

    Definition Classes
    AnyRef → Any
  67. def trimComments (input: String): String

    Trims comments

    Trims comments

    input

    SQL tempalte

    returns

    SQL template without comments

  68. def wait (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()
  69. def wait (arg0: Long, arg1: Int): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()
  70. def wait (arg0: Long): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()
  71. val whiteSpace : Regex

    Attributes
    protected
    Definition Classes
    RegexParsers
  72. 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