SRPatterns.scala

package models
  
import anorm.SQL
import anorm.SqlStringInterpolation
import java.sql.Connection
import anorm.RowParser
import anorm.ResultSetParser

trait Findable[T] {
  val table: String
  val pk: String
  val parser: RowParser[T]

  def findById(id: Int)(implicit connection:Connection): Option[T] = {
    val query = s"SELECT * FROM $table WHERE $pk = $id"
    SQL(query).as(parser.singleOpt)
  }

  lazy val multiParser: ResultSetParser[List[T]] = {
    parser *
  }
}

trait FindableBySubscriber[T] extends Findable[T]{
  def findBySubscriber(id: Int)(implicit connection:Connection): List[T] = {
    val query = s"SELECT * FROM $table WHERE subscriber_idx = $id"
    SQL(query).as(multiParser)
  }

}

trait FindableByPatron[T] extends Findable[T]{
  def findByPatron(id: Int)(implicit connection:Connection): Option[T] = {
    val query = s"SELECT * FROM $table WHERE user_idx = $id"
    SQL(query).as(parser.singleOpt)
  }
}

trait SRModel[T] 
  extends Findable[T] 
  with FindableBySubscriber[T]
  with FindableByPatron[T]
  {
  }