code.gitea.io/gitea@v1.21.7/models/migrations/v1_12/v139.go (about) 1 // Copyright 2019 The Gitea Authors. All rights reserved. 2 // SPDX-License-Identifier: MIT 3 4 package v1_12 //nolint 5 6 import ( 7 "code.gitea.io/gitea/modules/setting" 8 9 "xorm.io/xorm" 10 ) 11 12 func PrependRefsHeadsToIssueRefs(x *xorm.Engine) error { 13 var query string 14 15 switch { 16 case setting.Database.Type.IsMSSQL(): 17 query = "UPDATE `issue` SET `ref` = 'refs/heads/' + `ref` WHERE `ref` IS NOT NULL AND `ref` <> '' AND `ref` NOT LIKE 'refs/%'" 18 case setting.Database.Type.IsMySQL(): 19 query = "UPDATE `issue` SET `ref` = CONCAT('refs/heads/', `ref`) WHERE `ref` IS NOT NULL AND `ref` <> '' AND `ref` NOT LIKE 'refs/%';" 20 default: 21 query = "UPDATE `issue` SET `ref` = 'refs/heads/' || `ref` WHERE `ref` IS NOT NULL AND `ref` <> '' AND `ref` NOT LIKE 'refs/%'" 22 } 23 24 _, err := x.Exec(query) 25 return err 26 }