postgresql

Value Members

1. implicit object JsObjectParameterMetaData extends ParameterMetaData[JsObject]

   

   Definition Classes

   PGJson

2. implicit object JsValueParameterMetaData extends ParameterMetaData[JsValue]

   

   Definition Classes

   PGJson

3. implicit val UUIDToSql: ToSql[UUID]

   

   Instance of ToSql to support PostgreSQL UUID parameter

4. def asJson[T](value: T)(implicit w: Writes[T]): ParameterValue

   

   Sets a value as a JSON parameter.

   Sets a value as a JSON parameter.

   value

   the value to be passed as a JSON parameter

   w

   the Play writes to be used to serialized the value as JSON

   import play.api.libs.json._
   import anorm._, postgresql._
   case class Foo(bar: String)
   implicit val w: Writes[Foo] = Json.writes[Foo]
   implicit def con: java.sql.Connection = ???
   val value = asJson(Foo("lorem"))
   SQL("INSERT INTO test(id, json) VALUES({id}, {json})").
     on("id" -> "bar", "json" -> value).executeUpdate()

   Definition Classes

   PGJson

5. def asNullableJson[T](value: Option[T])(implicit w: Writes[T]): ParameterValue

   

   Sets an optional value as a JSON parameters.

   Sets an optional value as a JSON parameters.

   value

   the optional value to be passed as a JSON parameter

   w

   the Play writes to be used to serialized the value as JSON

   import play.api.libs.json._
   import anorm._, postgresql._
   case class Foo(bar: String)
   implicit val w: Writes[Foo] = Json.writes[Foo]
   val someVal = asNullableJson(Some(Foo("lorem")))
   val noVal = asNullableJson(Option.empty[Foo])
   implicit def con: java.sql.Connection = ???
   SQL("INSERT INTO test(id, json) VALUES({id}, {json})").
     on("id" -> "bar", "json" -> someVal).executeUpdate()
   SQL("INSERT INTO test(id, json) VALUES({id}, {json})").
     on("id" -> "bar", "json" -> noVal).executeUpdate()

   Definition Classes

   PGJson

6. def fromJson[T](implicit r: Reads[T]): Column[T]

   
   r

   the Play reader to be used from the selected JSONB value

   import play.api.libs.json.Reads
   import anorm._, postgresql._
   case class Foo(bar: String)
   def foo(implicit con: java.sql.Connection, r: Reads[Foo]): Foo =
     SQL"SELECT json FROM test".
       as(SqlParser.scalar(fromJson[Foo]).single)

   Definition Classes

   PGJson

7. implicit val jsObjectColumn: Column[JsObject]

   

   import play.api.libs.json.JsObject
   
   import anorm._, postgresql._
   
   def foo(implicit con: java.sql.Connection) =
     SQL"SELECT json FROM test".as(SqlParser.scalar[JsObject].single)

   Definition Classes

   PGJson

8. implicit val jsValueColumn: Column[JsValue]

   

   import play.api.libs.json.JsValue
   
   import anorm._, postgresql._
   
   def foo(implicit con: java.sql.Connection) =
     SQL"SELECT json FROM test".as(SqlParser.scalar[JsValue].single)

   Definition Classes

   PGJson

9. implicit def jsValueToStatement[J <: JsValue]: ToStatement[J]

   

   Allows to pass a JsValue as parameter to be stored as PGobject.

   Allows to pass a JsValue as parameter to be stored as PGobject.

   Definition Classes

   PGJson