Parses specified array column.
Parses specified array column.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (String, Array[String]) = SQL"SELECT a, sqlArrayOfString FROM test" .as(SqlParser.str("a") ~ SqlParser.array[String](2) map ( SqlParser.flatten) single)
Parses specified array column.
Parses specified array column.
import anorm.{ SQL, SqlParser } val t: (String, Array[String]) = SQL"SELECT a, sqlArrayOfString FROM test" .as(SqlParser.str("a") ~ SqlParser.array[String]("sqlArrayOfString") map ( SqlParser.flatten) single)
Parses specified column as binary stream.
Parses specified column as binary stream.
import java.io.InputStream import anorm.{ SQL, SqlParser } val parser = SqlParser.str(1) ~ SqlParser.binaryStream(2) val file: (String, InputStream) = SQL("SELECT name, data FROM files"). as(parser.single)
Parses specified column as binary stream.
Parses specified column as binary stream.
import java.io.InputStream import anorm.{ SQL, SqlParser } val parser = SqlParser.str("name") ~ SqlParser.binaryStream("data") val file: (String, InputStream) = SQL("SELECT name, data FROM files"). as(parser.single)
Parses specified column as boolean.
Parses specified column as boolean.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Boolean, String) = SQL("SELECT a, b FROM test") .as(SqlParser.bool(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as boolean.
Parses specified column as boolean.
import anorm.{ SQL, SqlParser } val t: (Boolean, String) = SQL("SELECT a, b FROM test") .as(SqlParser.bool("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as byte.
Parses specified column as byte.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Byte, String) = SQL("SELECT a, b FROM test") .as(SqlParser.byte(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as byte.
Parses specified column as byte.
import anorm.{ SQL, SqlParser } val t: (Byte, String) = SQL("SELECT a, b FROM test") .as(SqlParser.byte("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as binary stream.
Parses specified column as binary stream.
import anorm.{ SQL, SqlParser }, SqlParser.{ str, byteArray } val parser = (SqlParser.str(1) ~ SqlParser.byteArray(2)).flatten val file: (String, Array[Byte]) = SQL("SELECT name, data FROM files"). as(parser.single)
Parses specified column as binary stream.
Parses specified column as binary stream.
import anorm.{ SQL, SqlParser }, SqlParser.{ str, byteArray } val parser = (str("name") ~ byteArray("data")).flatten val file: (String, Array[Byte]) = SQL("SELECT name, data FROM files"). as(parser.single)
Parses specified column as date.
Parses specified column as date.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Date, String) = SQL("SELECT a, b FROM test") .as(SqlParser.date(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as date.
Parses specified column as date.
import anorm.{ SQL, SqlParser } val t: (Date, String) = SQL("SELECT a, b FROM test") .as(SqlParser.date("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as double.
Parses specified column as double.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Double, String) = SQL("SELECT a, b FROM test") .as(SqlParser.double(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as double.
Parses specified column as double.
import anorm.{ SQL, SqlParser } val t: (Double, String) = SQL("SELECT a, b FROM test") .as(SqlParser.double("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Flatten columns tuple-like.
Flatten columns tuple-like.
import anorm.SQL import anorm.SqlParser.{ long, str, int } val tuple: (Long, String, Int) = SQL("SELECT a, b, c FROM Test"). as(long("a") ~ str("b") ~ int("c") map (SqlParser.flatten) single)
Parses specified column as float.
Parses specified column as float.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Float, String) = SQL("SELECT a, b FROM test") .as(SqlParser.float(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as float.
Parses specified column as float.
import anorm.{ SQL, SqlParser } val t: (Float, String) = SQL("SELECT a, b FROM test") .as(SqlParser.float("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Returns a parser that fold over the row.
Returns a parser that fold over the row.
val p: RowParser[List[(Any, String)]] = SqlParser.folder(List.empty[(Any, String)]) { (ls, v, m) => Right((v, m.clazz) :: ls) }
Returns row parser for column at given position.
Returns row parser for column at given position.
Column position, from 1 to n
import anorm.SQL import anorm.SqlParser.get val res: (Float, String) = // parsing columns #1 & #3 SQL("SELECT * FROM Test").as(get[String](1) ~ get[Float](3) map { case str ~ f => (f -> str) } *)
Returns row parser for column with given name.
Returns row parser for column with given name.
Column name
import anorm.SQL import anorm.SqlParser.get val title: String = SQL("SELECT title FROM Books"). as(get[String]("title").single)
Parses specified column as integer.
Parses specified column as integer.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Int, String) = SQL("SELECT a, b FROM test") .as(SqlParser.int(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as integer.
Parses specified column as integer.
import anorm.{ SQL, SqlParser } val t: (Int, String) = SQL("SELECT a, b FROM test") .as(SqlParser.int("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified array column as list.
Parses specified array column as list.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (String, List[String]) = SQL("SELECT a, sqlArrayOfString FROM test") .as(SqlParser.str("a") ~ SqlParser.list(2) map ( SqlParser.flatten) single)
Parses specified array column as list.
Parses specified array column as list.
import anorm.{ SQL, SqlParser } val t: (String, List[String]) = SQL("SELECT a, sqlArrayOfString FROM test") .as(SqlParser.str("a") ~ SqlParser.list("sqlArrayOfString") map ( SqlParser.flatten) single)
Parses specified column as long.
Parses specified column as long.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Long, String) = SQL("SELECT a, b FROM test") .as(SqlParser.long(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as long.
Parses specified column as long.
import anorm.{ SQL, SqlParser } val t: (Long, String) = SQL("SELECT a, b FROM test") .as(SqlParser.long("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Returns row parser which true if specified column is found
and matching expected value.
Returns row parser which true if specified column is found
and matching expected value.
import anorm.SQL import anorm.SqlParser.matches val m: Boolean = SQL("SELECT * FROM table").as(matches("a", 1.2f).single) // true if column |a| is found and matching 1.2f, otherwise false
true if matches, or false if not
Returns a parser for a scalar not-null value.
Returns a parser for a scalar not-null value.
val count = SQL("select count(*) from Country").as(scalar[Long].single)
Parses specified column as short.
Parses specified column as short.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Short, String) = SQL("SELECT a, b FROM test") .as(SqlParser.short(1) ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as short.
Parses specified column as short.
import anorm.{ SQL, SqlParser } val t: (Short, String) = SQL("SELECT a, b FROM test") .as(SqlParser.short("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)
Parses specified column as string.
Parses specified column as string.
from 1 to n
import anorm.{ SQL, SqlParser } val t: (Float, String) = SQL("SELECT a, b FROM test") .as(SqlParser.float("a") ~ SqlParser.str(1) map ( SqlParser.flatten) single)
Parses specified column as string.
Parses specified column as string.
import anorm.{ SQL, SqlParser } val t: (Float, String) = SQL("SELECT a, b FROM test") .as(SqlParser.float("a") ~ SqlParser.str("b") map ( SqlParser.flatten) single)