Btukfyl

these are random client and course repos

@Singleton

class CourseRepository @Inject()(dbConfigProvider: DatabaseConfigProvider)(implicit ec: ExecutionContext) {



  // We want the JdbcProfile for this provider

  val dbConfig = dbConfigProvider.get[JdbcProfile]



  import dbConfig._

  import profile.api._



  class CourseTable(_tableTag: Tag) extends Table[Course](_tableTag, "course") {

    def * = (courseId, name) <> ((Course.apply _).tupled, Course.unapply)



    def ? = (Rep.Some(courseId), Rep.Some(name)).shaped.<>({ r => import r._; _1.map(_ => (Course.apply _).tupled((_1.get, _2.get))) }, (_: Any) => throw new Exception("Inserting into ? projection not supported."))



    val courseId: Rep[Int] = column[Int]("course_id", O.PrimaryKey)

    val name: Rep[String] = column[String]("name", O.Length(255, varying = true))

  }



  private val courses = TableQuery[CourseTable]



  def create(course: Course) = db.run {

    courses += course

  }



  def findById(courseId: Int): Future[Course] = db.run {

    courses.filter(_.courseId === courseId).result.head

  }



  def createMany(courseList:Seq[Course]) = db.run{

    courses ++= courseList

  }



  def list(): Future[Seq[Course]] = db.run {

    courses.result

  }

}



@Singleton

class ClientRepository @Inject()(dbConfigProvider: DatabaseConfigProvider)(implicit ec: ExecutionContext) {

  // We want the JdbcProfile for this provider

  private val dbConfig = dbConfigProvider.get[JdbcProfile]



  import dbConfig._

  import profile.api._



    private class ClientTable(tag: Tag) extends Table[Client](tag, "client") {

      def * = (userId, name) <> ((Client.apply _).tupled, Client.unapply)



      def ? = (Rep.Some(userId), Rep.Some(name)).shaped.<>({ r => import r._; _1.map(_ => (Client.apply _).tupled((_1.get, _2.get))) }, (_: Any) => throw new Exception("Inserting into ? projection not supported."))



      val userId: Rep[Int] = column[Int]("client_id", O.PrimaryKey, O.AutoInc)

      val name: Rep[String] = column[String]("name", O.Length(255, varying = true))

    }



  private val people = TableQuery[ClientTable]



  def create(client: Client) = db.run {

    people += client

  }



  def findById(clientId: Int) = db.run {

    people.filter(_.userId === clientId).result.head

  }



  def list(): Future[Seq[Client]] = db.run {

    people.result

}
}

What my problem is, i have a 3rd table client_course, where i map many to many relation between these two tables, and to do join i have to access client table and course table, but my client_course repo is in another class and i cant simply access table from clientrepo or courserepo, so my question is, how do i write a client_course repo and access tables i need to do some join queries?

example

    for {

      (client, course) <- clients join courses

    } yield (client, course)

to do so i have to access clients and courses table, which are managed by other repos, should i simply put TableQuery for client and course in my client_course repo?

like so

  private val clientCourses = TableQuery[ClientCourse]

  private val courses = TableQuery[Course]

  private val clients = TableQuery[Client]