de.terrestris.shogun2.hibernate.SimpleJsonbConverter Maven / Gradle / Ivy
package de.terrestris.shogun2.hibernate;
import de.terrestris.shogun2.util.json.Shogun2JsonObjectMapper;
import org.apache.logging.log4j.Logger;
import javax.persistence.AttributeConverter;
import javax.persistence.Converter;
import java.io.IOException;
import java.util.HashMap;
import java.util.Map;
import static org.apache.logging.log4j.LogManager.getLogger;
/**
* A JPA converter that can be used to convert jsonb fields into a map. Currently only works with 'simple' json
* content (only one level objects like {"name": "peter", "someprop": 345}).
*
* Please note that you'll need to switch to pgjdbc-ng from https://github.com/impossibl/pgjdbc-ng instead of using the
* standard postgres driver.
*
* Please also note that if you want optimal performance you'll need to add an index manually, hibernate can only create
* btree indexes.
*/
@Converter(autoApply = true)
public class SimpleJsonbConverter implements AttributeConverter, String> {
private static final Logger LOG = getLogger(SimpleJsonbConverter.class);
@Override
public String convertToDatabaseColumn(Map attribute) {
Shogun2JsonObjectMapper mapper = new Shogun2JsonObjectMapper();
try {
return (mapper.writeValueAsString(attribute));
} catch (Exception e) {
LOG.warn("Could not convert JSON value to PostgreSQL format: " + e.getMessage());
LOG.debug("Stack trace: " + e.toString());
}
return "{}";
}
@Override
public Map convertToEntityAttribute(String dbData) {
Shogun2JsonObjectMapper parser = new Shogun2JsonObjectMapper();
try {
return parser.readValue(dbData, HashMap.class);
} catch (IOException e) {
LOG.warn("Could not convert JSON value from PostgreSQL format: " + e.getMessage());
LOG.debug("Stack trace: " + e.toString());
}
return new HashMap<>();
}
}