package app.config;

import ca.tecreations.ProjectPath;
import ca.tecreations.db.mysql.MySQL;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.stereotype.Component;
/**
 *
 * @author tim
 */
@Configuration
@Component
public class SiteSecDBData {
    public static boolean debug = true;
    public static String pkg = SiteSecDBData.class.getPackageName();
    
    @Autowired
    public SiteSecDataSource ssds;
    
    public SiteSecDBData() {
    }
    
    @Value("${spring.datasource.url}")
    String url;
    
    @Value("${spring.datasource.username}")
    String username; 
    
    @Value("${spring.datasource.password}")
    String password;
    
    @Value("${spring.datasource.driver-class-name}")
    String driverClassName;

    public int getIntValue(String sql, boolean debug) {
        return Integer.parseInt(ssds.mysql.getValue(sql,debug));
    }
    
    public String getValue(String sql, boolean debug) {
        return ssds.mysql.getValue(sql, debug);
    }

    public List<List<String>> getRows(String sql, boolean withHeader) {
        return ssds.getMysql().getRows(sql, withHeader);
    }
    
    public void issue(String sql, boolean debug) {
        ssds.mysql.issue(sql, debug);
    }

    public void setDebug(boolean state) {
        ssds.mysql.debug = state;
    }
}