ConnectionOps

wsql.ConnectionOps

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
object given_ConnectionOps.type

Members list

Extensions

Extensions

extension (conn: Connection)(conn: Connection)
inline def createBatch[T](inline proc: T => SQLWithArgs): Batch[T]
inline def createMysqlBatch[T](inline proc: T => SQLWithArgs): Batch[T]
def eachRow[T : ResultSetMapper](sql: SQLWithArgs)(f: T => Unit)(implicit evidence$8: ResultSetMapper[T]): Unit

iterate rows

iterate rows

Attributes

def executeUpdate(stmt: SQLWithArgs): Int
def executeUpdateWithGenerateKey(stmt: SQLWithArgs)(proc: ResultSet => Unit): Int
def generateKey[T : JdbcValueAccessor](stmt: SQLWithArgs)(implicit evidence$7: JdbcValueAccessor[T]): T
def joinRow2[T1 : ResultSetMapper, T2 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$20: ResultSetMapper[T1], evidence$21: ResultSetMapper[T2]): Option[(T1, T2)]
def joinRow3[T1 : ResultSetMapper, T2 : ResultSetMapper, T3 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$22: ResultSetMapper[T1], evidence$23: ResultSetMapper[T2], evidence$24: ResultSetMapper[T3]): Option[(T1, T2, T3)]
def joinRow4[T1 : ResultSetMapper, T2 : ResultSetMapper, T3 : ResultSetMapper, T4 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$25: ResultSetMapper[T1], evidence$26: ResultSetMapper[T2], evidence$27: ResultSetMapper[T3], evidence$28: ResultSetMapper[T4]): Option[(T1, T2, T3, T4)]
def joinRows2[T1 : ResultSetMapper, T2 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$10: ResultSetMapper[T1], evidence$11: ResultSetMapper[T2]): List[(T1, T2)]

joinRowsX is likes rows[T], but maybe return a TupleX which can used to retrieve 2 objects mapped.

joinRowsX is likes rows[T], but maybe return a TupleX which can used to retrieve 2 objects mapped.

Attributes

def joinRows3[T1 : ResultSetMapper, T2 : ResultSetMapper, T3 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$12: ResultSetMapper[T1], evidence$13: ResultSetMapper[T2], evidence$14: ResultSetMapper[T3]): List[(T1, T2, T3)]
def joinRows4[T1 : ResultSetMapper, T2 : ResultSetMapper, T3 : ResultSetMapper, T4 : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$15: ResultSetMapper[T1], evidence$16: ResultSetMapper[T2], evidence$17: ResultSetMapper[T3], evidence$18: ResultSetMapper[T4]): List[(T1, T2, T3, T4)]
def queryInt(sql: SQLWithArgs): Int

runs a SQL which returns a single row, and a single integer column, such as select count(*) from table

runs a SQL which returns a single row, and a single integer column, such as select count(*) from table

Attributes

def row[T : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$19: ResultSetMapper[T]): Option[T]
def rows[T : ResultSetMapper](sql: SQLWithArgs)(implicit evidence$9: ResultSetMapper[T]): List[T]

return rows as a List, T is a case class or a primitive type which can be mapped from the query ResultSet rows[SomeCaseClass] or rows[Int] for primitive types.

return rows as a List, T is a case class or a primitive type which can be mapped from the query ResultSet rows[SomeCaseClass] or rows[Int] for primitive types.

Attributes

def withStatement[T](f: Statement => T): T
def withTransaction[T](f: Connection => T): T