Mercurial > hg > LightPIT / changeset

     1.1 --- a/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Sat Oct 31 09:27:36 2020 +0100
     1.2 +++ b/src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java	Sat Oct 31 09:50:15 2020 +0100
     1.3 @@ -67,7 +67,8 @@
     1.4                          "select issueid, versionid from lpit_issue_resolved_version) "+
     1.5                          query +
     1.6                          "left join issue_version using (issueid) "+
     1.7 -                        "where coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)"
     1.8 +                        "where i.project = ? "+
     1.9 +                        "and coalesce(versionid,-1) = ? and coalesce(component, -1) = coalesce(?, component, -1)"
    1.10          );
    1.11  
    1.12          find = connection.prepareStatement(query + "where issueid = ? ");
    1.13 @@ -220,15 +221,17 @@
    1.14  
    1.15      @Override
    1.16      public List<Issue> list(Project project, Component component, Version version) throws SQLException {
    1.17 -        listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1));
    1.18 -        listForVersion.setInt(2, Optional.ofNullable(component).map(Component::getId).orElse(-1));
    1.19 +        listForVersion.setInt(1, project.getId());
    1.20 +        listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1));
    1.21 +        listForVersion.setInt(3, Optional.ofNullable(component).map(Component::getId).orElse(-1));
    1.22          return executeQuery(listForVersion);
    1.23      }
    1.24  
    1.25      @Override
    1.26      public List<Issue> list(Project project, Version version) throws SQLException {
    1.27 -        listForVersion.setInt(1, Optional.ofNullable(version).map(Version::getId).orElse(-1));
    1.28 -        listForVersion.setNull(2, Types.INTEGER);
    1.29 +        listForVersion.setInt(1, project.getId());
    1.30 +        listForVersion.setInt(2, Optional.ofNullable(version).map(Version::getId).orElse(-1));
    1.31 +        listForVersion.setNull(3, Types.INTEGER);
    1.32          return executeQuery(listForVersion);
    1.33      }
    1.34