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; |