comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
- changeset 105
- 250c5cbb8276
- parent 88
- 1438e5a22c55
- child 121
- 428dca747d6b
equal
deleted
inserted
replaced
| 104:8be80ea4f52b | 105:250c5cbb8276 |
|---|---|
| 52 list = connection.prepareStatement( | 52 list = connection.prepareStatement( |
| 53 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + | 53 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
| 54 "userid, username, givenname, lastname, mail, " + | 54 "userid, username, givenname, lastname, mail, " + |
| 55 "created, updated, eta " + | 55 "created, updated, eta " + |
| 56 "from lpit_issue i " + | 56 "from lpit_issue i " + |
| 57 "left join lpit_project p on project = projectid " + | 57 "join lpit_project p on project = projectid " + |
| 58 "left join lpit_user on userid = assignee " + | 58 "left join lpit_user on userid = assignee " + |
| 59 "where project = ? "+ | 59 "where project = ? "+ |
| 60 "order by eta asc, updated desc"); | 60 "order by eta asc, updated desc"); |
| 61 | 61 |
| 62 listForVersion = connection.prepareStatement( | 62 listForVersion = connection.prepareStatement( |
| 65 "select issueid, versionid from lpit_issue_resolved_version) "+ | 65 "select issueid, versionid from lpit_issue_resolved_version) "+ |
| 66 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + | 66 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
| 67 "userid, username, givenname, lastname, mail, " + | 67 "userid, username, givenname, lastname, mail, " + |
| 68 "created, updated, eta " + | 68 "created, updated, eta " + |
| 69 "from lpit_issue i " + | 69 "from lpit_issue i " + |
| 70 "join issue_version using (issueid) "+ | 70 "join lpit_project p on project = projectid " + |
| 71 "left join lpit_project p on project = projectid " + | 71 "left join issue_version using (issueid) "+ |
| 72 "left join lpit_user on userid = assignee " + | 72 "left join lpit_user on userid = assignee " + |
| 73 "where versionid = ? "+ | 73 "where coalesce(versionid,-1) = ? "+ |
| 74 "order by eta asc, updated desc" | 74 "order by eta asc, updated desc" |
| 75 ); | 75 ); |
| 76 | 76 |
| 77 find = connection.prepareStatement( | 77 find = connection.prepareStatement( |
| 78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + | 78 "select issueid, project, p.name as projectname, status, category, subject, i.description, " + |
| 220 return list(list, project.getId()); | 220 return list(list, project.getId()); |
| 221 } | 221 } |
| 222 | 222 |
| 223 @Override | 223 @Override |
| 224 public List<Issue> list(Version version) throws SQLException { | 224 public List<Issue> list(Version version) throws SQLException { |
| 225 return list(listForVersion, version.getId()); | 225 return list(listForVersion, version == null ? -1 : version.getId()); |
| 226 } | 226 } |
| 227 | 227 |
| 228 @Override | 228 @Override |
| 229 public Issue find(int id) throws SQLException { | 229 public Issue find(int id) throws SQLException { |
| 230 find.setInt(1, id); | 230 find.setInt(1, id); |
