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 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(columns: (SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax, SQLSyntax), valueSeqs: Seq[(Any, Any, Any, Any, Any)]): SQLSyntax

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

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

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

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

41. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

42. def isNotNull(column: SQLSyntax): SQLSyntax

43. def isNull(column: SQLSyntax): SQLSyntax

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

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

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

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

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

49. def limit(n: Int): SQLSyntax

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

51. def max(column: SQLSyntax): SQLSyntax

52. def min(column: SQLSyntax): SQLSyntax

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

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

    Definition Classes

    AnyRef

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

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

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

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

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

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

61. final def notify(): Unit

    Definition Classes

    AnyRef

62. final def notifyAll(): Unit

    Definition Classes

    AnyRef

63. def offset(n: Int): SQLSyntax

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

65. def sum(column: SQLSyntax): SQLSyntax

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

    Definition Classes

    AnyRef

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

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

69. def toString(): String

    Definition Classes

    AnyRef → Any

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

71. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

74. def where(where: SQLSyntax): SQLSyntax

75. def where: SQLSyntax