comparison: src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
src/main/java/de/uapcore/lightpit/dao/postgres/PGIssueDao.java
- changeset 135
- bafc315294fd
- parent 134
- f47e82cd6077
- child 138
- e2aa673dd473
equal
deleted
inserted
replaced
| 134:f47e82cd6077 | 135:bafc315294fd |
|---|---|
| 86 "left join lpit_user on userid = assignee " + | 86 "left join lpit_user on userid = assignee " + |
| 87 "where issueid = ? "); | 87 "where issueid = ? "); |
| 88 | 88 |
| 89 insert = connection.prepareStatement( | 89 insert = connection.prepareStatement( |
| 90 "insert into lpit_issue (project, component, status, category, subject, description, assignee, eta) " + | 90 "insert into lpit_issue (project, component, status, category, subject, description, assignee, eta) " + |
| 91 "values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?) returning issueid" | 91 "values (?, ?, ?::issue_status, ?::issue_category, ?, ?, ?, ?) returning issueid" |
| 92 ); | 92 ); |
| 93 update = connection.prepareStatement( | 93 update = connection.prepareStatement( |
| 94 "update lpit_issue set " + | 94 "update lpit_issue set " + |
| 95 "updated = now(), component = ?, status = ?::issue_status, category = ?::issue_category, " + | 95 "updated = now(), component = ?, status = ?::issue_status, category = ?::issue_category, " + |
| 96 "subject = ?, description = ?, assignee = ?, eta = ? where issueid = ?" | 96 "subject = ?, description = ?, assignee = ?, eta = ? where issueid = ?" |
