database - 会简化插入到具有自动生成的主键的表吗？

Question

在 Slick 1.x 中，使用自动生成的主键插入到一个表中有点复杂:您必须手动创建一个省略 pk 的表投影以用于插入目的。看起来 Slick 2.x 会解决这个问题:

Soft inserts are now the default, i.e. AutoInc columns are automatically skipped when inserting with +=, ++=, insert and insertAll. This means that you no longer need separate projections (without the primary key) for inserts.

但是 2.x 文档不能更新:

While some database systems allow inserting proper values into AutoInc columns or inserting None to get a created value, most databases forbid this behaviour, so you have to make sure to omit these columns. Slick does not yet have a feature to do this automatically but it is planned for a future release. For now, you have to use a query with a custom projection which does not include the AutoInc column

有人知道使用 AutoInc 插入表并取回生成的键的新 2.0 语法吗？

Answer 1

插入的语法与 1.0 中的相同，只是现在自动忽略 autoinc 列。所以 .insert 的作用发生了语义上的变化。如果您想要旧行为(包含它们的地方)，您必须调用 .forceInsert。