package dbaccess

import java.sql.{SQLException, ResultSet, Connection}

import anorm.SQL
import models.User
import org.h2.tools.TriggerAdapter


class TriggerTest extends TriggerAdapter{
  override def fire(implicit connection: Connection, resultSet: ResultSet, resultSet1: ResultSet): Unit = {

    val name = resultSet1.getString("name");

    val result = SQL("SELECT count(User.name) FROM User where User.name = {name};").on("name" -> name)
                        .map(row => User(row[Long]("id"), row[String]("name"))).singleOpt().contains()

    if (!result) throw new SQLException("name bereits vorhanden")
  }

}