Mercurial > hg > LightPIT / file diff

--- a/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sun Oct 10 15:12:12 2021 +0200
+++ b/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt	Sat Nov 27 10:44:17 2021 +0100
@@ -604,8 +604,8 @@
             }
         withStatement(
             """
-            insert into lpit_issue_history_data (component, status, category, subject, description, assignee, eta, affected, resolved, eventid)
-            values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?)
+            insert into lpit_issue_history_data (component, status, category, subject, description, assignee, assignee_username, eta, affected, resolved, eventid)
+            values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?, ?)
             """.trimIndent()
         ) {
             setStringOrNull(1, issue.component?.name)
@@ -614,10 +614,11 @@
             setString(4, issue.subject)
             setStringOrNull(5, issue.description)
             setStringOrNull(6, issue.assignee?.shortDisplayname)
-            setDateOrNull(7, issue.eta)
-            setStringOrNull(8, issue.affected?.name)
-            setStringOrNull(9, issue.resolved?.name)
-            setInt(10, eventid)
+            setStringOrNull(7, issue.assignee?.username)
+            setDateOrNull(8, issue.eta)
+            setStringOrNull(9, issue.affected?.name)
+            setStringOrNull(10, issue.resolved?.name)
+            setInt(11, eventid)
             executeUpdate()
         }
     }
@@ -725,6 +726,7 @@
                             subject = getString("subject"),
                             description = getString("description") ?: "",
                             assignee = getString("assignee") ?: "",
+                            assigneeUsername = getString("assignee_username") ?: "",
                             eta = getDate("eta"),
                             affected = getString("affected") ?: "",
                             resolved = getString("resolved") ?: ""