(devlake) branch main updated: fix(jenkins): truncate primary_view to fit varchar(255) column (#8899)

[zky]

This is an automated email from the ASF dual-hosted git repository.

Startrekzky pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/devlake.git


The following commit(s) were added to refs/heads/main by this push:
     new ecb905d7a fix(jenkins): truncate primary_view to fit varchar(255) 
column (#8899)
ecb905d7a is described below

commit ecb905d7af6df3ac349705f63a3ea9b2f8b7b69e
Author: Klesh Wong <kl...@qq.com>
AuthorDate: Fri Jun 5 12:15:47 2026 +0800

    fix(jenkins): truncate primary_view to fit varchar(255) column (#8899)
    
    * fix(jenkins): truncate primary_view to fit varchar(255) column
    
    Fixes Error 1406 (22001): Data too long for column 'primary_view'
    by truncating the concatenated value to 255 characters before saving.
    
    Closes https://github.com/apache/devlake/issues/8897
    
    * ci: exclude generated mocks from golangci-lint
---
 backend/.golangci.yaml                     | 1 +
 backend/plugins/jenkins/models/response.go | 7 ++++++-
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/backend/.golangci.yaml b/backend/.golangci.yaml
index 4eb8ec0dc..fa4042b6b 100644
--- a/backend/.golangci.yaml
+++ b/backend/.golangci.yaml
@@ -243,6 +243,7 @@ linters:
       - third_party$
       - builtin$
       - examples$
+      - mocks$
 formatters:
   enable:
     - gofmt
diff --git a/backend/plugins/jenkins/models/response.go 
b/backend/plugins/jenkins/models/response.go
index 643bec691..93eae397b 100644
--- a/backend/plugins/jenkins/models/response.go
+++ b/backend/plugins/jenkins/models/response.go
@@ -61,6 +61,11 @@ func (j Job) ToJenkinsJob() *JenkinsJob {
                }
        }
 
+       primaryView := j.URL + j.Path + j.Class
+       if len(primaryView) > 255 {
+               primaryView = primaryView[:255]
+       }
+
        return &JenkinsJob{
                FullName:    j.FullName,
                Name:        j.Name,
@@ -70,7 +75,7 @@ func (j Job) ToJenkinsJob() *JenkinsJob {
                Base:        j.Base,
                Url:         j.URL,
                Description: j.Description,
-               PrimaryView: j.URL + j.Path + j.Class,
+               PrimaryView: primaryView,
        }
 }