February 2017
Beginner to intermediate
1100 pages
25h 19m
English
Slick also provides a groupBy method that behaves like the
groupBy method of native Scala collections. Let's get a list of candidates with all the donations for each candidate:
scala> val grouped = Tables.transactions.groupBy { _.candidate } grouped: scala.slick.lifted.Query[(scala.slick.lifted.Column[... scala> val aggregated = grouped.map { case (candidate, group) => (candidate -> group.map { _.amount }.sum) } aggregated: scala.slick.lifted.Query[(scala.slick.lifted.Column[... scala> val groupedDonations = db.withSession { implicit session => aggregated.list } groupedDonations: List[(String, Option[Long])] = List((Bachmann, Michele,Some(7439272)),...
Let's break this down. The first statement, transactions.groupBy ...
Read now
Unlock full access