package com.sonymusic.dx.dxadvsearchservice.util;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;

import jakarta.persistence.EntityManager;
import jakarta.persistence.PersistenceContext;
import jakarta.persistence.Query;

@Service
public class ConvertString {

	@PersistenceContext(name = "dx-gras-persistence")
	private EntityManager em;

	private final Logger log = LoggerFactory.getLogger(getClass());

	public String convertString(String input) {
		try {
			String sql = "select smetools.string_translate_used_in_match(" + "'" + input + "') ";
			Query query = em.createNativeQuery(sql);
			Object result = query.getSingleResult();
			if (result != null) {
				return result.toString();
			} else
				return null;
		} catch (Exception e) {
			log.error("Exception occured while converting the input for " + input);
			return null;
		}
	}

}