質問編集履歴

モデル（リポジトリ）の追加

2021/07/09 10:48

投稿

スコア3

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -162,7 +162,11 @@
 ```
-### index.html.scala （テンプレート）
+### index.scala.html （テンプレート）
 ```
@@ -188,7 +192,81 @@
 ```
+### PresonRepository.scala (リポジトリ）
+```
+package models
+import javax.inject.{ Inject, Singleton }
+import play.api.db.slick.DatabaseConfigProvider
+import slick.jdbc.JdbcProfile
+import scala.concurrent.{ Future, ExecutionContext }
+@Singleton
+class PersonRepository @Inject()
+  (dbConfigProvider: DatabaseConfigProvider)
+  (implicit ec: ExecutionContext) {
+  private val dbConfig = dbConfigProvider.get[JdbcProfile]
+  import dbConfig._
+  import profile.api._
+  private class PeopleTable(tag: Tag)
+    extends Table[Person](tag, "people") {
+    def id = column[Int]("id", O.PrimaryKey, O.AutoInc)
+    def name = column[String]("name")
+    def mail = column[String]("mail")
+    def tel = column[String]("tel")
+    def * = (id, name, mail, tel) <>
+      ((Person.apply _).tupled, Person.unapply)
+  }
+  private val people = TableQuery[PeopleTable]
+  def list(): Future[Seq[Person]] = db.run {
+    people.result
+  }
+}
+```
 ### バージョン