package cn.myapps.runtime.report.service;


import cn.myapps.common.exception.CommonException;
import cn.myapps.common.model.report.QueryColumnInfo;
import cn.myapps.common.model.report.Report;

import java.util.List;


public interface RuntimeOpenQueryService {

    public List<QueryColumnInfo> getQueryColumnInfos(String sql, String dbDriver, String dbUrl, String dbUser, String dbPass ) throws CommonException;

    public List<QueryColumnInfo> getProcedureColumnsInfos(String procedureScript, String dbDriver, String dbUrl, String dbUser, String dbPass) throws Exception;

    public void generateDynamicReportDataSource(Report report, String sql, String dbDriver, String dbUrl, String dbUser, String dbPass ) throws CommonException;

    public void generateDynamicReportDataSourceByProcedure(Report report, String procedureScript, String dbDriver, String dbUrl, String dbUser, String dbPass )throws Exception;
}