Skip to content

Instantly share code, notes, and snippets.

@jlengrand
Created March 19, 2020 09:40
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
println("Ratings query took : ${measureTimeMillis() {
transaction(db) {
var result = (Titles innerJoin Ratings).slice(Titles.primaryTitle, Titles.titleType, Ratings.averageRating, Ratings.numVotes).select {
((Titles.primaryTitle like "%batman%") and (Titles.titleType like "movie")
and Titles.tconst.eq(Ratings.tconst))
}.orderBy(Ratings.averageRating)
.toList()
println(result.size)
println(result)
println(result.last())
}
}}");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment