src/main/java/de/uapcore/lightpit/dao/postgres/PGDataAccessObjects.java

Mon, 18 May 2020 21:05:57 +0200

author
Mike Becker <universe@uap-core.de>
date
Mon, 18 May 2020 21:05:57 +0200
changeset 62
833e0385572a
parent 59
c759c60507a2
child 128
947d0f6a6a83
permissions
-rw-r--r--

adds data model for issues

34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
1 /*
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
3 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
4 * Copyright 2018 Mike Becker. All rights reserved.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
5 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
6 * Redistribution and use in source and binary forms, with or without
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
7 * modification, are permitted provided that the following conditions are met:
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
8 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
9 * 1. Redistributions of source code must retain the above copyright
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
10 * notice, this list of conditions and the following disclaimer.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
11 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
12 * 2. Redistributions in binary form must reproduce the above copyright
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
13 * notice, this list of conditions and the following disclaimer in the
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
14 * documentation and/or other materials provided with the distribution.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
15 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
824d4042c857 cleanup and simplification of database access layer
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
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
26 * POSSIBILITY OF SUCH DAMAGE.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
27 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
28 */
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
29 package de.uapcore.lightpit.dao.postgres;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
30
62
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
31 import de.uapcore.lightpit.dao.*;
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
32
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
33 import java.sql.Connection;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
34 import java.sql.SQLException;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
35
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
36 public class PGDataAccessObjects implements DataAccessObjects {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
37
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
38 private final UserDao userDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
39 private final ProjectDao projectDao;
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
40 private final VersionDao versionDao;
62
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
41 private final IssueDao issueDao;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
42
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
43 public PGDataAccessObjects(Connection connection) throws SQLException {
47
57cfb94ab99f projects can now be added and updated
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
44 userDao = new PGUserDao(connection);
57cfb94ab99f projects can now be added and updated
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
45 projectDao = new PGProjectDao(connection);
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
46 versionDao = new PGVersionDao(connection);
62
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
47 issueDao = new PGIssueDao(connection);
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
48 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
49
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
50 @Override
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
51 public UserDao getUserDao() {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
52 return userDao;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
53 }
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
54
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
55 @Override
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
56 public ProjectDao getProjectDao() {
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
57 return projectDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
58 }
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
60 @Override
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
61 public VersionDao getVersionDao() {
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
62 return versionDao;
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
63 }
62
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
64
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
65 @Override
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
66 public IssueDao getIssueDao() {
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
67 return issueDao;
833e0385572a adds data model for issues
Mike Becker <universe@uap-core.de>
parents: 59
diff changeset
68 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
69 }

mercurial