PGJson

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. implicit object JsObjectParameterMetaData extends ParameterMetaData[JsObject]

   

5. implicit object JsValueParameterMetaData extends ParameterMetaData[JsValue]

   

6. final def asInstanceOf[T0]: T0

   

   Definition Classes

   Any

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

   
   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]
   val value = Foo("lorem")
   def foo(implicit con: java.sql.Connection) =
     SQL"INSERT INTO test(id, json) VALUES(${"bar"}, ${asJson(value)})".
       executeUpdate()

8. def clone(): AnyRef

   

   Attributes

   protected[java.lang]

   Definition Classes

   AnyRef

   Annotations

   @throws( ... )

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

   

   Definition Classes

   AnyRef

10. def equals(arg0: Any): Boolean

    

    Definition Classes

    AnyRef → Any

11. def finalize(): Unit

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

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

12. 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)

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

    

    Definition Classes

    AnyRef → Any

14. def hashCode(): Int

    

    Definition Classes

    AnyRef → Any

15. final def isInstanceOf[T0]: Boolean

    

    Definition Classes

    Any

16. 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)

17. 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)

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

    

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

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

    

    Definition Classes

    AnyRef

20. final def notify(): Unit

    

    Definition Classes

    AnyRef

21. final def notifyAll(): Unit

    

    Definition Classes

    AnyRef

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

    

    Definition Classes

    AnyRef

23. def toString(): String

    

    Definition Classes

    AnyRef → Any

24. final def wait(): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

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

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )