123456789101112131415161718192021222324252627 |
- // Copyright 2022 The Gitea Authors. All rights reserved.
- // SPDX-License-Identifier: MIT
-
- package v1_17 //nolint
-
- import (
- packages_model "code.gitea.io/gitea/models/packages"
- container_module "code.gitea.io/gitea/modules/packages/container"
-
- "xorm.io/xorm"
- "xorm.io/xorm/schemas"
- )
-
- func AddContainerRepositoryProperty(x *xorm.Engine) (err error) {
- switch x.Dialect().URI().DBType {
- case schemas.SQLITE:
- _, err = x.Exec("INSERT INTO package_property (ref_type, ref_id, name, value) SELECT ?, p.id, ?, u.lower_name || '/' || p.lower_name FROM package p JOIN `user` u ON p.owner_id = u.id WHERE p.type = ?",
- packages_model.PropertyTypePackage, container_module.PropertyRepository, packages_model.TypeContainer)
- case schemas.MSSQL:
- _, err = x.Exec("INSERT INTO package_property (ref_type, ref_id, name, value) SELECT ?, p.id, ?, u.lower_name + '/' + p.lower_name FROM package p JOIN `user` u ON p.owner_id = u.id WHERE p.type = ?",
- packages_model.PropertyTypePackage, container_module.PropertyRepository, packages_model.TypeContainer)
- default:
- _, err = x.Exec("INSERT INTO package_property (ref_type, ref_id, name, value) SELECT ?, p.id, ?, CONCAT(u.lower_name, '/', p.lower_name) FROM package p JOIN `user` u ON p.owner_id = u.id WHERE p.type = ?",
- packages_model.PropertyTypePackage, container_module.PropertyRepository, packages_model.TypeContainer)
- }
- return err
- }
|