object SqlParser extends FunctionAdapter
- Source
- SqlParser.scala
- Alphabetic
- By Inheritance
- SqlParser
- FunctionAdapter
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
array[T](columnPosition: Int)(implicit c: Column[Array[T]]): RowParser[Array[T]]
Parses specified array column.
Parses specified array column.
- columnPosition
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)
-
def
array[T](columnName: String)(implicit c: Column[Array[T]]): RowParser[Array[T]]
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)
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
binaryStream(columnPosition: Int)(implicit c: Column[InputStream]): RowParser[InputStream]
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)
-
def
binaryStream(columnName: String)(implicit c: Column[InputStream]): RowParser[InputStream]
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)
-
def
bool(columnPosition: Int)(implicit c: Column[Boolean]): RowParser[Boolean]
Parses specified column as boolean.
Parses specified column as boolean.
- columnPosition
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)
-
def
bool(columnName: String)(implicit c: Column[Boolean]): RowParser[Boolean]
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)
-
def
byte(columnPosition: Int)(implicit c: Column[Byte]): RowParser[Byte]
Parses specified column as byte.
Parses specified column as byte.
- columnPosition
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)
-
def
byte(columnName: String)(implicit c: Column[Byte]): RowParser[Byte]
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)
-
def
byteArray(columnPosition: Int)(implicit c: Column[Array[Byte]]): RowParser[Array[Byte]]
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)
-
def
byteArray(columnName: String)(implicit c: Column[Array[Byte]]): RowParser[Array[Byte]]
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)
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
def
date(columnPosition: Int)(implicit c: Column[Date]): RowParser[Date]
Parses specified column as date.
Parses specified column as date.
- columnPosition
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)
-
def
date(columnName: String)(implicit c: Column[Date]): RowParser[Date]
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)
-
def
double(columnPosition: Int)(implicit c: Column[Double]): RowParser[Double]
Parses specified column as double.
Parses specified column as double.
- columnPosition
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)
-
def
double(columnName: String)(implicit c: Column[Double]): RowParser[Double]
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)
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
equals(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
-
def
flatten[T1, T2, R](implicit f: TupleFlattener[(~[T1, T2]) ⇒ R]): (~[T1, T2]) ⇒ R
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)
-
def
float(columnPosition: Int)(implicit c: Column[Float]): RowParser[Float]
Parses specified column as float.
Parses specified column as float.
- columnPosition
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)
-
def
float(columnName: String)(implicit c: Column[Float]): RowParser[Float]
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)
-
def
folder[T](z: T)(f: (T, Any, MetaDataItem) ⇒ Either[SqlRequestError, T]): RowParser[T]
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) }
-
def
get[T](position: Int)(implicit extractor: Column[T]): RowParser[T]
Returns row parser for column at given
position.Returns row parser for column at given
position.- 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) } *)
-
def
get[T](name: String)(implicit extractor: Column[T]): RowParser[T]
Returns row parser for column with given
name.Returns row parser for column with given
name.- name
Column name
import anorm.SQL import anorm.SqlParser.get val title: String = SQL("SELECT title FROM Books"). as(get[String]("title").single)
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
def
hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
def
int(columnPosition: Int)(implicit c: Column[Int]): RowParser[Int]
Parses specified column as integer.
Parses specified column as integer.
- columnPosition
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)
-
def
int(columnName: String)(implicit c: Column[Int]): RowParser[Int]
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)
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
-
def
list[T](columnPosition: Int)(implicit c: Column[List[T]]): RowParser[List[T]]
Parses specified array column as list.
Parses specified array column as list.
- columnPosition
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)
-
def
list[T](columnName: String)(implicit c: Column[List[T]]): RowParser[List[T]]
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)
-
def
long(columnPosition: Int)(implicit c: Column[Long]): RowParser[Long]
Parses specified column as long.
Parses specified column as long.
- columnPosition
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)
-
def
long(columnName: String)(implicit c: Column[Long]): RowParser[Long]
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)
-
def
matches[TT, T <: TT](column: String, value: T)(implicit arg0: Column[TT], c: Column[TT]): RowParser[Boolean]
Returns row parser which true if specified
columnis found and matching expectedvalue.Returns row parser which true if specified
columnis found and matching expectedvalue.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
- returns
true if matches, or false if not
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
def
scalar[T](implicit transformer: Column[T]): RowParser[T]
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)
-
def
short(columnPosition: Int)(implicit c: Column[Short]): RowParser[Short]
Parses specified column as short.
Parses specified column as short.
- columnPosition
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)
-
def
short(columnName: String)(implicit c: Column[Short]): RowParser[Short]
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)
-
def
str(columnPosition: Int)(implicit c: Column[String]): RowParser[String]
Parses specified column as string.
Parses specified column as string.
- columnPosition
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)
-
def
str(columnName: String)(implicit c: Column[String]): RowParser[String]
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)
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17], T18], T19], T20], T21], T22]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17], T18], T19], T20], T21]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17], T18], T19], T20]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17], T18], T19]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17], T18]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16], T17]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15], T16]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14], T15]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13], T14]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12], T13]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12) ⇒ R): (~[~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11], T12]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11) ⇒ R): (~[~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10], T11]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9, T10) ⇒ R): (~[~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9], T10]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, T9, R](f: (T1, T2, T3, T4, T5, T6, T7, T8, T9) ⇒ R): (~[~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8], T9]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, T8, R](f: (T1, T2, T3, T4, T5, T6, T7, T8) ⇒ R): (~[~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7], T8]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, T7, R](f: (T1, T2, T3, T4, T5, T6, T7) ⇒ R): (~[~[~[~[~[~[T1, T2], T3], T4], T5], T6], T7]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, T6, R](f: (T1, T2, T3, T4, T5, T6) ⇒ R): (~[~[~[~[~[T1, T2], T3], T4], T5], T6]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, T5, R](f: (T1, T2, T3, T4, T5) ⇒ R): (~[~[~[~[T1, T2], T3], T4], T5]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, T4, R](f: (T1, T2, T3, T4) ⇒ R): (~[~[~[T1, T2], T3], T4]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, T3, R](f: (T1, T2, T3) ⇒ R): (~[~[T1, T2], T3]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, T2, R](f: (T1, T2) ⇒ R): (~[T1, T2]) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
to[T1, R](f: (T1) ⇒ R): (T1) ⇒ R
- Definition Classes
- FunctionAdapter
-
def
toString(): String
- Definition Classes
- AnyRef → Any
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )