Anorm runtime exception
SQL batch
Column mapping
Column mapping
Allows to define or overwrite the alias for a column.
the qualified column name
the column alias
Error raised when the specified column
cannot be found in results.
Error raised when the specified column
cannot be found in results.
the name of the not found column
the names of the available columns
Result cursor
Erroneous result (failure while parsing).
the name of the column
true if the column is nullable
the class of the JDBC column value
Applied named parameter.
Marker trait to indicate that even if a type T accept null as value, it must be refused in some Anorm context.
Untyped value wrapper.
Untyped value wrapper.
SQL("UPDATE t SET val = {o}").on('o -> anorm.Object(val))
Parameter meta data for type T
Parameter meta data for type T
Prepared parameter value.
Prepared parameter value.
Parses result from the cursor.
Parser for scalar row (row of one single column).
Wrapper to use Seq as SQL parameter, with custom formatting.
Wrapper to use Seq as SQL parameter, with custom formatting.
SQL("SELECT * FROM t WHERE %s"). on(SeqParameter(Seq("a", "b"), " OR ", Some("cat = "))) // Will execute as: // SELECT * FROM t WHERE cat = 'a' OR cat = 'b'
Simple/plain SQL.
Initial SQL query, without parameter values.
A result from execution of an SQL query, row data and context (e.g.
A result from execution of an SQL query, row data and context (e.g. statement warnings).
Result set from executed query
Error from processing SQL
Parsed SQL result.
Creates an SQL query using String Interpolation feature.
Creates an SQL query using String Interpolation feature. It is a 1-step alternative for SQL("...").on(...) functions.
SQL""" UPDATE computer SET name = \${computer.name}, introduced = \${computer.introduced}, discontinued = \${computer.discontinued}, company_id = \${computer.companyId} WHERE id = \$id """.executeUpdate()
Successfully parsed result.
Structural type for timestamp wrapper.
Set value as prepared SQL statement fragment.
Set value as prepared SQL statement fragment.
Sets value as statement parameter.
Sets value as statement parameter.
Conversion from 2-column tuple-like to scala.Tuple2, with resolution priority 1.
Conversion from 11-column tuple-like to scala.Tuple11, with resolution priority 10.
Conversion from 12-column tuple-like to scala.Tuple12, with resolution priority 11.
Conversion from 13-column tuple-like to scala.Tuple13, with resolution priority 12.
Conversion from 14-column tuple-like to scala.Tuple14, with resolution priority 13.
Conversion from 15-column tuple-like to scala.Tuple15, with resolution priority 14.
Conversion from 16-column tuple-like to scala.Tuple16, with resolution priority 15.
Conversion from 17-column tuple-like to scala.Tuple17, with resolution priority 16.
Conversion from 18-column tuple-like to scala.Tuple18, with resolution priority 17.
Conversion from 19-column tuple-like to scala.Tuple19, with resolution priority 18.
Conversion from 20-column tuple-like to scala.Tuple20, with resolution priority 19.
Conversion from 3-column tuple-like to scala.Tuple3, with resolution priority 2.
Conversion from 21-column tuple-like to scala.Tuple21, with resolution priority 20.
Conversion from 22-column tuple-like to scala.Tuple22, with resolution priority 21.
Conversion from 4-column tuple-like to scala.Tuple4, with resolution priority 3.
Conversion from 5-column tuple-like to scala.Tuple5, with resolution priority 4.
Conversion from 6-column tuple-like to scala.Tuple6, with resolution priority 5.
Conversion from 7-column tuple-like to scala.Tuple7, with resolution priority 6.
Conversion from 8-column tuple-like to scala.Tuple8, with resolution priority 7.
Conversion from 9-column tuple-like to scala.Tuple9, with resolution priority 8.
Conversion from 10-column tuple-like to scala.Tuple10, with resolution priority 9.
Columns tuple-like
SQL batch companion
Column companion, providing default conversions.
Cursor companion
Meta data for Joda parameters
Companion object for applied named parameter.
ParameterMetaData companion, providing defaults based on SQL92.
Value factory for parameter.
Value factory for parameter.
val param = ParameterValue("str", null, setter) SQL("...").onParams(param)
Companion object for row.
Creates an SQL query with given statement.
Creates an SQL query with given statement.
SQL statement
val query = SQL("SELECT * FROM Country")
SeqParameter factory
Parser for SQL statement.
Provided ToSql implementations.
Provided conversions to set statement parameter.
Conversions to flatten columns to tuple.
Activable features
Anorm API
Use the SQL method to start an SQL query