trait QueryCommands {
  val records = TableQuery[TODOTable]
  val dbConfig = DatabaseConfigProvider.get[JdbcProfile](Play.current)

  def find(id: Long) = {
    dbConfig.db.run(find_query(id).result.headOption)
  }

  def all = {
    dbConfig.db.run(records.result)
  }

  def destroy(id: Long) = {
    dbConfig.db.run(find_query(id).delete)
  }

  protected

  def find_query(id: Long) = {
    records.filter(_.id === id)
  }
}

object TODOs extends QueryCommands {
  override val records = TableQuery[TODOTable]

  def update(id: Long, values: (String, Boolean)) = {
    var record = find_query(id).map(result => (result.text, result.is_performed))

    dbConfig.db.run(record.update(values))
  }

  def create(record: TODO) = {
    dbConfig.db.run(records += record)
  }
}