By Alvin Alexander. Last updated: October 24, 2018
As a quick note today, here’s an example Play Framework Anorm SQL SELECT query that queries for a single value:
def urlAliasExists(uri: String): Boolean = db.withConnection { implicit c => val q: SimpleSql[Row] = SQL""" select count(dst) from url_alias where dst = $uri """ val count = q.as(SqlParser.scalar[Int].single) if (count > 0) true else false }
As shown, the SELECT query gets the count of a value from a database table, then does a little work in addition to that. But the purpose of this example is to show an example of the Anorm syntax for a query that returns a single value, so I hope it’s helpful in that way.