1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91
92. 92
93. 93
94. 94
95. 95
96. 96
97. 97
98. 98
99. 99
100. 100
101. 101
102. 102
103. 103
104. 104
105. 105
106. 106
107. 107
108. 108
109. 109
110. 110
111. 111
112. 112
113. 113
114. 114
115. 115
116. 116
117. 117
118. 118
119. 119
120. 120
121. 121
122. 122
123. 123
124. 124
125. 125
126. 126
127. 127
128. 128
129. 129
130. 130
131. 131
132. 132
133. 133
134. 134
135. 135
136. 136
137. 137
138. 138
139. 139
140. 140
141. 141
142. 142
143. 143
144. 144
145. 145
146. 146
147. 147
148. 148
149. 149

// Copyright 2022 The Gitea Authors. All rights reserved.
// SPDX-License-Identifier: MIT

package conan

import (
	"context"
	"fmt"
	"strconv"
	"strings"

	"code.gitea.io/gitea/models/db"
	"code.gitea.io/gitea/models/packages"
	"code.gitea.io/gitea/modules/container"
	conan_module "code.gitea.io/gitea/modules/packages/conan"

	"xorm.io/builder"
)

// buildCondition creates a Like condition if a wildcard is present. Otherwise Eq is used.
func buildCondition(name, value string) builder.Cond {
	if strings.Contains(value, "*") {
		return builder.Like{name, strings.ReplaceAll(strings.ReplaceAll(value, "_", "\\_"), "*", "%")}
	}
	return builder.Eq{name: value}
}

type RecipeSearchOptions struct {
	OwnerID int64
	Name    string
	Version string
	User    string
	Channel string
}

// SearchRecipes gets all recipes matching the search options
func SearchRecipes(ctx context.Context, opts *RecipeSearchOptions) ([]string, error) {
	var cond builder.Cond = builder.Eq{
		"package_file.is_lead":        true,
		"package.type":                packages.TypeConan,
		"package.owner_id":            opts.OwnerID,
		"package_version.is_internal": false,
	}

	if opts.Name != "" {
		cond = cond.And(buildCondition("package.lower_name", strings.ToLower(opts.Name)))
	}
	if opts.Version != "" {
		cond = cond.And(buildCondition("package_version.lower_version", strings.ToLower(opts.Version)))
	}
	if opts.User != "" || opts.Channel != "" {
		var propsCond builder.Cond = builder.Eq{
			"package_property.ref_type": packages.PropertyTypeFile,
		}
		propsCond = propsCond.And(builder.Expr("package_property.ref_id = package_file.id"))

		count := 0
		propsCondBlock := builder.NewCond()
		if opts.User != "" {
			count++
			propsCondBlock = propsCondBlock.Or(builder.Eq{"package_property.name": conan_module.PropertyRecipeUser}.And(buildCondition("package_property.value", opts.User)))
		}
		if opts.Channel != "" {
			count++
			propsCondBlock = propsCondBlock.Or(builder.Eq{"package_property.name": conan_module.PropertyRecipeChannel}.And(buildCondition("package_property.value", opts.Channel)))
		}
		propsCond = propsCond.And(propsCondBlock)

		cond = cond.And(builder.Eq{
			strconv.Itoa(count): builder.Select("COUNT(*)").Where(propsCond).From("package_property"),
		})
	}

	query := builder.
		Select("package.name, package_version.version, package_file.id").
		From("package_file").
		InnerJoin("package_version", "package_version.id = package_file.version_id").
		InnerJoin("package", "package.id = package_version.package_id").
		Where(cond)

	results := make([]struct {
		Name    string
		Version string
		ID      int64
	}, 0, 5)
	err := db.GetEngine(ctx).SQL(query).Find(&results)
	if err != nil {
		return nil, err
	}

	unique := make(container.Set[string])
	for _, info := range results {
		recipe := fmt.Sprintf("%s/%s", info.Name, info.Version)

		props, _ := packages.GetProperties(ctx, packages.PropertyTypeFile, info.ID)
		if len(props) > 0 {
			var (
				user    = ""
				channel = ""
			)
			for _, prop := range props {
				if prop.Name == conan_module.PropertyRecipeUser {
					user = prop.Value
				}
				if prop.Name == conan_module.PropertyRecipeChannel {
					channel = prop.Value
				}
			}
			if user != "" && channel != "" {
				recipe = fmt.Sprintf("%s@%s/%s", recipe, user, channel)
			}
		}

		unique.Add(recipe)
	}

	recipes := make([]string, 0, len(unique))
	for recipe := range unique {
		recipes = append(recipes, recipe)
	}
	return recipes, nil
}

// GetPackageInfo gets the Conaninfo for a package
func GetPackageInfo(ctx context.Context, ownerID int64, ref *conan_module.PackageReference) (string, error) {
	values, err := findPropertyValues(
		ctx,
		conan_module.PropertyPackageInfo,
		ownerID,
		ref.Recipe.Name,
		ref.Recipe.Version,
		map[string]string{
			conan_module.PropertyRecipeUser:       ref.Recipe.User,
			conan_module.PropertyRecipeChannel:    ref.Recipe.Channel,
			conan_module.PropertyRecipeRevision:   ref.Recipe.Revision,
			conan_module.PropertyPackageReference: ref.Reference,
			conan_module.PropertyPackageRevision:  ref.Revision,
		},
	)
	if err != nil {
		return "", err
	}

	if len(values) == 0 {
		return "", ErrPackageReferenceNotExist
	}

	return values[0].Value, nil
}