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;
}
}