gistfile1.txt

def findByEmail(email: String): Option[NativeUser] = {
    DB.withConnection{ implicit connection =>
      SQL("SELECT id, firstName, lastName, email, password, hasAvatar FROM appUser WHERE email={email}").on('email -> email)().collectFirst {
        case Row(id: Long, firstName: String, lastName: String, email: String, password: String, hasAvatar: Boolean) => NativeUser(anorm.Id(id), firstName, lastName, email, password, hasAvatar)
      }
    }
  }