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