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

7. def abs(column: SQLSyntax): SQLSyntax

8. final def asInstanceOf[T0]: T0

   Definition Classes

   Any

9. def 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. def 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. def currentDate: SQLSyntax

21. def currentTimestamp: SQLSyntax

22. def desc: SQLSyntax

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

24. def dual: SQLSyntax

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

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

    Definition Classes

    AnyRef

27. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

28. def exists(sqlPart: SQLSyntax): SQLSyntax

29. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

30. def floor(column: SQLSyntax): SQLSyntax

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

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

    Definition Classes

    AnyRef → Any

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

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

35. def hashCode(): Int

    Definition Classes

    AnyRef → Any

36. def having(condition: SQLSyntax): SQLSyntax

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

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

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

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

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

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

43. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

44. def isNotNull(column: SQLSyntax): SQLSyntax

45. def isNull(column: SQLSyntax): SQLSyntax

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

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

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

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

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

51. def limit(n: Int): SQLSyntax

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

53. def max(column: SQLSyntax): SQLSyntax

54. def min(column: SQLSyntax): SQLSyntax

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

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

    Definition Classes

    AnyRef

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]

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

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

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

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

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

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

    val cond: Option[SQLSyntax] = SQLSyntax.toOrConditionOpt(Some(sqls"id = $id"), None, Some(sqls"name = $name"))
    cond.get.statement // "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. def where: SQLSyntax