播放 2.4 - Slick 3.0.0 - DELETE 不工作
我正在尝试升级到 Slick 3.0.0 和 Play 2.4 (Scala),但是删除行不起作用.在下面的代码中,一切正常:查询所有行,插入和更新 - 除了删除.
I am trying to upgrade to Slick 3.0.0 and Play 2.4 (Scala), but deleting rows is not working. In the code below, everything works: querying all rows, inserting and updating - except delete.
package dao
import scala.concurrent.Future
import models._
import models.Tables._
import play.api.Play
import play.api.db.slick.DatabaseConfigProvider
import play.api.db.slick.HasDatabaseConfig
import play.api.libs.concurrent.Execution.Implicits.defaultContext
import slick.driver.JdbcProfile
class UserDAO extends HasDatabaseConfig[JdbcProfile] {
protected val dbConfig = DatabaseConfigProvider.get[JdbcProfile](Play.current)
import driver.api._
def all(): Future[List[UserRow]] = db.run(Tables.User.result).map(_.toList)
def findByEmail(email: String): Future[Option[UserRow]] = {
db.run(Tables.User.filter(_.email === email).result.headOption)
}
def update(id: Int, newData: UserRow): Future[Int] = {
db.run(Tables.User.filter(_.id === id).update(newData))
}
def delete(id: Int): Future[Int] = {
db.run(Tables.User.filter(_.id === id).delete)
}
}
代码生成以下编译错误:
The code generates the following compilation error:
value delete is not a member of slick.lifted.Query[models.Tables.User,models.Tables.User#TableElementType,Seq]
我在application.conf中使用slick.driver.MySQLDriver$/com.mysql.jdbc.Driver,models.Tables.scala文件是slick-codegen lib自动生成的.
I am using slick.driver.MySQLDriver$ / com.mysql.jdbc.Driver in the application.conf, and the models.Tables.scala file is automatically generated by slick-codegen lib.
谁能帮我解决这个问题?谢谢!
Can anyone help me to fix this? Thanks!
推荐答案
尝试导入更具体的 API,而不是 import driver.api._
使用 import slick.driver.MySQLDriver.api._
.
Try importing a more specific API, so instead of import driver.api._
use import slick.driver.MySQLDriver.api._
.
我刚刚遇到了同样的问题,发现了这个关于 slick 的错误报告:https://github.com/playframework/play-slick/issues/249
I just had the same issue and found this bug report for slick: https://github.com/playframework/play-slick/issues/249
相关文章