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

5. def abs(column: SQLSyntax): SQLSyntax

6. final def asInstanceOf[T0]: T0

   Definition Classes

   Any

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

19. def currentTimestamp: SQLSyntax

20. def desc: SQLSyntax

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

22. def dual: SQLSyntax

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

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

    Definition Classes

    AnyRef

25. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

26. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

27. def floor(column: SQLSyntax): SQLSyntax

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

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

    Definition Classes

    AnyRef → Any

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

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

32. def hashCode(): Int

    Definition Classes

    AnyRef → Any

33. def having(condition: SQLSyntax): SQLSyntax

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

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

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

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

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

39. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

40. def isNotNull(column: SQLSyntax): SQLSyntax

41. def isNull(column: SQLSyntax): SQLSyntax

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

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

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

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

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

47. def limit(n: Int): SQLSyntax

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

49. def max(column: SQLSyntax): SQLSyntax

50. def min(column: SQLSyntax): SQLSyntax

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

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

    Definition Classes

    AnyRef

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

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

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

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

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

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

59. final def notify(): Unit

    Definition Classes

    AnyRef

60. final def notifyAll(): Unit

    Definition Classes

    AnyRef

61. def offset(n: Int): SQLSyntax

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

63. def sum(column: SQLSyntax): SQLSyntax

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

    Definition Classes

    AnyRef

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

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

67. def toString(): String

    Definition Classes

    AnyRef → Any

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

69. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

72. def where(where: SQLSyntax): SQLSyntax

73. def where: SQLSyntax