Fri, 22 May 2020 21:23:57 +0200
adds the ability to create and edit issues
1 /*
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
3 *
4 * Copyright 2018 Mike Becker. All rights reserved.
5 *
6 * Redistribution and use in source and binary forms, with or without
7 * modification, are permitted provided that the following conditions are met:
8 *
9 * 1. Redistributions of source code must retain the above copyright
10 * notice, this list of conditions and the following disclaimer.
11 *
12 * 2. Redistributions in binary form must reproduce the above copyright
13 * notice, this list of conditions and the following disclaimer in the
14 * documentation and/or other materials provided with the distribution.
15 *
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
26 * POSSIBILITY OF SUCH DAMAGE.
27 *
28 */
29 package de.uapcore.lightpit.dao.postgres;
31 import de.uapcore.lightpit.dao.VersionDao;
32 import de.uapcore.lightpit.entities.Project;
33 import de.uapcore.lightpit.entities.Version;
34 import de.uapcore.lightpit.entities.VersionStatus;
36 import java.sql.Connection;
37 import java.sql.PreparedStatement;
38 import java.sql.ResultSet;
39 import java.sql.SQLException;
40 import java.util.ArrayList;
41 import java.util.List;
42 import java.util.Objects;
44 public final class PGVersionDao implements VersionDao {
46 private final PreparedStatement insert, update, list, find;
48 public PGVersionDao(Connection connection) throws SQLException {
49 list = connection.prepareStatement(
50 "select versionid, project, name, ordinal, status " +
51 "from lpit_version " +
52 "where project = ? " +
53 "order by ordinal, lower(name)");
55 find = connection.prepareStatement(
56 "select versionid, project, name, ordinal, status " +
57 "from lpit_version " +
58 "where versionid = ?");
60 insert = connection.prepareStatement(
61 "insert into lpit_version (project, name, ordinal, status) values (?, ?, ?, ?::version_status)"
62 );
63 update = connection.prepareStatement(
64 "update lpit_version set name = ?, ordinal = ?, status = ?::version_status where versionid = ?"
65 );
66 }
68 private Version mapColumns(ResultSet result) throws SQLException {
69 final var project = new Project(result.getInt("project"));
70 final var version = new Version(result.getInt("versionid"), project);
71 version.setName(result.getString("name"));
72 version.setOrdinal(result.getInt("ordinal"));
73 version.setStatus(VersionStatus.valueOf(result.getString("status")));
74 return version;
75 }
77 @Override
78 public void save(Version instance) throws SQLException {
79 Objects.requireNonNull(instance.getName());
80 Objects.requireNonNull(instance.getProject());
81 insert.setInt(1, instance.getProject().getId());
82 insert.setString(2, instance.getName());
83 insert.setInt(3, instance.getOrdinal());
84 insert.setString(4, instance.getStatus().name());
85 insert.executeUpdate();
86 }
88 @Override
89 public boolean update(Version instance) throws SQLException {
90 if (instance.getId() < 0) return false;
91 Objects.requireNonNull(instance.getName());
92 update.setString(1, instance.getName());
93 update.setInt(2, instance.getOrdinal());
94 update.setString(3, instance.getStatus().name());
95 update.setInt(4, instance.getId());
96 return update.executeUpdate() > 0;
97 }
99 @Override
100 public List<Version> list(Project project) throws SQLException {
101 list.setInt(1, project.getId());
102 List<Version> versions = new ArrayList<>();
103 try (var result = list.executeQuery()) {
104 while (result.next()) {
105 final var v = mapColumns(result);
106 v.setProject(project);
107 versions.add(v);
108 }
109 }
110 return versions;
111 }
113 @Override
114 public Version find(int id) throws SQLException {
115 find.setInt(1, id);
116 try (var result = find.executeQuery()) {
117 if (result.next()) {
118 return mapColumns(result);
119 } else {
120 return null;
121 }
122 }
123 }
124 }