diff options
Diffstat (limited to 'DNPMPlugins/src/main/java/ATCCodes/services')
5 files changed, 263 insertions, 0 deletions
diff --git a/DNPMPlugins/src/main/java/ATCCodes/services/AgentCodeService.java b/DNPMPlugins/src/main/java/ATCCodes/services/AgentCodeService.java new file mode 100644 index 0000000..8057008 --- /dev/null +++ b/DNPMPlugins/src/main/java/ATCCodes/services/AgentCodeService.java @@ -0,0 +1,23 @@ +package ATCCodes.services; + +import ATCCodes.AgentCode; + +import java.util.List; + +/** + * Common interface for agent code services + * + * @author Paul-Christian Volkmer + */ +public interface AgentCodeService { + + /** + * Queries source for agents with name and code starting with query string. + * If size is zero, all available results will be returned. + * + * @param query The query string + * @param size Maximal amount of responses + * @return A list with agent codes + */ + List<AgentCode> findAgentCodes(String query, int size); +}
\ No newline at end of file diff --git a/DNPMPlugins/src/main/java/ATCCodes/services/CsvAtcCodeService.java b/DNPMPlugins/src/main/java/ATCCodes/services/CsvAtcCodeService.java new file mode 100644 index 0000000..fa834e7 --- /dev/null +++ b/DNPMPlugins/src/main/java/ATCCodes/services/CsvAtcCodeService.java @@ -0,0 +1,51 @@ +package ATCCodes.services; + +import ATCCodes.AgentCode; +import ATCCodes.AtcCode; +import ATCCodes.FileParsingException; +import org.apache.commons.csv.CSVFormat; +import org.springframework.core.io.ResourceLoader; +import org.springframework.stereotype.Service; + +import java.io.IOException; +import java.io.InputStreamReader; +import java.util.ArrayList; +import java.util.List; + +/** + * Service to query for agent codes based on WHO xml file + * + * @author Paul-Christian Volkmer + * @since 0.1.0 + */ +@Service +public class CsvAtcCodeService extends FileBasedAgentCodeService { + + public CsvAtcCodeService(final ResourceLoader resourceLoader) { + super(resourceLoader); + } + + protected List<AgentCode> parseFile(final ResourceLoader resourceLoader) { + var result = new ArrayList<AgentCode>(); + var filename = getFilePath("atc.csv"); + try { + var inputStream = resourceLoader.getResource(filename).getInputStream(); + var parser = CSVFormat.RFC4180 + .withHeader() + .withSkipHeaderRecord() + .parse(new InputStreamReader(inputStream)); + for (var row : parser) { + if (!row.isMapped("CODE") || !row.isMapped("NAME")) { + throw new FileParsingException("No CSV column 'CODE' or 'NAME' found"); + } + result.add(new AtcCode(row.get("CODE"), row.get("NAME"))); + } + logger.info("Found CSV file for ATC-Codes."); + return result; + } catch (IOException | FileParsingException e) { + logger.warn("Error reading CSV file '{}' for ATC-Codes. Proceeding without data", filename); + } + return result; + } + +}
\ No newline at end of file diff --git a/DNPMPlugins/src/main/java/ATCCodes/services/FileBasedAgentCodeService.java b/DNPMPlugins/src/main/java/ATCCodes/services/FileBasedAgentCodeService.java new file mode 100644 index 0000000..17ba389 --- /dev/null +++ b/DNPMPlugins/src/main/java/ATCCodes/services/FileBasedAgentCodeService.java @@ -0,0 +1,63 @@ +package ATCCodes.services; + +import ATCCodes.AgentCode; +import org.apache.commons.lang.SystemUtils; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; +import org.springframework.core.io.ResourceLoader; + +import java.util.ArrayList; +import java.util.List; +import java.util.stream.Collectors; + +/** + * Abstract {@link AgentCodeService} for use with files that will load information into memory + * + * @author Paul-Christian Volkmer + * @since 0.1.0 + */ +public abstract class FileBasedAgentCodeService implements AgentCodeService { + + protected final Logger logger = LoggerFactory.getLogger(this.getClass()); + + protected final List<AgentCode> codeList = new ArrayList<>(); + + FileBasedAgentCodeService(final ResourceLoader resourceLoader) { + this.codeList.addAll(parseFile(resourceLoader)); + } + + static String getFilePath(final String filename) { + String pluginPathPart = "onkostar/files/onkostar/plugins/onkostar-plugin-atccodes"; + + if (SystemUtils.IS_OS_WINDOWS) { + return String.format("file:///c:/%s/%s", pluginPathPart, filename); + } else if (SystemUtils.IS_OS_LINUX) { + return String.format("file:///opt/%s/%s", pluginPathPart, filename); + } + return filename; + } + + protected abstract List<AgentCode> parseFile(final ResourceLoader resourceLoader); + + /** + * Queries source for agents code starting with or name containing query string. + * If size is zero, all available results will be returned. + * + * @param query The query string + * @param size Maximal amount of responses + * @return A list with agent codes + */ + @Override + public List<AgentCode> findAgentCodes(final String query, final int size) { + var resultStream = this.codeList.stream().filter(agentCode -> + agentCode.getCode().toLowerCase().startsWith(query.toLowerCase()) + || agentCode.getName().toLowerCase().contains(query.toLowerCase()) + ); + + if (size > 0) { + return resultStream.limit(size).collect(Collectors.toList()); + } + return resultStream.collect(Collectors.toList()); + } + +}
\ No newline at end of file diff --git a/DNPMPlugins/src/main/java/ATCCodes/services/OnkostarAgentCodeService.java b/DNPMPlugins/src/main/java/ATCCodes/services/OnkostarAgentCodeService.java new file mode 100644 index 0000000..f29f074 --- /dev/null +++ b/DNPMPlugins/src/main/java/ATCCodes/services/OnkostarAgentCodeService.java @@ -0,0 +1,54 @@ +package ATCCodes.services; + +import ATCCodes.AgentCode; +import ATCCodes.UnregisteredCode; +import org.springframework.jdbc.core.JdbcTemplate; +import org.springframework.stereotype.Service; + +import javax.sql.DataSource; +import java.util.List; + +/** + * Implementation of {@link AgentCodeService} that uses database to query for unregistered agents + * + * @author Paul-Christian Volkmer + * @since 0.1.0 + */ +@Service +public class OnkostarAgentCodeService implements AgentCodeService { + + private final JdbcTemplate jdbcTemplate; + + public OnkostarAgentCodeService(final DataSource dataSource) { + this.jdbcTemplate = new JdbcTemplate(dataSource); + } + + /** + * Queries source for agents code starting with or name containing query string. + * If size is zero, all available results will be returned. + * + * @param query The query string + * @param size Maximal amount of responses + * @return A list with agent codes + */ + @Override + public List<AgentCode> findAgentCodes(final String query, final int size) { + var sql = "SELECT code, shortdesc\n" + + " FROM property_catalogue\n" + + " JOIN property_catalogue_version ON (property_catalogue_version.datacatalog_id = property_catalogue.id)\n" + + " JOIN property_catalogue_version_entry p ON (p.property_version_id = property_catalogue_version.id)\n" + + " WHERE name = 'OS.Substanzen'\n" + + " AND (LOWER(code) LIKE ? OR LOWER(shortdesc) LIKE ? OR LOWER(synonyms) LIKE ?)"; + + if (size > 0) { + sql = sql + " LIMIT " + size; + } + + return jdbcTemplate.query( + sql, + new Object[]{query + "%", "%" + query + "%", "%" + query + "%"}, + (resultSet, i) -> + new UnregisteredCode(resultSet.getString("code"), resultSet.getString("shortdesc")) + ); + } +}
\ No newline at end of file diff --git a/DNPMPlugins/src/main/java/ATCCodes/services/WhoAtcCodeService.java b/DNPMPlugins/src/main/java/ATCCodes/services/WhoAtcCodeService.java new file mode 100644 index 0000000..5bb9b11 --- /dev/null +++ b/DNPMPlugins/src/main/java/ATCCodes/services/WhoAtcCodeService.java @@ -0,0 +1,72 @@ +package ATCCodes.services; + +import ATCCodes.AgentCode; +import ATCCodes.AtcCode; +import ATCCodes.FileParsingException; +import org.springframework.core.io.ResourceLoader; +import org.springframework.stereotype.Service; + +import javax.xml.bind.JAXBContext; +import javax.xml.bind.JAXBException; +import javax.xml.bind.annotation.XmlAttribute; +import javax.xml.bind.annotation.XmlElement; +import javax.xml.bind.annotation.XmlRootElement; +import java.io.IOException; +import java.util.ArrayList; +import java.util.List; + +/** + * Service to query for agent codes based on WHO xml file + * + * @author Paul-Christian Volkmer + * @since 0.1.0 + */ +@Service +public class WhoAtcCodeService extends FileBasedAgentCodeService { + + public WhoAtcCodeService(final ResourceLoader resourceLoader) { + super(resourceLoader); + } + + protected List<AgentCode> parseFile(final ResourceLoader resourceLoader) { + var result = new ArrayList<AgentCode>(); + var filename = getFilePath("atc.xml"); + try { + var inputStream = resourceLoader.getResource(filename).getInputStream(); + var context = JAXBContext.newInstance(XmlResource.class); + var xmlResource = (XmlResource) context.createUnmarshaller().unmarshal(inputStream); + for (var row : xmlResource.data.rows) { + if (null == row.code || null == row.name) { + throw new FileParsingException("No XML attribute 'ATCCode' or 'Name' found"); + } + result.add(new AtcCode(row.code, row.name)); + } + logger.info("Found WHO XML file for ATC-Codes."); + return result; + } catch (IOException e) { + logger.warn("Error reading WHO XML file '{}' for ATC-Codes. Proceeding without inserting data", filename); + } catch (JAXBException | FileParsingException e) { + logger.warn("Error parsing WHO XML file '{}' for ATC-Codes. Proceeding without inserting data", filename); + } + return result; + } + + @XmlRootElement(name = "xml") + private static class XmlResource { + @XmlElement(name = "data", namespace = "urn:schemas-microsoft-com:rowset") + public XmlData data; + } + + private static class XmlData { + @XmlElement(name = "row", namespace = "#RowsetSchema") + public List<XmlRow> rows; + } + + private static class XmlRow { + @XmlAttribute(name = "ATCCode") + public String code; + + @XmlAttribute(name = "Name") + public String name; + } +}
\ No newline at end of file |