package org.mifos.application.servicefacade;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class CustomJDBCServiceImpl implements CustomJDBCService {

    private final JdbcTemplate template;

    @Autowired
    public CustomJDBCServiceImpl(final DriverManagerDataSource dataSource) {
        template = new JdbcTemplate(dataSource);
    }

    @Override
    public boolean mifos4948IssueKeyExists() {
        
        int count = this.template.queryForInt("select count(*) from config_key_value c where c.configuration_key like 'MIFOS-4948'");
        
        return count > 0;
    }

    @Override
    public void insertMifos4948Issuekey() {
        this.template.execute("insert into config_key_value (configuration_key, configuration_type, configuration_value) values ('MIFOS-4948', 0, 1)");
    }
    
    @Override
    public boolean mifos5722IssueKeyExists() {
        
        int count = this.template.queryForInt("select count(*) from config_key_value c where c.configuration_key like 'MIFOS-5722'");
        
        return count > 0;
    }
    
    @Override
    public void insertMifos5722Issuekey() {
        this.template.execute("insert into config_key_value (configuration_key, configuration_type, configuration_value) values ('MIFOS-5722', 0, 1)");
    }
    
    @Override
    public boolean mifos5763IssueKeyExists() {
        
        int count = this.template.queryForInt("select count(*) from config_key_value c where c.configuration_key like 'MIFOS-5763'");
        
        return count > 0;
    }
    
    @Override
    public void insertMifos5763Issuekey() {
        this.template.execute("insert into config_key_value (configuration_key, configuration_type, configuration_value) values ('MIFOS-5763', 0, 1)");
    }
    
    @Override
    public void insertMifos5632IssueKey() {
        this.template.execute("insert into config_key_value (configuration_key, configuration_type, configuration_value) values ('MIFOS-5632', 0, 1)");
    }
    
    @Override
    public boolean mifos5632IssueKeyExists() {
        int count = this.template.queryForInt("select count(*) from config_key_value c where c.configuration_key like 'MIFOS-5632'");
        
        return count > 0;
    }



}