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
column
is found and matching expectedvalue
.Returns row parser which true if specified
column
is 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( ... )