+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.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<Project> 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 = jdbcNamedTemplate.queryForObject(sqlGet, namedParameters, new RowMapper<Project>() {
+
+ @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);
+ }
+
+ return Optional.ofNullable(p);
+ }
+
+ // Add project and return project with created token
+ public Optional<Project> 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());
+
+ jdbcNamedTemplate.update(sqlInsert, namedParameters);
+
+ 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());
+
+ jdbcNamedTemplate.update(sqlUpdate, namedParameters);
+ }
+
+ private UUID getRandomUuid() {
+ return UUID.randomUUID();
+ }
+}