comparison: src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt
- changeset 239
- 9365c7fb0240
- parent 235
- 4258b9e010ae
- child 241
- 1ca4f27cefe8
equal
deleted
inserted
replaced
| 238:1d48b38ca349 | 239:9365c7fb0240 |
|---|---|
| 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 ) |
