comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGVersionDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGVersionDao.java
- changeset 83
- 24a3596b8f98
- parent 80
- 27a25f32048e
- child 86
- 0a658e53177c
equal
deleted
inserted
replaced
| 82:4ec7f2600c83 | 83:24a3596b8f98 |
|---|---|
| 44 private final PreparedStatement insert, update, list, find; | 44 private final PreparedStatement insert, update, list, find; |
| 45 private final PreparedStatement issuesAffected, issuesScheduled, issuesResolved; | 45 private final PreparedStatement issuesAffected, issuesScheduled, issuesResolved; |
| 46 | 46 |
| 47 public PGVersionDao(Connection connection) throws SQLException { | 47 public PGVersionDao(Connection connection) throws SQLException { |
| 48 list = connection.prepareStatement( | 48 list = connection.prepareStatement( |
| 49 "select versionid, project, name, ordinal, status " + | 49 "select versionid, project, p.name as projectname, v.name, ordinal, status " + |
| 50 "from lpit_version " + | 50 "from lpit_version v " + |
| 51 "join lpit_project p on v.project = p.projectid " + | |
| 51 "where project = ? " + | 52 "where project = ? " + |
| 52 "order by ordinal desc, lower(name) desc"); | 53 "order by ordinal desc, lower(v.name) desc"); |
| 53 | 54 |
| 54 find = connection.prepareStatement( | 55 find = connection.prepareStatement( |
| 55 "select versionid, project, name, ordinal, status " + | 56 "select versionid, project, p.name as projectname, v.name, ordinal, status " + |
| 56 "from lpit_version " + | 57 "from lpit_version v " + |
| 58 "join lpit_project p on v.project = p.projectid " + | |
| 57 "where versionid = ?"); | 59 "where versionid = ?"); |
| 58 | 60 |
| 59 insert = connection.prepareStatement( | 61 insert = connection.prepareStatement( |
| 60 "insert into lpit_version (project, name, ordinal, status) values (?, ?, ?, ?::version_status)" | 62 "insert into lpit_version (project, name, ordinal, status) values (?, ?, ?, ?::version_status)" |
| 61 ); | 63 ); |
| 86 ); | 88 ); |
| 87 } | 89 } |
| 88 | 90 |
| 89 private Version mapColumns(ResultSet result) throws SQLException { | 91 private Version mapColumns(ResultSet result) throws SQLException { |
| 90 final var project = new Project(result.getInt("project")); | 92 final var project = new Project(result.getInt("project")); |
| 93 project.setName(result.getString("projectname")); | |
| 91 final var version = new Version(result.getInt("versionid"), project); | 94 final var version = new Version(result.getInt("versionid"), project); |
| 92 version.setName(result.getString("name")); | 95 version.setName(result.getString("name")); |
| 93 version.setOrdinal(result.getInt("ordinal")); | 96 version.setOrdinal(result.getInt("ordinal")); |
| 94 version.setStatus(VersionStatus.valueOf(result.getString("status"))); | 97 version.setStatus(VersionStatus.valueOf(result.getString("status"))); |
| 95 return version; | 98 return version; |
