• Home
• com.ibm.fhir
• fhir-persistence-jdbc
• 4.11.0
• source code
• ParameterTableSupport.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.ibm.fhir.persistence.jdbc.util.ParameterTableSupport Maven / Gradle / Ivy

/*
 * (C) Copyright IBM Corp. 2021
 *
 * SPDX-License-Identifier: Apache-2.0
 */

package com.ibm.fhir.persistence.jdbc.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * Support functions for managing the search parameter value tables
 */
public class ParameterTableSupport {

    /**
     * Delete any current parameters from the whole-system and resource-specific parameter tables
     * for the given resourcetype and logical_resource_id
     * @param conn
     * @param tablePrefix
     * @param v_logical_resource_id
     * @throws SQLException
     */
    public static void deleteFromParameterTables(Connection conn, String tablePrefix, long v_logical_resource_id) throws SQLException {
        deleteFromParameterTable(conn, tablePrefix + "_str_values", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_number_values", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_date_values", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_latlng_values", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_resource_token_refs", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_quantity_values", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_profiles", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_tags", v_logical_resource_id);
        deleteFromParameterTable(conn, tablePrefix + "_security", v_logical_resource_id);

        // delete any system level parameters we have for this resource
        deleteFromParameterTable(conn, "str_values", v_logical_resource_id);
        deleteFromParameterTable(conn, "date_values", v_logical_resource_id);
        deleteFromParameterTable(conn, "resource_token_refs", v_logical_resource_id);
        deleteFromParameterTable(conn, "logical_resource_profiles", v_logical_resource_id);
        deleteFromParameterTable(conn, "logical_resource_tags", v_logical_resource_id);
        deleteFromParameterTable(conn, "logical_resource_security", v_logical_resource_id);
    }

    /**
     * Delete all parameters for the given resourceId from the parameters table
     *
     * @param conn
     * @param tableName
     * @param logicalResourceId
     * @throws SQLException
     */
    private static void deleteFromParameterTable(Connection conn, String tableName, long logicalResourceId) throws SQLException {
        final String delStrValues = "DELETE FROM " + tableName + " WHERE logical_resource_id = ?";
        try (PreparedStatement stmt = conn.prepareStatement(delStrValues)) {
            // bind parameters
            stmt.setLong(1, logicalResourceId);
            stmt.executeUpdate();
        }

    }
}