package com.revature.domain;

import java.util.List;

import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface PersonRepository extends CrudRepository<Person,Integer> {

	List<Person> findByLastName(String lastName);
	
}

@@ -79,16 +79,20 @@
 rk.data.
+jpa.
 reposito
@@ -94,21 +94,68 @@
 ository.
-CrudR
+JpaRepository;%0Aimport org.springframework.data.jpa.r
 epositor
@@ -147,32 +147,38 @@
 a.jpa.repository
+.Query
 ;%0Aimport org.spr
@@ -272,12 +272,11 @@
 nds 
-Crud
+Jpa
 Repo
@@ -319,16 +319,19 @@
 on%3E find
+All
 ByLastNa
@@ -352,11 +352,636 @@
 Name);%0A%09
+List%3CPerson%3E findAllByFirstName(String firstName);%0A%09List%3CPerson%3E findAllByFirstNameAndLastName(String firstName, String lastName);%0A%09%0A%09@Query(%22SELECT ie_person.p_firstname, ie_person.p_lastname, ie_person.p_id FROM ie_person INNER JOIN ie_eval ON ie_person.p_id=ie_eval.e_pid_trainee WHERE ie_eval.e_batch=?1%22)%0A%09List%3CPerson%3E findAllByBatchId(int id);%0A%09%0A%09@Query(%22SELECT ie_person.p_firstname, ie_person.p_lastname, ie_person.p_id FROM ie_person INNER JOIN ie_eval ON ie_person.p_id=ie_eval.e_pid_trainee INNER JOIN ie_person ON ie_eval.e_batch=ie_batch.b_id WHERE b_name=?1%22)%0A%09List%3CPerson%3E findAllByBatchName(String batchName);
 %0A%7D%0A

create placeholder getAllMembersByBranch methods