• Home
• im.actor.server
• actor-persist
• 3.0.0
• source code
• UserDepartmentRepo.scala

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

im.actor.server.persist.UserDepartmentRepo.scala Maven / Gradle / Ivy

package im.actor.server.persist

import im.actor.server.db.ActorPostgresDriver.api._
import im.actor.server.model.UserDepartment

final class UserDepartmentTable(tag: Tag) extends Table[UserDepartment](tag, "user_department") {
  def userId = column[Int]("user_id", O.PrimaryKey)
  def departmentId = column[Int]("department_id", O.PrimaryKey)

  def * = (userId, departmentId) <> (UserDepartment.tupled, UserDepartment.unapply)
}

object UserDepartmentRepo {

  val userDepartments = TableQuery[UserDepartmentTable]

  def create(userId: Int, departmentId: Int) =
    userDepartments += UserDepartment(userId, departmentId)

  def userIdsByDepartmentId(deptId: Int) =
    userDepartments.filter { _.departmentId === deptId }.map { _.userId }.result

}