PGJson

Value Members

final def !=(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def ##(): Int

Definition Classes
AnyRef → Any
final def ==(arg0: Any): Boolean

Definition Classes
AnyRef → Any
implicit object JsObjectParameterMetaData extends ParameterMetaData[JsObject]
implicit object JsValueParameterMetaData extends ParameterMetaData[JsValue]
final def asInstanceOf[T0]: T0

Definition Classes
Any

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

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(${"bar"}, ${value})".executeUpdate()

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

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(${"bar"}, ${someVal})".executeUpdate()
SQL"INSERT INTO test(id, json) VALUES(${"bar"}, ${noVal})".executeUpdate()

def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@HotSpotIntrinsicCandidate() @throws( ... )
final def eq(arg0: AnyRef): Boolean

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

Definition Classes
AnyRef → Any

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)

final def getClass(): Class[_]

Definition Classes
AnyRef → Any
Annotations
@HotSpotIntrinsicCandidate()
def hashCode(): Int

Definition Classes
AnyRef → Any
Annotations
@HotSpotIntrinsicCandidate()
final def isInstanceOf[T0]: Boolean

Definition Classes
Any

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)

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)

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

Allows to pass a JsValue as parameter to be stored as PGobject.
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
Annotations
@HotSpotIntrinsicCandidate()
final def notifyAll(): Unit

Definition Classes
AnyRef
Annotations
@HotSpotIntrinsicCandidate()
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def toString(): String

Definition Classes
AnyRef → Any
final def wait(): Unit

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

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

Definition Classes
AnyRef
Annotations
@throws( ... )

Deprecated Value Members

def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@Deprecated @deprecated @throws( classOf[java.lang.Throwable] )
Deprecated
(Since version ) see corresponding Javadoc for more information.

Related Doc: package anorm

sealed trait PGJson extends AnyRef

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

implicit object JsObjectParameterMetaData extends ParameterMetaData[JsObject]

implicit object JsValueParameterMetaData extends ParameterMetaData[JsValue]

final def asInstanceOf[T0]: T0

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

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

def clone(): AnyRef

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

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

final def getClass(): Class[_]

def hashCode(): Int

final def isInstanceOf[T0]: Boolean

implicit val jsObjectColumn: Column[JsObject]

implicit val jsValueColumn: Column[JsValue]

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

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

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

def toString(): String

final def wait(): Unit

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

final def wait(arg0: Long): Unit

Deprecated Value Members

def finalize(): Unit

Inherited from AnyRef

Inherited from Any

Ungrouped