1.1 --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGComponentDao.java Fri Nov 06 10:50:32 2020 +0100 1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 1.3 @@ -1,130 +0,0 @@ 1.4 -/* 1.5 - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. 1.6 - * 1.7 - * Copyright 2018 Mike Becker. All rights reserved. 1.8 - * 1.9 - * Redistribution and use in source and binary forms, with or without 1.10 - * modification, are permitted provided that the following conditions are met: 1.11 - * 1.12 - * 1. Redistributions of source code must retain the above copyright 1.13 - * notice, this list of conditions and the following disclaimer. 1.14 - * 1.15 - * 2. Redistributions in binary form must reproduce the above copyright 1.16 - * notice, this list of conditions and the following disclaimer in the 1.17 - * documentation and/or other materials provided with the distribution. 1.18 - * 1.19 - * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 1.20 - * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 1.21 - * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 1.22 - * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE 1.23 - * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 1.24 - * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 1.25 - * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 1.26 - * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 1.27 - * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 1.28 - * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 1.29 - * POSSIBILITY OF SUCH DAMAGE. 1.30 - * 1.31 - */ 1.32 -package de.uapcore.lightpit.dao.postgres; 1.33 - 1.34 -import de.uapcore.lightpit.dao.ComponentDao; 1.35 -import de.uapcore.lightpit.dao.Functions; 1.36 -import de.uapcore.lightpit.entities.Component; 1.37 -import de.uapcore.lightpit.entities.Project; 1.38 -import de.uapcore.lightpit.entities.User; 1.39 -import de.uapcore.lightpit.types.WebColor; 1.40 - 1.41 -import java.sql.Connection; 1.42 -import java.sql.PreparedStatement; 1.43 -import java.sql.ResultSet; 1.44 -import java.sql.SQLException; 1.45 -import java.util.List; 1.46 - 1.47 -public final class PGComponentDao implements ComponentDao { 1.48 - 1.49 - private final PreparedStatement insert, update, list, find, findByNode; 1.50 - 1.51 - public PGComponentDao(Connection connection) throws SQLException { 1.52 - final var query = "select id, name, node, color, ordinal, description, " + 1.53 - "userid, username, givenname, lastname, mail " + 1.54 - "from lpit_component " + 1.55 - "left join lpit_user on lead = userid"; 1.56 - 1.57 - list = connection.prepareStatement(query + " where project = ? order by ordinal, lower(name)"); 1.58 - 1.59 - find = connection.prepareStatement(query + " where id = ? "); 1.60 - 1.61 - findByNode = connection.prepareStatement(query + " where project = ? and node = ?"); 1.62 - 1.63 - insert = connection.prepareStatement( 1.64 - "insert into lpit_component (name, node, color, ordinal, description, lead, project) values (?, ?, ?, ?, ?, ?, ?)" 1.65 - ); 1.66 - 1.67 - update = connection.prepareStatement( 1.68 - "update lpit_component set name = ?, node = ?, color = ?, ordinal = ?, description = ?, lead = ? where id = ?" 1.69 - ); 1.70 - } 1.71 - 1.72 - private static Component mapColumns(ResultSet result) throws SQLException { 1.73 - final var component = new Component(result.getInt("id")); 1.74 - component.setName(result.getString("name")); 1.75 - component.setNode(result.getString("node")); 1.76 - try { 1.77 - component.setColor(new WebColor(result.getString("color"))); 1.78 - } catch (IllegalArgumentException ex) { 1.79 - // if someone tempered with the database we default the color to black 1.80 - component.setColor(new WebColor("000000")); 1.81 - } 1.82 - component.setOrdinal(result.getInt("ordinal")); 1.83 - component.setDescription(result.getString("description")); 1.84 - component.setLead(PGUserDao.mapColumns(result)); 1.85 - return component; 1.86 - } 1.87 - 1.88 - private static int setColumns(PreparedStatement stmt, Component instance) throws SQLException { 1.89 - int column = 0; 1.90 - stmt.setString(++column, instance.getName()); 1.91 - stmt.setString(++column, instance.getNode()); 1.92 - stmt.setString(++column, instance.getColor().getHex()); 1.93 - stmt.setInt(++column, instance.getOrdinal()); 1.94 - Functions.setStringOrNull(stmt, ++column, instance.getDescription()); 1.95 - Functions.setForeignKeyOrNull(stmt, ++column, instance.getLead(), User::getId); 1.96 - return column; 1.97 - } 1.98 - 1.99 - @Override 1.100 - public void save(Component instance, Project project) throws SQLException { 1.101 - int column = setColumns(insert, instance); 1.102 - insert.setInt(++column, project.getId()); 1.103 - insert.executeUpdate(); 1.104 - } 1.105 - 1.106 - @Override 1.107 - public boolean update(Component instance) throws SQLException { 1.108 - if (instance.getId() < 0) return false; 1.109 - int column = setColumns(update, instance); 1.110 - update.setInt(++column, instance.getId()); 1.111 - return update.executeUpdate() > 0; 1.112 - } 1.113 - 1.114 - 1.115 - @Override 1.116 - public List<Component> list(Project project) throws SQLException { 1.117 - list.setInt(1, project.getId()); 1.118 - return Functions.list(list, PGComponentDao::mapColumns); 1.119 - } 1.120 - 1.121 - @Override 1.122 - public Component find(int id) throws SQLException { 1.123 - find.setInt(1, id); 1.124 - return Functions.find(find, PGComponentDao::mapColumns); 1.125 - } 1.126 - 1.127 - @Override 1.128 - public Component findByNode(Project project, String node) throws SQLException { 1.129 - findByNode.setInt(1, project.getId()); 1.130 - findByNode.setString(2, node);; 1.131 - return Functions.find(findByNode, PGComponentDao::mapColumns); 1.132 - } 1.133 -}