602 setEnum(2, type) |
602 setEnum(2, type) |
603 querySingle { it.getInt(1) }!! |
603 querySingle { it.getInt(1) }!! |
604 } |
604 } |
605 withStatement( |
605 withStatement( |
606 """ |
606 """ |
607 insert into lpit_issue_history_data (component, status, category, subject, description, assignee, eta, affected, resolved, eventid) |
607 insert into lpit_issue_history_data (component, status, category, subject, description, assignee, assignee_username, eta, affected, resolved, eventid) |
608 values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?) |
608 values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?, ?) |
609 """.trimIndent() |
609 """.trimIndent() |
610 ) { |
610 ) { |
611 setStringOrNull(1, issue.component?.name) |
611 setStringOrNull(1, issue.component?.name) |
612 setEnum(2, issue.status) |
612 setEnum(2, issue.status) |
613 setEnum(3, issue.category) |
613 setEnum(3, issue.category) |
614 setString(4, issue.subject) |
614 setString(4, issue.subject) |
615 setStringOrNull(5, issue.description) |
615 setStringOrNull(5, issue.description) |
616 setStringOrNull(6, issue.assignee?.shortDisplayname) |
616 setStringOrNull(6, issue.assignee?.shortDisplayname) |
617 setDateOrNull(7, issue.eta) |
617 setStringOrNull(7, issue.assignee?.username) |
618 setStringOrNull(8, issue.affected?.name) |
618 setDateOrNull(8, issue.eta) |
619 setStringOrNull(9, issue.resolved?.name) |
619 setStringOrNull(9, issue.affected?.name) |
620 setInt(10, eventid) |
620 setStringOrNull(10, issue.resolved?.name) |
|
621 setInt(11, eventid) |
621 executeUpdate() |
622 executeUpdate() |
622 } |
623 } |
623 } |
624 } |
624 |
625 |
625 //</editor-fold> |
626 //</editor-fold> |
723 status = getEnum("status"), |
724 status = getEnum("status"), |
724 category = getEnum("category"), |
725 category = getEnum("category"), |
725 subject = getString("subject"), |
726 subject = getString("subject"), |
726 description = getString("description") ?: "", |
727 description = getString("description") ?: "", |
727 assignee = getString("assignee") ?: "", |
728 assignee = getString("assignee") ?: "", |
|
729 assigneeUsername = getString("assignee_username") ?: "", |
728 eta = getDate("eta"), |
730 eta = getDate("eta"), |
729 affected = getString("affected") ?: "", |
731 affected = getString("affected") ?: "", |
730 resolved = getString("resolved") ?: "" |
732 resolved = getString("resolved") ?: "" |
731 ) |
733 ) |
732 ) |
734 ) |