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

Sun, 17 May 2020 16:38:04 +0200

author
Mike Becker <universe@uap-core.de>
date
Sun, 17 May 2020 16:38:04 +0200
changeset 61
3e287f361c7a
parent 59
c759c60507a2
child 62
833e0385572a
permissions
-rw-r--r--

moves project index to separate sub path

unfortunately the current menu highlighting strategy sucks and this is the easiest way so that everything looks correct

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
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
31 import de.uapcore.lightpit.dao.DataAccessObjects;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
32 import de.uapcore.lightpit.dao.ProjectDao;
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
33 import de.uapcore.lightpit.dao.UserDao;
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
34 import de.uapcore.lightpit.dao.VersionDao;
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
35
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
36 import java.sql.Connection;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
37 import java.sql.SQLException;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
38
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
39 public class PGDataAccessObjects implements DataAccessObjects {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
40
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
41 private final UserDao userDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
42 private final ProjectDao projectDao;
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
43 private final VersionDao versionDao;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
44
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
45 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
46 userDao = new PGUserDao(connection);
57cfb94ab99f projects can now be added and updated
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
47 projectDao = new PGProjectDao(connection);
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
48 versionDao = new PGVersionDao(connection);
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
49 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
50
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
51 @Override
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
52 public UserDao getUserDao() {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
53 return userDao;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
54 }
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
55
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
56 @Override
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
57 public ProjectDao getProjectDao() {
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
58 return projectDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
59 }
59
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
60
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
61 @Override
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
62 public VersionDao getVersionDao() {
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
63 return versionDao;
c759c60507a2 adds version management
Mike Becker <universe@uap-core.de>
parents: 47
diff changeset
64 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
65 }

mercurial