comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
- changeset 154
- 3d10f2a390a1
- parent 150
- 822b7e3d064d
equal
deleted
inserted
replaced
| 153:e914fbf4decc | 154:3d10f2a390a1 |
|---|---|
| 65 "with issue_version as ( "+ | 65 "with issue_version as ( "+ |
| 66 "select issueid, versionid from lpit_issue_affected_version union "+ | 66 "select issueid, versionid from lpit_issue_affected_version union "+ |
| 67 "select issueid, versionid from lpit_issue_resolved_version) "+ | 67 "select issueid, versionid from lpit_issue_resolved_version) "+ |
| 68 query + | 68 query + |
| 69 "left join issue_version using (issueid) "+ | 69 "left join issue_version using (issueid) "+ |
| 70 "where coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)" | 70 "where i.project = ? "+ |
| 71 "and coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)" | |
| 71 ); | 72 ); |
| 72 | 73 |
| 73 find = connection.prepareStatement(query + "where issueid = ? "); | 74 find = connection.prepareStatement(query + "where issueid = ? "); |
| 74 | 75 |
| 75 insert = connection.prepareStatement( | 76 insert = connection.prepareStatement( |
| 218 return executeQuery(list); | 219 return executeQuery(list); |
| 219 } | 220 } |
| 220 | 221 |
| 221 @Override | 222 @Override |
| 222 public List<Issue> list(Project project, Component component, Version version) throws SQLException { | 223 public List<Issue> list(Project project, Component component, Version version) throws SQLException { |
| 223 listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1)); | 224 listForVersion.setInt(1, project.getId()); |
| 224 listForVersion.setInt(2, Optional.ofNullable(component).map(Component::getId).orElse(-1)); | 225 listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1)); |
| 226 listForVersion.setInt(3, Optional.ofNullable(component).map(Component::getId).orElse(-1)); | |
| 225 return executeQuery(listForVersion); | 227 return executeQuery(listForVersion); |
| 226 } | 228 } |
| 227 | 229 |
| 228 @Override | 230 @Override |
| 229 public List<Issue> list(Project project, Version version) throws SQLException { | 231 public List<Issue> list(Project project, Version version) throws SQLException { |
| 230 listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1)); | 232 listForVersion.setInt(1, project.getId()); |
| 231 listForVersion.setNull(2, Types.INTEGER); | 233 listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1)); |
| 234 listForVersion.setNull(3, Types.INTEGER); | |
| 232 return executeQuery(listForVersion); | 235 return executeQuery(listForVersion); |
| 233 } | 236 } |
| 234 | 237 |
| 235 @Override | 238 @Override |
| 236 public List<Issue> list(Project project, Component component) throws SQLException { | 239 public List<Issue> list(Project project, Component component) throws SQLException { |
