--- /dev/null
+HELP.md
+target/
+.mvn/wrapper/maven-wrapper.jar
+!**/src/main/**/target/
+!**/src/test/**/target/
+
+### STS ###
+.apt_generated
+.classpath
+.factorypath
+.project
+.settings
+.springBeans
+.sts4-cache
+
+### IntelliJ IDEA ###
+.idea
+*.iws
+*.iml
+*.ipr
+
+### NetBeans ###
+/nbproject/private/
+/nbbuild/
+/dist/
+/nbdist/
+/.nb-gradle/
+build/
+!**/src/main/**/build/
+!**/src/test/**/build/
+
+### VS Code ###
+.vscode/
--- /dev/null
+<?xml version="1.0" encoding="UTF-8"?>
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
+ <modelVersion>4.0.0</modelVersion>
+ <parent>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-parent</artifactId>
+ <version>3.5.7</version>
+ <relativePath /> <!-- lookup parent from repository -->
+ </parent>
+ <groupId>dk.cbs.soa.soasi.secret</groupId>
+ <artifactId>vault</artifactId>
+ <version>0.0.1-SNAPSHOT</version>
+ <name>vault</name>
+ <description>Secret vault to exchange secrets with external partners</description>
+ <url />
+ <licenses>
+ <license />
+ </licenses>
+ <developers>
+ <developer />
+ </developers>
+ <scm>
+ <connection />
+ <developerConnection />
+ <tag />
+ <url />
+ </scm>
+ <properties>
+ <java.version>21</java.version>
+ </properties>
+ <dependencies>
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-thymeleaf</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-validation</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-web</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.springframework.session</groupId>
+ <artifactId>spring-session-jdbc</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.postgresql</groupId>
+ <artifactId>postgresql</artifactId>
+ <scope>runtime</scope>
+ </dependency>
+ <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
+ <dependency>
+ <groupId>org.projectlombok</groupId>
+ <artifactId>lombok</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-starter-test</artifactId>
+ <scope>test</scope>
+ </dependency>
+ </dependencies>
+
+ <build>
+ <plugins>
+ <plugin>
+ <groupId>org.apache.maven.plugins</groupId>
+ <artifactId>maven-compiler-plugin</artifactId>
+ <configuration>
+ <annotationProcessorPaths>
+ <path>
+ <groupId>org.projectlombok</groupId>
+ <artifactId>lombok</artifactId>
+ </path>
+ </annotationProcessorPaths>
+ </configuration>
+ </plugin>
+ <plugin>
+ <groupId>org.springframework.boot</groupId>
+ <artifactId>spring-boot-maven-plugin</artifactId>
+ <configuration>
+ <excludes>
+ <exclude>
+ <groupId>org.projectlombok</groupId>
+ <artifactId>lombok</artifactId>
+ </exclude>
+ </excludes>
+ </configuration>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
--- /dev/null
+package dk.cbs.soa.soasi.secret.vault;
+
+import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.SpringBootApplication;
+
+@SpringBootApplication
+public class VaultApplication {
+
+ public static void main(String[] args) {
+ SpringApplication.run(VaultApplication.class, args);
+ }
+
+}
--- /dev/null
+package dk.cbs.soa.soasi.secret.vault.configuration;
+
+import javax.sql.DataSource;
+
+import org.springframework.beans.factory.annotation.Value;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.jdbc.datasource.DriverManagerDataSource;
+
+@Configuration
+public class JdbcConfig {
+
+ @Value("${vault.datasource.url}")
+ private String url;
+ @Value("${vault.datasource.username}")
+ private String username;
+ @Value("${vault.datasource.password}")
+ private String password;
+
+ @Bean
+ public DataSource postgresqlDataSource() {
+ DriverManagerDataSource dataSource = new DriverManagerDataSource();
+ dataSource.setDriverClassName("org.postgresql.Driver");
+ dataSource.setUrl(url);
+ dataSource.setUsername(username);
+ dataSource.setPassword(password);
+
+ return dataSource;
+ }
+}
--- /dev/null
+package dk.cbs.soa.soasi.secret.vault.controller;
+
+import java.util.Optional;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Controller;
+import org.springframework.ui.Model;
+import org.springframework.validation.BindingResult;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+
+import dk.cbs.soa.soasi.secret.vault.model.Project;
+import dk.cbs.soa.soasi.secret.vault.repository.ProjectRepository;
+import jakarta.validation.Valid;
+import lombok.extern.slf4j.Slf4j;
+
+@Controller
+@Slf4j
+public class ProjectController {
+
+ @Autowired
+ private ProjectRepository projectRepository;
+
+ @GetMapping("/info")
+ public String showRegisterProject(Project project) {
+ return "create-project";
+ }
+
+ @PostMapping("/showinfo")
+ public String showInfo(@Valid Project project, BindingResult result, Model model) {
+ log.info(project == null ? "null" : project.toString());
+
+ if (result.hasErrors()) {
+ return "create-project";
+ }
+
+ Optional<Project> newProject = projectRepository.add(project);
+ if (newProject.isEmpty())
+ throw new IllegalArgumentException("Project is empty");
+
+ log.info(project.toString());
+ model.addAttribute("project", newProject.get());
+
+
+ return "project-info";
+ }
+
+ @GetMapping("/project")
+ public String showCreateProject(Project project) {
+ return "add-project";
+ }
+
+ @PostMapping("/addproject")
+ public String createProject(@Valid Project project, BindingResult result, Model model) {
+ log.info(project == null ? "null" : project.toString());
+
+ if (result.hasErrors()) {
+ return "add-project";
+ }
+ Optional<Project> p = projectRepository.get(project.getToken());
+ if (p.isEmpty()) {
+ throw new IllegalArgumentException("Invalid token" + project.getToken());
+ }
+
+ model.addAttribute("project", p.get());
+
+ return "create-info";
+ }
+
+ @GetMapping("/")
+ public String getSecret(Project project) {
+ return "get-secret";
+ }
+
+ @PostMapping("/secret")
+ public String receiveSecret(@Valid Project project, BindingResult result, Model model) {
+ log.info(project == null ? "null" : project.toString());
+
+ if (result.hasErrors()) {
+ return "get-secret";
+ }
+
+ projectRepository.update(project);
+
+ return "redirect:/goodbye.html";
+ }
+
+}
--- /dev/null
+package dk.cbs.soa.soasi.secret.vault.model;
+
+import lombok.Builder;
+import lombok.Data;
+import lombok.ToString;
+
+@Data
+@Builder
+@ToString
+public class Project {
+ private String id;
+ private String token;
+ private String secret;
+}
--- /dev/null
+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();
+ }
+}
--- /dev/null
+spring.application.name=vault
+
+logging.level.org.springframework.web=DEBUG
+
+vault.datasource.url=jdbc:postgresql://localhost:5432/vault
+vault.datasource.username=vault
+vault.datasource.password=vault
+
+spring.session.jdbc.initialize-schema=always
--- /dev/null
+create user vault with password 'vault';
+create database vault with owner vault;
+create schema projects AUTHORIZATION vault;
+
+create table projects.project (
+id varchar UNIQUE,
+token varchar UNIQUE,
+secret varchar
+);
+
--- /dev/null
+<!doctype html>
+<html xmlns:th="http://www.thymeleaf.org">
+<head>
+<meta charset="UTF-8">
+<title>GoodBye</title>
+</head>
+<body>
+<h1>GoodBye</h1>
+</body>
+</html>
\ No newline at end of file
--- /dev/null
+<form action="#" th:action="@{/addproject}" th:object="${project}" method="post">
+ <label for="token">Token</label>
+ <input type="text" th:field="*{token}" id="token" placeholder="Token">
+ <span th:if="${#fields.hasErrors('token')}" th:errors="*{token}"></span>
+ <br/><br/>
+ <input type="submit" value="Add Project">
+</form>
\ No newline at end of file
--- /dev/null
+<!doctype html>
+<html xmlns:th="http://www.thymeleaf.org">
+<head>
+<meta charset="UTF-8">
+<title>Project Info</title>
+</head>
+<body>
+<table>
+<thead>
+<tr>
+<th>Id</th>
+<th>Token</th>
+<th>Secret</th>
+</tr>
+</thead>
+<tbody>
+<tr>
+<td th:text="${project.id}"/>
+<td th:text="${project.token}"/>
+<td th:text="${project.secret}"/>
+</tr>
+</tbody>
+</table>
+</body>
+</html>
--- /dev/null
+<form action="#" th:action="@{/showinfo}" th:object="${project}" method="post">
+ <label for="id">Id/Name</label>
+ <input type="text" th:field="*{id}" id="id" placeholder="Id">
+ <span th:if="${#fields.hasErrors('id')}" th:errors="*{id}"></span>
+ <br/><br/>
+ <input type="submit" value="Create Project">
+</form>
\ No newline at end of file
--- /dev/null
+<form action="#" th:action="@{/secret}" th:object="${project}" method="post">
+ <label for="token">Token</label>
+ <input type="text" th:field="*{token}" id="token" placeholder="Token">
+ <span th:if="${#fields.hasErrors('token')}" th:errors="*{token}"></span>
+ <br/>
+ <label for="secret">Secret</label>
+ <input type="text" th:field="*{secret}" id="secret" placeholder="Secret">
+ <span th:if="${#fields.hasErrors('secret')}" th:errors="*{secret}"></span>
+ <br/><br/>
+ <input type="submit" value="Send Secret">
+</form>
\ No newline at end of file
--- /dev/null
+<!doctype html>
+<html xmlns:th="http://www.thymeleaf.org">
+<head>
+<meta charset="UTF-8">
+<title>Project Info</title>
+</head>
+<body>
+<table>
+<thead>
+<tr>
+<th>Id</th>
+<th>Token</th>
+</tr>
+</thead>
+<tbody>
+<tr>
+<td th:text="${project.id}"/>
+<td th:text="${project.token}"/>
+</tr>
+</tbody>
+</table>
+</body>
+</html>
--- /dev/null
+package dk.cbs.soa.soasi.secret.vault;
+
+import org.junit.jupiter.api.Test;
+import org.springframework.boot.test.context.SpringBootTest;
+
+@SpringBootTest
+class VaultApplicationTests {
+
+ @Test
+ void contextLoads() {
+ }
+
+}