SQLSyntax

Value Members

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

   Definition Classes

   AnyRef

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

   Definition Classes

   Any

3. final def ##(): Int

   Definition Classes

   AnyRef → Any

4. final def ==(arg0: AnyRef): Boolean

   Definition Classes

   AnyRef

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

   Definition Classes

   Any

6. val ?: SQLSyntax

7. def abs(column: SQLSyntax): SQLSyntax

8. def and(andOpt: Option[SQLSyntax]): SQLSyntax

9. def and(sqlPart: SQLSyntax): SQLSyntax

10. def and: SQLSyntax

11. final def asInstanceOf[T0]: T0

    Definition Classes

    Any

12. val asc: SQLSyntax

13. def avg(column: SQLSyntax): SQLSyntax

14. def between[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax

15. def ceil(column: SQLSyntax): SQLSyntax

16. def ceiling(column: SQLSyntax): SQLSyntax

17. def clone(): AnyRef

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

18. def count(asteriskProvider: AsteriskProvider): SQLSyntax

19. def count(column: SQLSyntax): SQLSyntax

20. val count: SQLSyntax

21. def createUnsafely(value: String, parameters: Seq[Any] = Nil): SQLSyntax

    WARNING: Be aware of SQL injection vulnerability.

22. def csv(parts: SQLSyntax*): SQLSyntax

23. val currentDate: SQLSyntax

24. val currentTimestamp: SQLSyntax

25. val desc: SQLSyntax

26. def distinct(columns: SQLSyntax*): SQLSyntax

27. val dual: SQLSyntax

28. val empty: SQLSyntax

29. def eq[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

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

    Definition Classes

    AnyRef

31. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

32. def exists(sqlPart: SQLSyntax): SQLSyntax

33. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

34. def floor(column: SQLSyntax): SQLSyntax

35. def ge[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

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

    Definition Classes

    AnyRef → Any

37. def groupBy(columns: SQLSyntax*): SQLSyntax

38. def gt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

39. def hashCode(): Int

    Definition Classes

    AnyRef → Any

40. def having(condition: SQLSyntax): SQLSyntax

41. def in(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax

42. def in[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D], arg4: ParameterBinderFactory[E]): SQLSyntax

43. def in[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D]): SQLSyntax

44. def in[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C]): SQLSyntax

45. def in[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax

46. def in[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

47. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

48. def isNotNull(column: SQLSyntax): SQLSyntax

49. def isNull(column: SQLSyntax): SQLSyntax

50. def join(parts: Seq[SQLSyntax], delimiter: SQLSyntax, spaceBeforeDelimiter: Boolean = true): SQLSyntax

51. def joinWithAnd(parts: SQLSyntax*): SQLSyntax

52. def joinWithOr(parts: SQLSyntax*): SQLSyntax

53. def le[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

54. def like(column: SQLSyntax, value: String): SQLSyntax

55. def limit(n: Int): SQLSyntax

56. def lt[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

57. def max(column: SQLSyntax): SQLSyntax

58. def min(column: SQLSyntax): SQLSyntax

59. def ne[A](column: SQLSyntax, value: A)(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

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

    Definition Classes

    AnyRef

61. def notBetween[A, B](column: SQLSyntax, a: A, b: B)(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax

62. def notExists(sqlPart: SQLSyntax): SQLSyntax

63. def notIn(column: SQLSyntax, subQuery: SQLSyntax): SQLSyntax

64. def notIn[A, B, C, D, E](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D, E)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D], arg4: ParameterBinderFactory[E]): SQLSyntax

65. def notIn[A, B, C, D](columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C, D)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C], arg3: ParameterBinderFactory[D]): SQLSyntax

66. def notIn[A, B, C](columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B, C)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B], arg2: ParameterBinderFactory[C]): SQLSyntax

67. def notIn[A, B](columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(A, B)])(implicit arg0: ParameterBinderFactory[A], arg1: ParameterBinderFactory[B]): SQLSyntax

68. def notIn[A](column: SQLSyntax, values: Seq[A])(implicit arg0: ParameterBinderFactory[A]): SQLSyntax

69. def notLike(column: SQLSyntax, value: String): SQLSyntax

70. final def notify(): Unit

    Definition Classes

    AnyRef

71. final def notifyAll(): Unit

    Definition Classes

    AnyRef

72. def offset(n: Int): SQLSyntax

73. def or(orOpt: Option[SQLSyntax]): SQLSyntax

74. def or(sqlPart: SQLSyntax): SQLSyntax

75. def or: SQLSyntax

76. def orderBy(columns: SQLSyntax*): SQLSyntax

77. def roundBracket(inner: SQLSyntax): SQLSyntax

78. def sum(column: SQLSyntax): SQLSyntax

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

    Definition Classes

    AnyRef

80. def toAndConditionOpt(conditions: Option[SQLSyntax]*): Option[SQLSyntax]

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'and'.

    val (id, name) = (123, "Alice")
    val cond: Option[SQLSyntax] = SQLSyntax.toAndConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null"))
    cond.get.value // "id = ? and (name = ? or name is null)"
    cond.get.parameters // Seq(123, "Alice")

81. def toOrConditionOpt(conditions: Option[SQLSyntax]*): Option[SQLSyntax]

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.

    Returns an optional SQLSyntax which is flatten (from option array) and joined with 'or'.

    val (id, name) = (123, "Alice")
    val cond: Option[SQLSyntax] = SQLSyntax.toOrConditionOpt(Some(sqls"id = ${id}"), None, Some(sqls"name = ${name} or name is null"))
    cond.get.value // "id = ? or (name = ? or name is null)"
    cond.get.parameters // Seq(123, "Alice")

82. def toString(): String

    Definition Classes

    AnyRef → Any

83. def unapply(syntax: SQLSyntax): Option[(String, Seq[Any])]

84. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

87. def where(whereOpt: Option[SQLSyntax]): SQLSyntax

88. def where(where: SQLSyntax): SQLSyntax

89. val where: SQLSyntax