package com.infinite.focus.server.auth;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;


/**
 * 
 * @author Saboor
 * 
 *
 */
//Handles CRUD operations for user accounts
public interface AccountRepository extends JpaRepository<Account, Long> {
	
	//Find row by user name column
     Account findByUsername(String username);
  
   //Find row by user name 2 column
     Account findByUsername2(String username2);
     
   //Find row by user name column
 	@Query(value = "SELECT * FROM account WHERE account_id = ?1", nativeQuery = true)
     Account findByAccountId(long account_id);
  	 
}