im.actor.server.persist.auth.GateAuthCodeRepo.scala Maven / Gradle / Ivy

Go to download
package im.actor.server.persist.auth

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

final class GateAuthCodeTable(tag: Tag) extends Table[model.auth.GateAuthCode](tag, "gate_auth_codes") {
  def transactionHash = column[String]("transaction_hash", O.PrimaryKey)
  def codeHash = column[String]("code_hash")
  def isDeleted = column[Boolean]("is_deleted")

  def * = (transactionHash, codeHash, isDeleted) <> (model.auth.GateAuthCode.tupled, model.auth.GateAuthCode.unapply)
}

object GateAuthCodeRepo {
  def codes = TableQuery[GateAuthCodeTable]

  val active = codes.filter(_.isDeleted === false)

  def createOrUpdate(transactionHash: String, codeHash: String) =
    codes.insertOrUpdate(model.auth.GateAuthCode(transactionHash, codeHash))

  def find(transactionHash: String) =
    active.filter(_.transactionHash === transactionHash).result.headOption

  def delete(transactionHash: String) =
    codes.filter(_.transactionHash === transactionHash).map(_.isDeleted).update(true)

}