为什么编译失败并显示“not found：value Users”？

Question

我想从我的默认数据库postgres检索一行。我已经定义了表格“用户”。

CONF/application.conf

db.default.driver=org.postgresql.Driver 
db.default.url="jdbc:postgresql://localhost:5234/postgres" 
db.default.user="postgres" 
db.default.password="" 

控制器/ Application.scala

package controllers 

import models.{UsersDatabase, Users} 
import play.api.mvc._ 

object Application extends Controller { 

    def index = Action { 
    Ok(views.html.index(UsersDatabase.getAll)) 
    } 
} 

模型/ Users.scala

package models 

import java.sql.Date 
import play.api.Play.current 
import play.api.db.DB 
import slick.driver.PostgresDriver.simple._ 

case class User(
    id: Int, 
    username: String, 
    password: String, 
    full_name: String, 
    email: String, 
    gender: String, 
    dob: Date, 
    joined_date: Date 
) 

class Users(tag: Tag) extends Table[User](tag, "Users") { 

    def id = column[Int]("id") 
    def username = column[String]("username", O.PrimaryKey) 
    def password = column[String]("password") 
    def full_name = column[String]("full_name") 
    def email = column[String]("email") 
    def gender = column[String]("gender") 
    def dob = column[Date]("dob") 
    def joined_date = column[Date]("joined_date") 
    def * = (id, username, password, full_name, email, gender, dob, joined_date) <> (User.tupled, User.unapply) 
} 

object UsersDatabase { 

    def getAll: List[User] = { 
     Database.forDataSource(DB.getDataSource()) withSession { 
      Query(Users).list 
     } 
    } 
} 

当访问http://localhost:9000/它使编译错误：

[error] .../app/models/Users.scala:36: not found: value Users 
[error]    Query(Users).list 
[error]     ^
[error] one error found 
[error] (compile:compile) Compilation failed 

如何妥善解决这个错误和访问数据？

Answer 1

编译错误消息说明了这一切 - 在范围内没有值Users。

更改对象UsersDatabase看起来如下：

object UsersDatabase { 

    val users = TableQuery[Users] 

    def getAll: List[User] = { 
     Database.forDataSource(DB.getDataSource()) withSession { implicit session => 
      users.list 
     } 
    } 
} 

和错误消失，因为你使用本地val users列出数据库中的用户。

一样光滑session val的官方文档中描述Querying是list的隐含价值（如final def list(implicit session: SessionDef): List[R]），因此implicit session在块：

All methods that execute a query take an implicit Session value. Of course, you can also pass a session explicitly if you prefer:

val l = q.list(session)