package com.project.whatsappchatbot.repository;

import com.project.whatsappchatbot.model.Mechanic;
import com.project.whatsappchatbot.model.UserResponse;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Optional;

public interface MechanicRepository extends JpaRepository<Mechanic, Long> {


 Optional<Mechanic> findByPhone(String phone);
    long countByJobAssignedCount(String jobAssignedCount);

    @Query(value = "SELECT m FROM Mechanic m WHERE m.phone LIKE %:phoneNumber%")
    Page<Mechanic> findByPhoneContaining(@Param("phoneNumber") String phoneNumber, Pageable pageable);

}