package services

import scala.slick.driver.PostgresDriver.simple._

import data.Article

class ArticleService extends BaseService[Article] {
  import data.DbContext._

  override def count: Long =
    transaction { implicit session =>
      articles.length.run
    }

  override def update(entity: Article): Article =
    transaction { implicit session =>
      articles.update(entity)
      entity
    }

  override def findById(id: Long): Option[Article] =
    transaction { implicit session =>
      articles.filter(_.id === id).firstOption
    }

  override def findAll(page: Int, items: Int): List[Article] =
    transaction { implicit session =>
      articles.drop((page - 1) * items).take(items).list
    }

  override def remove(id: Long): Unit =
    transaction { implicit session =>
      articles.filter(_.id === id).delete
    }

  override def add(entity: Article): Article =
    transaction { implicit session =>
      articles.insert(entity)
      entity
    }
}