Returns possibly empty list parsed from result.
Returns possibly empty list parsed from result.
val price = 125 SQL"SELECT name FROM item WHERE price < $price".as(scalar[String].*)
Returns non empty list parse from result, or raise error if there is no result.
Returns non empty list parse from result, or raise error if there is no result.
import anorm.SQL import anorm.SqlParser.str val parser = str("title") ~ str("descr") SQL("SELECT title, descr FROM pages").as(parser.+) // at least 1 page
Returns a row parser for optional column, that will turn missing or null column as None.
Returns a row parser for optional column, that will turn missing or null column as None.
Returns parser which collects information
from already parsed row data using f
.
Returns parser which collects information
from already parsed row data using f
.
Message returned as error if nothing can be collected using f
.
Collecting function
Returns a result set parser expecting exactly one row to parse.
Returns a result set parser expecting exactly one row to parse.
val b: Boolean = SQL("SELECT flag FROM Test WHERE id = :id"). on("id" -> 1).as(scalar[Boolean].single)
#singleOpt
Returns a result set parser for none or one parsed row.
Returns a result set parser for none or one parsed row.
val name: Option[String] = SQL("SELECT name FROM Country WHERE lang = :lang") .on("lang" -> "notFound").as(scalar[String].singleOpt)
Parser for scalar row (row of one single column).