]> git.datanom.net - vault.git/blob - src/main/java/dk/cbs/soa/soasi/secret/vault/repository/ProjectRepository.java
64d41bb2fcfa00546a5cd28cb23df17bba11c9f5
[vault.git] / src / main / java / dk / cbs / soa / soasi / secret / vault / repository / ProjectRepository.java
1 package dk.cbs.soa.soasi.secret.vault.repository;
2
3 import java.sql.ResultSet;
4 import java.sql.SQLException;
5 import java.util.Optional;
6 import java.util.UUID;
7
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;
14
15 import dk.cbs.soa.soasi.secret.vault.model.Project;
16 import jakarta.validation.Valid;
17 import lombok.extern.slf4j.Slf4j;
18
19 @Repository
20 @Slf4j
21 public class ProjectRepository {
22
23 @Autowired
24 private NamedParameterJdbcTemplate jdbcNamedTemplate;
25
26 @Autowired
27 private JdbcTemplate jdbcTemplate;
28
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 = ?";
33
34 MapSqlParameterSource namedParameters = new MapSqlParameterSource();
35 namedParameters.addValue("token", token);
36
37 Project p = jdbcNamedTemplate.queryForObject(sqlGet, namedParameters, new RowMapper<Project>() {
38
39 @Override
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"))
45 .build();
46 }
47
48 });
49
50 log.info("Add: " + p.toString());
51
52 if (p != null) {
53 jdbcTemplate.update(sqlDelete, token);
54 }
55
56 return Optional.ofNullable(p);
57 }
58
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)";
62
63 log.info("Create: " + project.toString());
64
65 UUID token = getRandomUuid();
66 project.setToken(token.toString());
67
68 MapSqlParameterSource namedParameters = new MapSqlParameterSource();
69 namedParameters.addValue("token", project.getToken());
70 namedParameters.addValue("id", project.getId());
71
72 jdbcNamedTemplate.update(sqlInsert, namedParameters);
73
74 return Optional.ofNullable(project);
75 }
76
77 // Update project with received secret
78 public void update(@Valid Project project) {
79 // Update project with secret
80 log.info("Update: " + project.toString());
81
82 String sqlUpdate = "update projects.project set secret = :secret where token = :token";
83
84 MapSqlParameterSource namedParameters = new MapSqlParameterSource();
85 namedParameters.addValue("token", project.getToken());
86 namedParameters.addValue("secret", project.getSecret());
87
88 jdbcNamedTemplate.update(sqlUpdate, namedParameters);
89 }
90
91 private UUID getRandomUuid() {
92 return UUID.randomUUID();
93 }
94 }
This page took 0.37523 seconds and 4 git commands to generate.