Skip to content

Instantly share code, notes, and snippets.

@wfaler

wfaler/slickcount.scala

Created April 15, 2014 12:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wfaler/10730361 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wfaler/10730361 to your computer and use it in GitHub Desktop.
Download ZIP
Ugly aggregation & count
Raw
slickcount.scala
import scala.slick.jdbc.{GetResult, StaticQuery => Q}
case class FooCount(n: String, c: Int)
implicit val getStatusCountResult = GetResult(r => Foo(r.nextString, r.nextInt))
val q = Q.queryNA[FooCount]("SELECT foo, count(foo) FROM bar GROUP BY foo")
@gseitz

gseitz commented Apr 15, 2014

Copy link
Copy Markdown

I think you have to do it in 2 steps: http://slick.typesafe.com/doc/2.0.1/queries.html?highlight=group#aggregation

@wfaler

wfaler commented Apr 15, 2014

Copy link
Copy Markdown
Author

Thanks, this cleaned it up considerably. ..now trying to peak into the generated queries to see if they are efficient or barking mad..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment