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 = ?" |