|
3月21日 深圳 OSC 源创会开始报名罗,送华为海思开发板
Slick 是 TypeSafe 推出的 Scala 数据库访问库。开发者可以使用 Scala 语言风格来编写数据查询,而不是用 SQL,示例代码:
object?Coffees?extends?Table[(String,?Int,?Double)]("COFFEES")?{
??def?name?=?column[String]("COF_NAME",?O.PrimaryKey)
??def?supID?=?column[Int]("SUP_ID")
??def?price?=?column[Double]("PRICE")
??def?*?=?name?~?supID?~?price
}
Coffees.insertAll(
??("Colombian",?101,?7.99),
??("Colombian_Decaf",?101,?8.99),
??("French_Roast_Decaf",?49,?9.99)
)?
val?q?=?for?{
??c??println(n?+?":?"?+?p)?}
Scala Slick 3.0.0 RC1 发布,源代码现已提供在:https://github.com/slick/slick/tree/3.0.0-RC1。Scala 2.10 (推荐 2.10.4) 和 2.11 (推荐 2.11.4) 构建现已提供在 Maven Central。
Slick 3.0 主要特性:
- A new API for composing and executing database actions.
- Support for the Reactive Streams API for streaming results from the database.
- Improved configuration of database connections via Typesafe Config, including built-in
support for HikariCP.
- Support for nested Option types and non-primtive Option types in the Lifted Embedding.
- Properly typed outer join operators based on the improved Option support.
- A new macro-based implementation of the Plain SQL API with optional compile-time checking
and type inference for embedded SQL statements.
- Many small improvements and bug fixes in the schema code generator.
- Optional multi-line formatting and indenting of generated SQL code for more readable
debug output.
更新了大部分手册;“Slick Testkit” 和 “Plain SQL Queries” 章节将会尽快更新;将会尽快提供标准 Activator 模板。
如果没有发现什么重大问题,将会在后两周发布 Slick 3.0.0 最终版本!
Slick 2.1.0 以来的完整改进列表:
- bd0c9c4 Try to prevent some spurious failures on Travis CI
- 58a1db9 Proper treatment of CHAR(1) columns in JdbcModelBuilder:
- 7f0f62f Make code generator tests usable from other slick-extensions:
- 25370cb Fix bugs detected by Slick Extensions upgrade:
- 12faf5d Upgrade to Reactive Streams 1.0.0.RC3
- 648184c Package structure and project layout refactoring:
- 9c730c0 Upgrade to Reactive Streams 1.0.0.RC2:
- 24770de Add DatabaseConfig as a higher-level configuration abstraction:
- 759cbc2 Restore #$ support in the macro-based Plain SQL interpolation:
- 62ddadc Macro-based PlainSQL API Implemented TypedStaticQuery as tsql
- d63a018 UUID regression testkit:
- 0a44b74 Update LiftedEmbedding.scala
- 5af0d9b Distinguish between BLOB and BYTEA in PostgreSQL model builder
- ec7f2aa Use TestDB for code generator tests:
- cc8d3f0 Proper support for string lengths:
41c717a Support fetch>
- 965604c Use force-insert semantics for inserting from queries and expressions.
- 0e58e7d Deprecate the Direct Embedding
- 0ba0dd5 Remove the blocking API that was introduced in 3.0.0-M1
- 2f64c79 Rename Action to DBIO:
- 86974bd Simplify SQLBuilder and formatting/indenting:
- 20378ec Quote SqlType argument in code generator.
- b1dca21 Make ColumnOptions more modular:
- 7272180 Use unconstrained text type as default on PostgreSQL
- 6cec3f7 Prefer prepareStatement(sql) instead of prepareStatement(sql, Int, Int)
- a3eec4f Support transaction isolation levels
- 6ea7fdb Generic fusion implementation for FlatMapAction and CleanupAction:
- 706f2b1 Allow the SQL statements to be overridden in SqlActions.
- a325f5e Run a user-defined init function on all created JDBC Statements
- 3315a3b Refactoring of ActionContext:
- dc687de Avoid long nested sequences of SchemaDescription.++ in generated code:
62d5e92 Quote illegal>
- 58c4ed5 Make ‘desiredColumnOrder’ in code generator non-final.
- a645205 Support statement parameters in the new Action-based API.
- b1c5b66 Switch JDBC metadata API and code generator to the new API.
- c92a615 Fix typo in orm-to-slick.rst
- d4f019f Move profile-level Action definitions outside of profiles.
- 5cd423f Deprecate Invoker convenience methods and iteratees
- 7d576c8 Properly deprecate .Implicit and .simple in all profile levels
- 30c135e Upgrade to sbt 0.13.7
- e9274ec Improve build system for documentation:
- a6e3b9b Further modularization of Slick:
- 4ab4a6b Switch Direct Embedding over to the new Action-based API.
- ac37f1c Update documentation for 3.0:
- e6562c7 Simplify Action Effect handling:
- 06d1ca0 Increase timeout for Reactive Streams TCK tests.
- efbe6f6 Bump version numbers:
- 4d42528 Add concurrency stress test for streaming API:
- 80929a6 Documentation plus minor improvements and fixes:
- 273b957 Update to Reactive Streams 1.0.0.M3 and fix remaining PR review issues:
- 688d7f2 Convert more test cases and add missing features:
- d862e0f Optimize the streaming engine and fix some bugs:
- 9ad62a9 Implement streaming via Reactive Streams API:
- 6a85767 Convert several test cases to the new API.
- 8ef6cde Add basic transaction support for database actions.
- 09590fd Implement session pinning for database Actions:
- 66a9b41 Basic implementation of action monad and asynchronous execution engine:
- bf17772 Use HikariCP by default (instead of no connection pooling):
- 4569c52 Simplify connection pool configuration
- cc92c26 Simplify thread pool configuration:
- 423e78c Remove the option to disable auto-commit for new connections.
- e4dddcd Remove BoneCP support and drop configuration compatibility with Play.
- 812100e Add HikariCP support in addition to BoneCP.
- bb58103 Add primitives and configuration for async execution of blocking I/O
- 0ea777a Fix broken build due to merging nested options support
- 8d4a02f Ensure generated file ends with a newline character.
- 9cdf7ec Make comment format match others in file.
- ef5f9a8 Avoid indenting blank lines, to avoid trailing whitespace.
- 8225a8f Add Option-extended joins:
- 75583dc Lifted Embedding encoding of nested and multi-column Option types:
- de389a4 Remove the Column type.
- 5da96b4 Update orm-to-slick.rst
- 7a1d119 modified to use GlobalConfig.
- 777dbeb Add SimpleLiteral factory (and fix one unrelated unchecked warning)
- 82b258f Use Unicode symbols in tree and table dumps for better readability.
- f54d272 Add BoneCP support to Database.forConfig.
- 369ad73 Use application.conf for Slick settings.
- 61d032b Corrected docs to use “inSet” instead of “inSeq”
- b0b0252 Fix forceInsertAll for single argument
- 770d0a1 Update build for 2.2.0-SNAPSHOT
- cb8183d Added support for string function repeat.
- 57aa9e7 Workaround to pass Travis CI.
- 7a58f7f Try for SQL String Indentation.
更多改进内容请看发行说明。
|
|
|