sql
interpolator允许作为给定GetResult实例的结果的事例类
val action:DBIO[Seq[VisibilityRow]] = sql"SELECT * FROM visibility".as[VisibilityRow] //compiles fine
在查看文档时,我没有看到将tsql
与case类一起使用的示例。
我决定试试
val action2:DBIO[Seq[VisibilityRow]] = tsql"SELECT * FROM visibility"
然而,我得到错误
[error] ... : type mismatch;
[error] found : slick.profile.SqlStreamingAction[Vector[(Long, String, java.sql.Timestamp, java.sql.Timestamp, java.sql.Timestamp)],(Long, String, java.sql.Timestamp, java.sql.Timestamp, java.sql.Timestamp),slick.dbio.Effect]
[error] required: slick.driver.PostgresDriver.api.DBIO[Seq[com.fevo.slick.Schema.VisibilityRow]]
[error] (which expands to) slick.dbio.DBIOAction[Seq[com.fevo.slick.Schema.VisibilityRow],slick.dbio.NoStream,slick.dbio.Effect.All]
[error] val action2:DBIO[Seq[VisibilityRow]] = tsql"SELECT * FROM visibility"
有没有一种优雅的方法可以让我使用tsql
提取这些类型,我可以映射到应用程序上,但我仍然需要相应地为DBIO
的参数指定(和更新)元组类型。
如果case类构造函数与您的字段匹配,您可以简单地映射结果以获得所需的类型:
val action2:DBIO[Seq[VisibilityRow]] =
tsql"SELECT * FROM visibility".map(_.map(VisibilityRow.apply.tupled))