anorm

ToStatement

object ToStatement

Provided conversions to set statement parameter.

Source
ToStatement.scala
Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. ToStatement
  2. AnyRef
  3. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

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

    Definition Classes
    Any
  5. implicit object booleanToStatement extends ToStatement[Boolean]

    Sets boolean value on statement.

    Sets boolean value on statement.

    SQL("SELECT * FROM Test WHERE enabled = {b}").on('b -> true)
  6. implicit object byteToStatement extends ToStatement[Byte]

    Sets byte value on statement.

    Sets byte value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1.toByte)
  7. implicit object charToStatement extends ToStatement[Char]

    Sets character as parameter value.

    Sets character as parameter value.

    SQL("SELECT * FROM tbl WHERE flag = {c}").on("c" -> 'f')
  8. implicit object characterToStatement extends ToStatement[Character]

    Sets Java Character as parameter value.

    Sets Java Character as parameter value. For null character, setNull with VARCHAR is called on statement.

    SQL("SELECT * FROM tbl WHERE flag = {c}").
    on("c" -> new java.lang.Character('f'))
  9. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  10. implicit object dateToStatement extends ToStatement[Date]

    Sets date as statement parameter.

    Sets date as statement parameter. For null value, setNull with TIMESTAMP is called on statement.

    SQL("UPDATE tbl SET modified = {d}").on('d -> new Date())
  11. implicit object doubleToStatement extends ToStatement[Double]

    Sets double value on statement.

    Sets double value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1d)
  12. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  13. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  14. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  15. implicit object floatToStatement extends ToStatement[Float]

    Sets float value on statement.

    Sets float value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1f)
  16. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  17. def hashCode(): Int

    Definition Classes
    AnyRef → Any
  18. implicit def idToStatement[A](implicit c: ToStatement[A]): ToStatement[Id[A]] with NotNullGuard

    Sets Id parameter on statement.

    Sets Id parameter on statement.

    SQL("INSERT INTO tbl(id, name) VALUES ({i}, {v}").
    on("i" -> anorm.Id("id"), "v" -> "name")
  19. implicit object intToStatement extends ToStatement[Int]

    Sets integer value on statement.

    Sets integer value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1)
  20. implicit object integerToStatement extends ToStatement[Integer]

    Sets Java Integer object on statement.

    Sets Java Integer object on statement. For null value, setNull with INTEGER is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").
    on('b -> new java.lang.Integer(1))
  21. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  22. implicit object javaBigDecimalToStatement extends ToStatement[BigDecimal]

    Sets Java big decimal on statement.

    Sets Java big decimal on statement. Value null is accepted.

    SQL("UPDATE tbl SET max = {m}").on('m -> new java.math.BigDecimal(10.02f))
  23. implicit object javaBigIntegerToStatement extends ToStatement[BigInteger]

    Sets Java big integer on statement.

    Sets Java big integer on statement. For null value, setNull with NUMERIC is called on statement.

    SQL("UPDATE tbl SET max = {m}").on('m -> new BigInteger(15))
  24. implicit object javaBooleanToStatement extends ToStatement[Boolean]

    Sets Java Boolean object on statement.

    Sets Java Boolean object on statement. For null value, setNull with BOOLEAN is called on statement.

    SQL("SELECT * FROM Test WHERE enabled = {b}").
    on('b -> java.lang.Boolean.TRUE)
  25. implicit object javaByteToStatement extends ToStatement[Byte]

    Sets Java Byte object on statement.

    Sets Java Byte object on statement. For null value, setNull with TINYINT is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> new java.lang.Byte(1))
  26. implicit object javaDoubleToStatement extends ToStatement[Double]

    Sets Java Double object on statement.

    Sets Java Double object on statement. For null value, setNull with DOUBLE is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").
    on('b -> new java.lang.Double(1d))
  27. implicit object javaFloatToStatement extends ToStatement[Float]

    Sets Java Float object on statement.

    Sets Java Float object on statement. For null value, setNull with FLOAT is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").
    on('b -> new java.lang.Float(1f))
  28. implicit object javaLongToStatement extends ToStatement[Long]

    Sets Java Long object on statement.

    Sets Java Long object on statement. For null value, setNull with BIGINT is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").
    on('b -> new java.lang.Long(1l))
  29. implicit object javaShortToStatement extends ToStatement[Short]

    Sets Java Short object on statement.

    Sets Java Short object on statement. For null value, setNull with SMALLINT is called on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").
    on('b -> new java.lang.Short(1.toShort))
  30. implicit object longToStatement extends ToStatement[Long]

    Sets long value on statement.

    Sets long value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1l)
  31. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  32. implicit object noneToStatement extends ToStatement[None.type]

    Sets null for None value.

    Sets null for None value.

    SQL("SELECT * FROM Test WHERE category = {c}")
    .on('c -> None)
  33. implicit object notAssignedToStatement extends ToStatement[NotAssigned.type]

    Sets null for not assigned value.

    Sets null for not assigned value.

    SQL("SELECT * FROM Test WHERE category = {c}").on('c -> NotAssigned)
  34. final def notify(): Unit

    Definition Classes
    AnyRef
  35. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  36. implicit object objectToStatement extends ToStatement[Object]

    Sets opaque value as statement parameter.

    Sets opaque value as statement parameter. UNSAFE: It's set using java.sql.PreparedStatement.setObject.

    SQL("EXEC indexed_at {d}").on('d -> anorm.Object(new java.util.Date()))
  37. implicit def optionToStatement[A](implicit c: ToStatement[A]): ToStatement[Option[A]] with NotNullGuard

    Sets optional A inferred as Option[A].

    Sets optional A inferred as Option[A].

    SQL("SELECT * FROM Test WHERE category = {c}")
    .on('c -> Option("cat"))
  38. implicit object scalaBigDecimalToStatement extends ToStatement[BigDecimal]

    Sets big decimal on statement.

    Sets big decimal on statement. For null value, setNull with DECIMAL is called on statement.

    SQL("UPDATE tbl SET max = {m}").on('m -> BigDecimal(10.02f))
  39. implicit object scalaBigIntegerToStatement extends ToStatement[BigInt]

    Sets big integer on statement.

    Sets big integer on statement. For null value, setNull with NUMERIC is called on statement.

    SQL("UPDATE tbl SET max = {m}").on('m -> BigInt(15))
  40. implicit def seqParamToStatement[A](implicit c: ToStatement[Seq[A]]): ToStatement[SeqParameter[A]] with NotNullGuard

    Sets multi-value parameter on statement, with custom formatting (using anorm.SeqParameter).

    Sets multi-value parameter on statement, with custom formatting (using anorm.SeqParameter).

    import anorm.SeqParameter
    SQL("SELECT * FROM Test t WHERE {categories}").
      on('categories -> SeqParameter(
        values = Seq("a", "b", "c"), separator = " OR ",
        pre = "EXISTS (SELECT NULL FROM j WHERE t.id=j.id AND name=",
        post = ")"))
  41. implicit def seqToStatement[A](implicit c: ToStatement[A]): ToStatement[Seq[A]] with NotNullGuard

    Sets multi-value parameter on statement.

    Sets multi-value parameter on statement.

    SQL("SELECT * FROM Test WHERE cat IN ({categories})").
    on('categories -> Seq("a", "b", "c")
  42. implicit object shortToStatement extends ToStatement[Short]

    Sets short value on statement.

    Sets short value on statement.

    SQL("SELECT * FROM Test WHERE flag = {b}").on('b -> 1.toShort)
  43. implicit def someToStatement[A](implicit c: ToStatement[A]): ToStatement[Some[A]] with NotNullGuard

    Sets not empty optional A inferred as Some[A].

    Sets not empty optional A inferred as Some[A].

    SQL("SELECT * FROM Test WHERE category = {c}").on('c -> Some("cat"))
  44. implicit object stringToStatement extends ToStatement[String]

    Sets string as parameter value.

    Sets string as parameter value. Value null is accepted.

    SQL("SELECT * FROM tbl WHERE name = {n}").on("n" -> "str")
  45. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  46. implicit object timestampToStatement extends ToStatement[Timestamp]

    Sets timestamp as statement parameter.

    Sets timestamp as statement parameter. Value null is accepted.

    SQL("UPDATE tbl SET modified = {ts}").
    on('ts -> new Timestamp(date.getTime))
  47. def toString(): String

    Definition Classes
    AnyRef → Any
  48. implicit object uuidToStatement extends ToStatement[UUID]

    Sets UUID as statement parameter.

    Sets UUID as statement parameter. For null value, setNull with VARCHAR is called on statement.

    SQL("INSERT INTO lang_tbl(id, name) VALUE ({i}, {n})").
    on("i" -> java.util.UUID.randomUUID(), "n" -> "lang")
  49. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  50. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  51. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped