use of org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException in project carbon-identity-framework by wso2.
the class TemplateManagerDAOImpl method addTemplate.
/**
* Add a {@link Template}.
*
* @param template {@link Template} to insert.
* @return Inserted {@link TemplateInfo}.
* @throws TemplateManagementException If error occurs while adding the {@link Template}.
*/
public Template addTemplate(Template template) throws TemplateManagementException {
Template templateResult;
JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
try {
jdbcTemplate.executeUpdate(TemplateMgtConstants.SqlQueries.INSERT_TEMPLATE, preparedStatement -> {
preparedStatement.setInt(1, template.getTenantId());
preparedStatement.setString(2, template.getTemplateName());
preparedStatement.setString(3, template.getDescription());
InputStream inputStream = IOUtils.toInputStream(template.getTemplateScript());
try {
preparedStatement.setBinaryStream(4, inputStream, inputStream.available());
} catch (IOException e) {
// SQLException is thrown since the QueryFilter throws an SQLException
throw TemplateMgtUtils.handleSQLException(ERROR_CODE_INSERT_TEMPLATE, template.getTemplateName(), e);
}
});
} catch (DataAccessException e) {
throw TemplateMgtUtils.handleServerException(ERROR_CODE_INSERT_TEMPLATE, template.getTemplateName(), e);
}
templateResult = new Template(template.getTenantId(), template.getTemplateName(), template.getDescription(), template.getTemplateScript());
return templateResult;
}
use of org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException in project carbon-identity-framework by wso2.
the class TemplateManagerDAOImpl method deleteTemplate.
/**
* Delete {@link Template} for a given template name and a tenant Id.
*
* @param templateName name of the {@link Template} to be deleted.the tenant
* @param tenantId tenant Id of the tenant which the {@link Template} resides.
* @return TemplateInfo of the deleted {@link Template}.
* @throws TemplateManagementException If error occurs while deleting the {@link Template}
*/
public TemplateInfo deleteTemplate(String templateName, Integer tenantId) throws TemplateManagementException {
JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
try {
jdbcTemplate.executeUpdate(DELETE_TEMPLATE, preparedStatement -> {
preparedStatement.setString(1, templateName);
preparedStatement.setInt(2, tenantId);
});
} catch (DataAccessException e) {
throw new TemplateManagementServerException(String.format(ERROR_CODE_DELETE_TEMPLATE.getMessage(), tenantId.toString(), templateName), ERROR_CODE_DELETE_TEMPLATE.getCode(), e);
}
return new TemplateInfo(tenantId, templateName);
}
use of org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException in project carbon-identity-framework by wso2.
the class TemplateManagerDAOImpl method getAllTemplates.
/**
* List {@link TemplateInfo} items for a given search criteria.
*
* @param tenantId Tenant Id to be searched.
* @param limit Maximum number of results expected.
* @param offset Result offset.
* @return List of {@link TemplateInfo} entries.
* @throws TemplateManagementException If error occurs while searching the Templates.
*/
public List<TemplateInfo> getAllTemplates(Integer tenantId, Integer limit, Integer offset) throws TemplateManagementException {
List<TemplateInfo> templates;
JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
try {
String query;
if (isH2DB() || isMySQLDB() || isPostgreSQLDB()) {
query = LIST_PAGINATED_TEMPLATES_MYSQL;
} else if (isDB2DB()) {
query = LIST_PAGINATED_TEMPLATES_DB2;
int initialOffset = offset;
offset = offset + limit;
limit = initialOffset + 1;
} else if (isMSSqlDB()) {
int initialOffset = offset;
offset = limit + offset;
limit = initialOffset + 1;
query = LIST_PAGINATED_TEMPLATES_MSSQL;
} else {
// oracle
query = LIST_PAGINATED_TEMPLATES_ORACLE;
limit = offset + limit;
}
int finalLimit = limit;
int finalOffset = offset;
templates = jdbcTemplate.executeQuery(query, (resultSet, rowNumber) -> new TemplateInfo(resultSet.getString(1), resultSet.getString(2)), preparedStatement -> {
preparedStatement.setInt(1, tenantId);
preparedStatement.setInt(2, finalLimit);
preparedStatement.setInt(3, finalOffset);
});
} catch (DataAccessException e) {
throw new TemplateManagementServerException(String.format(ERROR_CODE_PAGINATED_LIST_TEMPLATES.getMessage(), tenantId, limit, offset), ERROR_CODE_PAGINATED_LIST_TEMPLATES.getCode(), e);
}
return templates;
}
use of org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException in project carbon-identity-framework by wso2.
the class ApplicationTemplateDAOImpl method deleteApplicationTemplate.
@Override
public void deleteApplicationTemplate(String templateName, String tenantDomain) throws IdentityApplicationManagementException {
if (log.isDebugEnabled()) {
log.debug(String.format("Deleting application template: %s in tenant: %s", templateName, tenantDomain));
}
JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
try {
jdbcTemplate.executeUpdate(DELETE_SP_TEMPLATE_BY_NAME, preparedStatement -> {
preparedStatement.setString(1, templateName);
preparedStatement.setInt(2, getTenantID(tenantDomain));
});
} catch (DataAccessException e) {
throw new IdentityApplicationManagementException(String.format("An error occurred while deleting the " + "application template : %s in tenant: %s", templateName, tenantDomain), e);
}
}
use of org.wso2.carbon.database.utils.jdbc.exceptions.DataAccessException in project carbon-identity-framework by wso2.
the class ApplicationTemplateDAOImpl method updateApplicationTemplate.
@Override
public void updateApplicationTemplate(String templateName, SpTemplate spTemplate, String tenantDomain) throws IdentityApplicationManagementException {
if (log.isDebugEnabled()) {
log.debug(String.format("Updating application template: %s in tenant: %s", spTemplate.getName(), tenantDomain));
}
JdbcTemplate jdbcTemplate = JdbcUtils.getNewTemplate();
try {
jdbcTemplate.executeUpdate(UPDATE_SP_TEMPLATE_BY_NAME, preparedStatement -> {
preparedStatement.setString(1, spTemplate.getName());
preparedStatement.setString(2, spTemplate.getDescription());
try {
setBlobValue(spTemplate.getContent(), preparedStatement, 3);
} catch (IOException e) {
throw new SQLException(String.format("Could not set application template: %s content as " + "a Blob in tenant: %s.", spTemplate.getName(), tenantDomain), e);
}
preparedStatement.setString(4, templateName);
preparedStatement.setInt(5, getTenantID(tenantDomain));
});
} catch (DataAccessException e) {
throw new IdentityApplicationManagementException(String.format("An error occurred while updating the" + " application template : %s in tenant: %s", spTemplate.getName(), tenantDomain), e);
}
}
Aggregations