What’s new in Anorm 2.7

This page highlights the new features of Anorm 2.7. If you want learn about the changes you need to make to migrate to Anorm 2.7, check out the Migration Guide.

• Support java.net.URI & java.net.URL in parameter or column mappings.

  What’s new in Anorm 2.6

This page highlights the new features of Anorm 2.6. If you want learn about the changes you need to make to migrate to Anorm 2.6, check out the Migration Guide.

The streaming support has been improved for a reactive processing of the results, with new modules:

• Akka Stream module
• Iteratees module
• New typeclass ToParameterList
• New module dedicated to PostgreSQL
• Macros upgrade;
  • New macro to generate positional parser with an offset: offsetParser[T](offset: Int)
  • New macro to materialize parser using ColumnNaming: namedParser[T]
  • The parsing macros can now use existing RowParser as sub-parser.
  • New macros valueColumn and valueToStatement for the Value Classes.
• ColumnAliaser to define user aliases over the results, before parsing.
• Operation .executeInsert1 allows to select columns among the generated keys.
• Scala for 2.11 & 2.12, and Java compatibility 8 & 9

What’s new in Anorm 2.5

This page highlights the new features of Anorm 2.5. If you want learn about the changes you need to make to migrate to Anorm 2.5, check out the Migration Guide.

• Row parser automatically generated for case classes: Macro.namedParser[T], Macro.indexedParser[T] and Macro.parser[T](names).
• New SqlParser.folder to fold over “non-strict” row columns.
• New numeric and temporal conversions.

What’s new in Anorm 2.4

This page highlights the new features of Anorm 2.4. If you want learn about the changes you need to make to migrate to Anorm 2.4, check out the Migration Guide.

• Improved statement preparation & string interpolation: new #$value syntax and better performance.
• New positional getter on Row.
• Unified column resolution by label, whatever it is (name or alias).
• New streaming API; Functions fold and foldWhile to work with result stream (e.g. SQL"Select count(*) as c from Country".fold(0l) { (c, _) => c + 1 }). Function withResult to provide custom stream parser (e.g. SQL("Select name from Books").withResult(customTailrecParser(_, List.empty[String]))).
• Supports array (java.sql.Array) from column (e.g. SQL("SELECT str_arr FROM tbl").as(scalar[Array[String]].*)) or as parameter (e.g. SQL"""UPDATE Test SET langs = ${Array("fr", "en", "ja")}""".execute()).
• Improved conversions for numeric and boolean columns.
• New conversions for binary columns (bytes, stream, blob), to parsed them as Array[Byte] or InputStream.
• New conversions for temporal types. For Java8 Instant, LocalDateTime, ZonedDateTime, Joda Instant or DateTime, from Long, Date or Timestamp column.
• Added conversions to support List[T], Set[T], SortedSet[T], Stream[T] and Vector[T] as multi-value parameter.
• New conversion to parse text column as UUID (e.g. SQL("SELECT uuid_as_text").as(scalar[java.util.UUID].single)).