Object

scalikejdbc

SQLTemplateParser

Related Doc: package scalikejdbc

Permalink

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.

Source
SQLTemplateParser.scala
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
Visibility
  1. Public
  2. All

Type Members

  1. type Elem = Char

    Permalink
    Definition Classes
    RegexParsers → Parsers

  2. case class Error extends NoSuccess with Product with Serializable

    Permalink
    Definition Classes
    Parsers

  3. case class Failure extends NoSuccess with Product with Serializable

    Permalink
    Definition Classes
    Parsers

  4. type Input = Reader[Elem]

    Permalink
    Definition Classes
    Parsers

  5. sealed abstract class NoSuccess extends ParseResult[Nothing]

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

Value Members

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

    Permalink
    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any

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

    Permalink
    Definition Classes
    AnyRef → Any

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

  12. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

  16. def clone(): AnyRef

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

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

    Permalink
    Definition Classes
    Parsers

  18. def convertToSQLWithPlaceHolders(input: String): String

    Permalink

    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]

    Permalink
    Definition Classes
    JavaTokenParsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    AnyRef

  23. def equals(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink

    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]

    Permalink
    Definition Classes
    Parsers

  27. def finalize(): Unit

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

  28. def floatingPointNumber: Parser[String]

    Permalink
    Definition Classes
    JavaTokenParsers

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

    Permalink
    Definition Classes
    AnyRef → Any

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Attributes
    protected
    Definition Classes
    RegexParsers

  32. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any

  33. def ident: Parser[String]

    Permalink
    Definition Classes
    JavaTokenParsers

  34. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    Parsers

  37. val log: Log

    Permalink

    Logger

    Logger

    Attributes
    protected
    Definition Classes
    LogSupport

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    AnyRef

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

    Permalink
    Definition Classes
    Parsers

  41. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef

  42. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    RegexParsers → Parsers

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

    Permalink
    Definition Classes
    RegexParsers → Parsers

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

    Permalink
    Definition Classes
    RegexParsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    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]]

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    Parsers

  59. def skipWhitespace: Boolean

    Permalink
    Definition Classes
    RegexParsers

  60. def stringLiteral: Parser[String]

    Permalink
    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]

    Permalink
    Definition Classes
    Parsers

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

    Permalink
    Definition Classes
    AnyRef

  63. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any

  64. def trimComments(input: String): String

    Permalink

    Trims comments

    Trims comments

    input

    SQL tempalte

    returns

    SQL template without comments

  65. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  68. val whiteSpace: Regex

    Permalink
    Attributes
    protected
    Definition Classes
    RegexParsers

  69. def wholeNumber: Parser[String]

    Permalink
    Definition Classes
    JavaTokenParsers

Inherited from LogSupport

Inherited from JavaTokenParsers

Inherited from RegexParsers

Inherited from Parsers

Inherited from AnyRef

Inherited from Any

Ungrouped