package com.project.whatsappchatbot.repository;

import java.util.List;

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

import com.project.whatsappchatbot.model.Customer;

public interface CustomerRepository extends JpaRepository<Customer, Long> {


    boolean existsByPhone(String phoneNumber);

    Customer findByPhone(String phoneNumber);

    List<Customer> findByPhoneContaining(String phoneNumber);
    
    
    
    // Random record với MySQL
    @Query(value = "SELECT * FROM users ORDER BY RAND() LIMIT 1", nativeQuery = true)
    Customer findRandomUser();
}