src/main/java/de/uapcore/lightpit/dao/VersionDao.java

Sun, 24 May 2020 15:30:43 +0200

author
Mike Becker <universe@uap-core.de>
date
Sun, 24 May 2020 15:30:43 +0200
changeset 80
27a25f32048e
parent 72
0646c14e36fb
child 86
0a658e53177c
permissions
-rw-r--r--

adds project overview page

38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
1 /*
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
3 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
4 * Copyright 2018 Mike Becker. All rights reserved.
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
5 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
6 * Redistribution and use in source and binary forms, with or without
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
7 * modification, are permitted provided that the following conditions are met:
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
8 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
9 * 1. Redistributions of source code must retain the above copyright
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
10 * notice, this list of conditions and the following disclaimer.
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
11 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
12 * 2. Redistributions in binary form must reproduce the above copyright
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
13 * notice, this list of conditions and the following disclaimer in the
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
14 * documentation and/or other materials provided with the distribution.
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
15 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
26 * POSSIBILITY OF SUCH DAMAGE.
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
27 *
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
28 */
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
29 package de.uapcore.lightpit.dao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
30
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
31 import de.uapcore.lightpit.entities.Project;
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
32 import de.uapcore.lightpit.entities.Version;
80
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
33 import de.uapcore.lightpit.entities.VersionStatistics;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
34
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
35 import java.sql.SQLException;
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
36 import java.util.List;
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
37
62
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
38 public interface VersionDao extends GenericDao<Version> {
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
39
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
40 /**
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
41 * Lists all versions for the specified project.
72
0646c14e36fb some reformatting
Mike Becker <universe@uap-core.de>
parents: 62
diff changeset
42 *
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
43 * @param project the project
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
44 * @return a list of versions
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
45 * @throws SQLException on any kind of SQL error
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
46 */
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
47 List<Version> list(Project project) throws SQLException;
80
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
48
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
49 /**
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
50 * Retrieves statistics about issues that arose in a version.
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
51 *
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
52 * @param version the version
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
53 * @return version statistics
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
54 * @throws SQLException on any kind of SQL error
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
55 */
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
56 VersionStatistics statsOpenedIssues(Version version) throws SQLException;
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
57
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
58 /**
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
59 * Retrieves statistics about issues that are scheduled for a version.
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
60 *
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
61 * @param version the version
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
62 * @return version statistics
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
63 * @throws SQLException on any kind of SQL error
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
64 */
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
65 VersionStatistics statsScheduledIssues(Version version) throws SQLException;
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
66
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
67 /**
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
68 * Retrieves statistics about issues that are resolved in a version.
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
69 *
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
70 * @param version the version
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
71 * @return version statistics
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
72 * @throws SQLException on any kind of SQL error
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
73 */
27a25f32048e adds project overview page
Mike Becker <universe@uap-core.de>
parents: 72
diff changeset
74 VersionStatistics statsResolvedIssues(Version version) throws SQLException;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents:
diff changeset
75 }

mercurial