package dk.cbs.soa.soasi.secret.vault.repository; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Optional; import java.util.UUID; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; import org.springframework.stereotype.Repository; import dk.cbs.soa.soasi.secret.vault.ProjectHandleException; import dk.cbs.soa.soasi.secret.vault.ProjectNotFoundException; import dk.cbs.soa.soasi.secret.vault.model.Project; import jakarta.validation.Valid; import lombok.extern.slf4j.Slf4j; @Repository @Slf4j public class ProjectRepository { @Autowired private NamedParameterJdbcTemplate jdbcNamedTemplate; @Autowired private JdbcTemplate jdbcTemplate; // Get project by token and remove project public Optional get(String token) { String sqlGet = "select id,token,secret from projects.project where token = :token"; String sqlDelete = "delete from projects.project where token = ?"; MapSqlParameterSource namedParameters = new MapSqlParameterSource(); namedParameters.addValue("token", token); Project p = null; try { p = jdbcNamedTemplate.queryForObject(sqlGet, namedParameters, new RowMapper() { @Override public Project mapRow(ResultSet rs, int rowNum) throws SQLException { return Project.builder() .id(rs.getString("id")) .secret(rs.getString("secret")) .token(rs.getString("token")) .build(); } }); log.info("Add: " + p.toString()); if (p != null) { jdbcTemplate.update(sqlDelete, token); } } catch (Exception e) { log.error(e.getMessage(), e); throw new ProjectNotFoundException(e.getMessage(), e); } return Optional.ofNullable(p); } // Add project and return project with created token public Optional add(@Valid Project project) { String sqlInsert = "insert into projects.project (id, token) values (:id, :token)"; log.info("Create: " + project.toString()); UUID token = getRandomUuid(); project.setToken(token.toString()); MapSqlParameterSource namedParameters = new MapSqlParameterSource(); namedParameters.addValue("token", project.getToken()); namedParameters.addValue("id", project.getId()); try { jdbcNamedTemplate.update(sqlInsert, namedParameters); } catch (Exception e) { log.error(e.getMessage(), e); throw new ProjectHandleException(e.getMessage(), e); } return Optional.ofNullable(project); } // Update project with received secret public void update(@Valid Project project) { // Update project with secret log.info("Update: " + project.toString()); String sqlUpdate = "update projects.project set secret = :secret where token = :token"; MapSqlParameterSource namedParameters = new MapSqlParameterSource(); namedParameters.addValue("token", project.getToken()); namedParameters.addValue("secret", project.getSecret()); try { jdbcNamedTemplate.update(sqlUpdate, namedParameters); } catch (Exception e) { log.error(e.getMessage(), e); throw new ProjectHandleException(e.getMessage(), e); } } private UUID getRandomUuid() { return UUID.randomUUID(); } }