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

   

   Definition Classes

   Any

7. val asc: SQLSyntax

   

8. def avg(column: SQLSyntax): SQLSyntax

   

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

   

10. def ceil(column: SQLSyntax): SQLSyntax

    

11. def ceiling(column: SQLSyntax): SQLSyntax

    

12. def clone(): AnyRef

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

13. def count(asteriskProvider: AsteriskProvider): SQLSyntax

    

14. def count(column: SQLSyntax): SQLSyntax

    

15. val count: SQLSyntax

    

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

    

    WARNING: Be aware of SQL injection vulnerability.

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

    

18. val currentDate: SQLSyntax

    

19. val currentTimestamp: SQLSyntax

    

20. val desc: SQLSyntax

    

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

    

22. val dual: SQLSyntax

    

23. val empty: SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef

26. def equals(arg0: Any): Boolean

    

    Definition Classes

    AnyRef → Any

27. def exists(sqlPart: SQLSyntax): SQLSyntax

    

28. def finalize(): Unit

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

29. def floor(column: SQLSyntax): SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef → Any

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

    

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

    

34. def hashCode(): Int

    

    Definition Classes

    AnyRef → Any

35. def having(condition: SQLSyntax): SQLSyntax

    

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

    

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

    

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

    

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

    

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

    

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

    

42. final def isInstanceOf[T0]: Boolean

    

    Definition Classes

    Any

43. def isNotNull(column: SQLSyntax): SQLSyntax

    

44. def isNull(column: SQLSyntax): SQLSyntax

    

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

    

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

    

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

    

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

    

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

    

50. def limit(n: Int): SQLSyntax

    

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

    

52. def max(column: SQLSyntax): SQLSyntax

    

53. def min(column: SQLSyntax): SQLSyntax

    

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

    

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

    

    Definition Classes

    AnyRef

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

    

57. def notExists(sqlPart: SQLSyntax): SQLSyntax

    

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

    

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

    

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

    

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

    

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

    

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

    

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

    

65. final def notify(): Unit

    

    Definition Classes

    AnyRef

66. final def notifyAll(): Unit

    

    Definition Classes

    AnyRef

67. def offset(n: Int): SQLSyntax

    

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

    

69. def sum(column: SQLSyntax): SQLSyntax

    

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

    

    Definition Classes

    AnyRef

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

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

73. def toString(): String

    

    Definition Classes

    AnyRef → Any

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

    

75. final def wait(): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

78. def where(where: SQLSyntax): SQLSyntax

    

79. val where: SQLSyntax