SQL

SQL abstraction's companion object

 ConnectionPool.singleton("jdbc:...","user","password")
 case class User(id: Int, name: String)

 val users = DB.readOnly { implicit session =>
   SQL("select * from user").map { rs =>
     User(rs.int("id"), rs.string("name"))
   }.list.apply()
 }

 DB .autoCommit { implicit session =>
   SQL("insert into user values (?,?)").bind(123, "Alice").update.apply()
 }

 DB localTx { implicit session =>
   SQL("insert into user values (?,?)").bind(123, "Alice").update.apply()
 }

 using(DB(ConnectionPool.borrow())) { db =>
   db.begin()
   try {
     DB withTx { implicit session =>
       SQL("update user set name = ? where id = ?").bind("Alice", 123).update.apply()
     }
     db.commit()
   } catch { case e =>
     db.rollbackIfActive()
     throw e
   }
 }