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. final def asInstanceOf[T0]: T0

   Definition Classes

   Any

9. val asc: SQLSyntax

10. def avg(column: SQLSyntax): SQLSyntax

11. def between(column: SQLSyntax, a: Any, b: Any): SQLSyntax

12. def ceil(column: SQLSyntax): SQLSyntax

13. def ceiling(column: SQLSyntax): SQLSyntax

14. def clone(): AnyRef

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

15. def count(asteriskProvider: AsteriskProvider): SQLSyntax

16. def count(column: SQLSyntax): SQLSyntax

17. val count: SQLSyntax

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

    WARNING: Be aware of SQL injection vulnerability.

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

20. val currentDate: SQLSyntax

21. val currentTimestamp: SQLSyntax

22. val desc: SQLSyntax

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

24. val dual: SQLSyntax

25. val empty: SQLSyntax

26. def eq(column: SQLSyntax, value: Any): SQLSyntax

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

    Definition Classes

    AnyRef

28. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

29. def exists(sqlPart: SQLSyntax): SQLSyntax

30. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

31. def floor(column: SQLSyntax): SQLSyntax

32. def ge(column: SQLSyntax, value: Any): SQLSyntax

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

    Definition Classes

    AnyRef → Any

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

35. def gt(column: SQLSyntax, value: Any): SQLSyntax

36. def hashCode(): Int

    Definition Classes

    AnyRef → Any

37. def having(condition: SQLSyntax): SQLSyntax

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

39. def in(columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any, Any)]): SQLSyntax

40. def in(columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any)]): SQLSyntax

41. def in(columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any)]): SQLSyntax

42. def in(columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any)]): SQLSyntax

43. def in(column: SQLSyntax, values: Seq[Any]): SQLSyntax

44. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

45. def isNotNull(column: SQLSyntax): SQLSyntax

46. def isNull(column: SQLSyntax): SQLSyntax

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

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

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

50. def le(column: SQLSyntax, value: Any): SQLSyntax

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

52. def limit(n: Int): SQLSyntax

53. def lt(column: SQLSyntax, value: Any): SQLSyntax

54. def max(column: SQLSyntax): SQLSyntax

55. def min(column: SQLSyntax): SQLSyntax

56. def ne(column: SQLSyntax, value: Any): SQLSyntax

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

    Definition Classes

    AnyRef

58. def notBetween(column: SQLSyntax, a: Any, b: Any): SQLSyntax

59. def notExists(sqlPart: SQLSyntax): SQLSyntax

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

61. def notIn(columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any, Any)]): SQLSyntax

62. def notIn(columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any)]): SQLSyntax

63. def notIn(columns: (SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any)]): SQLSyntax

64. def notIn(columns: (SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any)]): SQLSyntax

65. def notIn(column: SQLSyntax, values: Seq[Any]): SQLSyntax

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

67. final def notify(): Unit

    Definition Classes

    AnyRef

68. final def notifyAll(): Unit

    Definition Classes

    AnyRef

69. def offset(n: Int): SQLSyntax

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

71. def sum(column: SQLSyntax): SQLSyntax

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

    Definition Classes

    AnyRef

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

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

75. def toString(): String

    Definition Classes

    AnyRef → Any

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

77. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

80. def where(where: SQLSyntax): SQLSyntax

81. val where: SQLSyntax