relate

Type Members

1. trait ColReader[A] extends AnyRef

   

2. class InterpolatedQuery extends Sql with MultipleParameter

   

3. trait MultipleParameter extends Parameter

   

4. class NullColumnException extends Exception

   

5. trait Parameter extends AnyRef

   

6. trait Parameterizable[-A] extends AnyRef

   

7. trait ResultSetWrapper extends AnyRef

   

8. trait RowParser[A] extends (SqlRow) ⇒ A

   

9. trait SingleParameter extends Parameter

   

10. trait Sql extends AnyRef

    

    Sql is a trait for basic SQL queries.

    Sql is a trait for basic SQL queries.

    It provides methods for parameter insertion and query execution.

    import com.lucidchart.relate._
    import com.lucidchart.relate.Query._
    
    case class User(id: Long, name: String)
    
    SQL("""
      SELECT id, name
      FROM users
      WHERE id={id}
    """).on { implicit query =>
      long("id", 1L)
    }.asSingle(RowParser { row =>
      User(row.long("id"), row.string("name"))
    })

11. class SqlResult extends ResultSetWrapper

    

    The SqlResult class is a wrapper around Java's ResultSet class.

    The SqlResult class is a wrapper around Java's ResultSet class.

    It provides methods to allows users to retrieve specific columns by name and datatype, but also provides methods that can, given a RowParser, parse the entire result set as a collection of records returned by the parser. These methods are also defined in the Sql trait, and are most conveniently used when chained with parameter insertion. For how to do this, see the Sql trait documentation.

    The extraction methods (int, string, long, etc.) also have "strict" counterparts. The "strict" methods are slightly faster, but do not do type checking or handle null values.

12. class SqlRow extends ResultSetWrapper

    

13. implicit class SqlString extends AnyRef

    

14. implicit class SqlStringContext extends AnyRef

    

15. class TupleParameter extends MultipleParameter

    

16. class TuplesParameter extends MultipleParameter