package com.project.whatsappchatbot.repository;

import java.util.Optional;

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

import com.project.whatsappchatbot.model.Account;

public interface AccountRepository extends JpaRepository<Account, Long> {
	Account findByUsername(String username);

	boolean existsByUsername(String username);

	Optional<Account> findByPhone(String phoneNumber);

	Optional<Account> findByEmail(String email);

	
	 // Random record với MySQL
    @Query(value = "SELECT * FROM accounts ORDER BY RAND() LIMIT 1", nativeQuery = true)
    Account findRandomUser();
	
	
}