1 package dk
.cbs
.soa
.soasi
.secret
.vault
.repository
;
3 import java
.sql
.ResultSet
;
4 import java
.sql
.SQLException
;
5 import java
.util
.Optional
;
8 import org
.springframework
.beans
.factory
.annotation
.Autowired
;
9 import org
.springframework
.jdbc
.core
.JdbcTemplate
;
10 import org
.springframework
.jdbc
.core
.RowMapper
;
11 import org
.springframework
.jdbc
.core
.namedparam
.MapSqlParameterSource
;
12 import org
.springframework
.jdbc
.core
.namedparam
.NamedParameterJdbcTemplate
;
13 import org
.springframework
.stereotype
.Repository
;
15 import dk
.cbs
.soa
.soasi
.secret
.vault
.model
.Project
;
16 import jakarta
.validation
.Valid
;
17 import lombok
.extern
.slf4j
.Slf4j
;
21 public class ProjectRepository
{
24 private NamedParameterJdbcTemplate jdbcNamedTemplate
;
27 private JdbcTemplate jdbcTemplate
;
29 // Get project by token and remove project
30 public Optional
<Project
> get(String token
) {
31 String sqlGet
= "select id,token,secret from projects.project where token = :token";
32 String sqlDelete
= "delete from projects.project where token = ?";
34 MapSqlParameterSource namedParameters
= new MapSqlParameterSource();
35 namedParameters
.addValue("token", token
);
37 Project p
= jdbcNamedTemplate
.queryForObject(sqlGet
, namedParameters
, new RowMapper
<Project
>() {
40 public Project
mapRow(ResultSet rs
, int rowNum
) throws SQLException
{
41 return Project
.builder()
42 .id(rs
.getString("id"))
43 .secret(rs
.getString("secret"))
44 .token(rs
.getString("token"))
50 log
.info("Add: " + p
.toString());
53 jdbcTemplate
.update(sqlDelete
, token
);
56 return Optional
.ofNullable(p
);
59 // Add project and return project with created token
60 public Optional
<Project
> add(@Valid Project project
) {
61 String sqlInsert
= "insert into projects.project (id, token) values (:id, :token)";
63 log
.info("Create: " + project
.toString());
65 UUID token
= getRandomUuid();
66 project
.setToken(token
.toString());
68 MapSqlParameterSource namedParameters
= new MapSqlParameterSource();
69 namedParameters
.addValue("token", project
.getToken());
70 namedParameters
.addValue("id", project
.getId());
72 jdbcNamedTemplate
.update(sqlInsert
, namedParameters
);
74 return Optional
.ofNullable(project
);
77 // Update project with received secret
78 public void update(@Valid Project project
) {
79 // Update project with secret
80 log
.info("Update: " + project
.toString());
82 String sqlUpdate
= "update projects.project set secret = :secret where token = :token";
84 MapSqlParameterSource namedParameters
= new MapSqlParameterSource();
85 namedParameters
.addValue("token", project
.getToken());
86 namedParameters
.addValue("secret", project
.getSecret());
88 jdbcNamedTemplate
.update(sqlUpdate
, namedParameters
);
91 private UUID
getRandomUuid() {
92 return UUID
.randomUUID();