SQLSyntax

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. val ?: SQLSyntax

   

5. def abs(column: SQLSyntax): SQLSyntax

   

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

   

7. def and(sqlPart: SQLSyntax): SQLSyntax

   

8. def and: SQLSyntax

   

9. final def asInstanceOf[T0]: T0

   

   Definition Classes

   Any

10. val asc: SQLSyntax

    

11. def avg(column: SQLSyntax): SQLSyntax

    

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

    

13. def ceil(column: SQLSyntax): SQLSyntax

    

14. def ceiling(column: SQLSyntax): SQLSyntax

    

15. def clone(): AnyRef

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

16. def count(asteriskProvider: AsteriskProvider): SQLSyntax

    

17. def count(column: SQLSyntax): SQLSyntax

    

18. val count: SQLSyntax

    

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

    

    WARNING: Be aware of SQL injection vulnerability.

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

    

21. val currentDate: SQLSyntax

    

22. val currentTimestamp: SQLSyntax

    

23. val desc: SQLSyntax

    

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

    

25. val dual: SQLSyntax

    

26. val empty: SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef

29. def equals(arg0: Any): Boolean

    

    Definition Classes

    AnyRef → Any

30. def exists(sqlPart: SQLSyntax): SQLSyntax

    

31. def finalize(): Unit

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

32. def floor(column: SQLSyntax): SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef → Any

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

    

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

    

37. def hashCode(): Int

    

    Definition Classes

    AnyRef → Any

38. def having(condition: SQLSyntax): SQLSyntax

    

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

    

40. 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

    

41. 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

    

42. 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

    

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

    

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

    

45. final def isInstanceOf[T0]: Boolean

    

    Definition Classes

    Any

46. def isNotNull(column: SQLSyntax): SQLSyntax

    

47. def isNull(column: SQLSyntax): SQLSyntax

    

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

    

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

    

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

    

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

    

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

    

53. def limit(n: Int): SQLSyntax

    

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

    

55. def max(column: SQLSyntax): SQLSyntax

    

56. def min(column: SQLSyntax): SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef

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

    

60. def notExists(sqlPart: SQLSyntax): SQLSyntax

    

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

    

62. 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

    

63. 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

    

64. 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

    

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

    

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

    

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

    

68. final def notify(): Unit

    

    Definition Classes

    AnyRef

69. final def notifyAll(): Unit

    

    Definition Classes

    AnyRef

70. def offset(n: Int): SQLSyntax

    

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

    

72. def or(sqlPart: SQLSyntax): SQLSyntax

    

73. def or: SQLSyntax

    

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

    

75. def roundBracket(inner: SQLSyntax): SQLSyntax

    

76. def sum(column: SQLSyntax): SQLSyntax

    

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

    

    Definition Classes

    AnyRef

78. 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")

79. 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")

80. def toString(): String

    

    Definition Classes

    AnyRef → Any

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

    

82. final def wait(): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

86. def where(where: SQLSyntax): SQLSyntax

    

87. val where: SQLSyntax