remote-be/src/main/java/it/bgates/remotebe/repository/ConfigRepository.java

package it.bgates.remotebe.repository;

import it.bgates.remotebe.entities.Config;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.Optional;

public interface ConfigRepository extends JpaRepository<Config, String> {

    @Query("select cast(c.value as int) from Config c where c.name=:name")
    Integer getCostByName(String name);

    @Query("select cast(c.value as Double) from Config c where c.name=:name")
    Double getCostByNameAsDouble(String name);

    Optional<Config> findByName(String name);

}