gistfile1.txt

  def addNewAccount(email: String, password: String, firstName: String, role: Role)(implicit s: DBSession = auto) {
    val id = withSQL {
      val pass = BCrypt.hashpw(password, BCrypt.gensalt())
      QueryDSL.insert.into(Account).namedValues(
        ac.email -> email,
        ac.password -> pass,
        ac.name -> firstName,
        ac.role -> role.toString()
      )
    }.updateAndReturnGeneratedKey.apply()
  }