aswi2020vldc-gitlab/src/main/java/vldc/aswi/service/SqlQueryManager.java @ b07f6ea7

package vldc.aswi.service;

import vldc.aswi.domain.Assembly;
import vldc.aswi.domain.Configuration;
import vldc.aswi.domain.parameter.ParameterInConfiguration;
import vldc.aswi.model.table.contingencyTable.ContingencyTableRow;

import java.util.List;

/**
 * Interface for SqlQuery manager.
 */
public interface SqlQueryManager {

    /**
     * Get list of  contingencyTableRow.
     * @param assembly Assembly from which configuration was created.
     * @param parametersInConfiguration Parameters in configuration with their locations and operators.
     * @param isNotRemoveEmpty Sets if empty rows and columns should not be removed.
     * @return List of contingencyTableRow.
     */
    List<ContingencyTableRow> getContingencyTableRow(Assembly assembly,
                                                     List<ParameterInConfiguration> parametersInConfiguration,
                                                     boolean isNotRemoveEmpty);

    /**
     * Validate given SQL query.
     * @param sqlQuery - Validated SQL query.
     * @return true if SQL query is ok, false if not.
     */
    boolean validateSQLQuery(String sqlQuery);

    /**
     * Get list of table column names from SQL query.
     * @param sqlQuery - SQL query.
     * @return List of table column names.
     */
    List<String> getNameOfColumnsFromQuery(String sqlQuery);
}