elasticcacheresource.go 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279
  1. // Copyright 2019 Yunion
  2. //
  3. // Licensed under the Apache License, Version 2.0 (the "License");
  4. // you may not use this file except in compliance with the License.
  5. // You may obtain a copy of the License at
  6. //
  7. // http://www.apache.org/licenses/LICENSE-2.0
  8. //
  9. // Unless required by applicable law or agreed to in writing, software
  10. // distributed under the License is distributed on an "AS IS" BASIS,
  11. // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12. // See the License for the specific language governing permissions and
  13. // limitations under the License.
  14. package models
  15. import (
  16. "context"
  17. "database/sql"
  18. "yunion.io/x/cloudmux/pkg/cloudprovider"
  19. "yunion.io/x/jsonutils"
  20. "yunion.io/x/log"
  21. "yunion.io/x/pkg/errors"
  22. "yunion.io/x/pkg/util/reflectutils"
  23. "yunion.io/x/sqlchemy"
  24. api "yunion.io/x/onecloud/pkg/apis/compute"
  25. "yunion.io/x/onecloud/pkg/cloudcommon/db"
  26. "yunion.io/x/onecloud/pkg/httperrors"
  27. "yunion.io/x/onecloud/pkg/mcclient"
  28. "yunion.io/x/onecloud/pkg/util/stringutils2"
  29. )
  30. type SElasticcacheResourceBase struct {
  31. // 弹性缓存ID
  32. ElasticcacheId string `width:"36" charset:"ascii" nullable:"false" list:"user" create:"required" index:"true" json:"elasticcache_id"`
  33. }
  34. type SElasticcacheResourceBaseManager struct {
  35. SVpcResourceBaseManager
  36. SZoneResourceBaseManager
  37. }
  38. func ValidateElasticcacheResourceInput(ctx context.Context, userCred mcclient.TokenCredential, input api.ELasticcacheResourceInput) (*SElasticcache, api.ELasticcacheResourceInput, error) {
  39. cacheObj, err := ElasticcacheManager.FetchByIdOrName(ctx, userCred, input.ElasticcacheId)
  40. if err != nil {
  41. if errors.Cause(err) == sql.ErrNoRows {
  42. return nil, input, errors.Wrapf(httperrors.ErrResourceNotFound, "%s %s", ElasticcacheManager.Keyword(), input.ElasticcacheId)
  43. } else {
  44. return nil, input, errors.Wrap(err, "ElasticcacheManager.FetchByIdOrName")
  45. }
  46. }
  47. input.ElasticcacheId = cacheObj.GetId()
  48. return cacheObj.(*SElasticcache), input, nil
  49. }
  50. func (self *SElasticcacheResourceBase) GetElasticcache() (*SElasticcache, error) {
  51. instance, err := ElasticcacheManager.FetchById(self.ElasticcacheId)
  52. if err != nil {
  53. return nil, errors.Wrap(err, "DBInstanceManager.FetchById")
  54. }
  55. return instance.(*SElasticcache), nil
  56. }
  57. func (self *SElasticcacheResourceBase) GetVpc() *SVpc {
  58. cache, err := self.GetElasticcache()
  59. if err != nil {
  60. log.Errorf("GetElasticcache fail %s", err)
  61. return nil
  62. }
  63. vpc, _ := cache.GetVpc()
  64. return vpc
  65. }
  66. func (self *SElasticcacheResourceBase) GetIRegion(ctx context.Context) (cloudprovider.ICloudRegion, error) {
  67. vpc := self.GetVpc()
  68. if vpc == nil {
  69. return nil, errors.Wrap(httperrors.ErrNotFound, "no vpc found")
  70. }
  71. return vpc.GetIRegion(ctx)
  72. }
  73. func (manager *SElasticcacheResourceBaseManager) FetchCustomizeColumns(
  74. ctx context.Context,
  75. userCred mcclient.TokenCredential,
  76. query jsonutils.JSONObject,
  77. objs []interface{},
  78. fields stringutils2.SSortedStrings,
  79. isList bool,
  80. ) []api.ElasticcacheResourceInfo {
  81. rows := make([]api.ElasticcacheResourceInfo, len(objs))
  82. elasticcacheIds := make([]string, len(objs))
  83. for i := range objs {
  84. var base *SElasticcacheResourceBase
  85. reflectutils.FindAnonymouStructPointer(objs[i], &base)
  86. if base != nil {
  87. elasticcacheIds[i] = base.ElasticcacheId
  88. }
  89. }
  90. elasticcaches := make(map[string]SElasticcache)
  91. err := db.FetchStandaloneObjectsByIds(ElasticcacheManager, elasticcacheIds, &elasticcaches)
  92. if err != nil {
  93. log.Errorf("FetchStandaloneObjectsByIds fail %s", err)
  94. return rows
  95. }
  96. vpcList := make([]interface{}, len(rows))
  97. zoneList := make([]interface{}, len(rows))
  98. for i := range rows {
  99. rows[i] = api.ElasticcacheResourceInfo{}
  100. if elasticache, ok := elasticcaches[elasticcacheIds[i]]; ok {
  101. rows[i].Elasticcache = elasticache.Name
  102. rows[i].Engine = elasticache.Engine
  103. rows[i].EngineVersion = elasticache.EngineVersion
  104. rows[i].VpcId = elasticache.VpcId
  105. rows[i].ZoneId = elasticache.ZoneId
  106. }
  107. vpcList[i] = &SVpcResourceBase{rows[i].VpcId}
  108. zoneList[i] = &SZoneResourceBase{rows[i].ZoneId}
  109. }
  110. vpcRows := manager.SVpcResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, vpcList, fields, isList)
  111. zoneRows := manager.SZoneResourceBaseManager.FetchCustomizeColumns(ctx, userCred, query, zoneList, fields, isList)
  112. for i := range rows {
  113. rows[i].VpcResourceInfo = vpcRows[i]
  114. rows[i].ZoneResourceInfoBase = zoneRows[i].ZoneResourceInfoBase
  115. }
  116. return rows
  117. }
  118. func (manager *SElasticcacheResourceBaseManager) ListItemFilter(
  119. ctx context.Context,
  120. q *sqlchemy.SQuery,
  121. userCred mcclient.TokenCredential,
  122. query api.ElasticcacheFilterListInput,
  123. ) (*sqlchemy.SQuery, error) {
  124. if len(query.ElasticcacheId) > 0 {
  125. dbObj, _, err := ValidateElasticcacheResourceInput(ctx, userCred, query.ELasticcacheResourceInput)
  126. if err != nil {
  127. return nil, errors.Wrap(err, "ValidateElasticcacheResourceInput")
  128. }
  129. q = q.Equals("elasticcache_id", dbObj.GetId())
  130. }
  131. subq := ElasticcacheManager.Query("id").Snapshot()
  132. subq, err := manager.SVpcResourceBaseManager.ListItemFilter(ctx, subq, userCred, query.VpcFilterListInput)
  133. if err != nil {
  134. return nil, errors.Wrap(err, "SVpcResourceBaseManager.ListItemFilter")
  135. }
  136. zoneQuery := api.ZonalFilterListInput{
  137. ZonalFilterListBase: query.ZonalFilterListBase,
  138. }
  139. subq, err = manager.SZoneResourceBaseManager.ListItemFilter(ctx, subq, userCred, zoneQuery)
  140. if err != nil {
  141. return nil, errors.Wrap(err, "SZoneResourceBaseManager.ListItemFilter")
  142. }
  143. if subq.IsAltered() {
  144. q = q.Filter(sqlchemy.In(q.Field("elasticcache_id"), subq.SubQuery()))
  145. }
  146. return q, nil
  147. }
  148. func (manager *SElasticcacheResourceBaseManager) QueryDistinctExtraField(q *sqlchemy.SQuery, field string) (*sqlchemy.SQuery, error) {
  149. switch field {
  150. case "elasticcache":
  151. dbQuery := ElasticcacheManager.Query("name", "id").Distinct().SubQuery()
  152. q.AppendField(dbQuery.Field("name", field))
  153. q = q.Join(dbQuery, sqlchemy.Equals(q.Field("elasticcache_id"), dbQuery.Field("id")))
  154. q.GroupBy(dbQuery.Field("name"))
  155. return q, nil
  156. }
  157. elasticcaches := ElasticcacheManager.Query("id", "vpc_id").SubQuery()
  158. q = q.LeftJoin(elasticcaches, sqlchemy.Equals(q.Field("elasticcache_id"), elasticcaches.Field("id")))
  159. q, err := manager.SVpcResourceBaseManager.QueryDistinctExtraField(q, field)
  160. if err == nil {
  161. return q, nil
  162. }
  163. return q, httperrors.ErrNotFound
  164. }
  165. func (manager *SElasticcacheResourceBaseManager) OrderByExtraFields(
  166. ctx context.Context,
  167. q *sqlchemy.SQuery,
  168. userCred mcclient.TokenCredential,
  169. query api.ElasticcacheFilterListInput,
  170. ) (*sqlchemy.SQuery, error) {
  171. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  172. return q, nil
  173. }
  174. orderQ := ElasticcacheManager.Query("id")
  175. orderSubQ := orderQ.SubQuery()
  176. orderQ, orders, fields := manager.GetOrderBySubQuery(orderQ, orderSubQ, orderQ.Field("id"), userCred, query, nil, nil)
  177. q = q.LeftJoin(orderSubQ, sqlchemy.Equals(q.Field("elasticcache_id"), orderSubQ.Field("id")))
  178. q = db.OrderByFields(q, orders, fields)
  179. return q, nil
  180. }
  181. func (manager *SElasticcacheResourceBaseManager) GetOrderBySubQuery(
  182. q *sqlchemy.SQuery,
  183. subq *sqlchemy.SSubQuery,
  184. joinField sqlchemy.IQueryField,
  185. userCred mcclient.TokenCredential,
  186. query api.ElasticcacheFilterListInput,
  187. orders []string,
  188. fields []sqlchemy.IQueryField,
  189. ) (*sqlchemy.SQuery, []string, []sqlchemy.IQueryField) {
  190. if !db.NeedOrderQuery(manager.GetOrderByFields(query)) {
  191. return q, orders, fields
  192. }
  193. cacheQ := ElasticcacheManager.Query("id", "name").SubQuery()
  194. q = q.LeftJoin(cacheQ, sqlchemy.Equals(joinField, cacheQ.Field("id")))
  195. q = q.AppendField(cacheQ.Field("name").Label("elasticcache"))
  196. orders = append(orders, query.OrderByElasticcache)
  197. fields = append(fields, subq.Field("elasticcache"))
  198. q, orders, fields = manager.SVpcResourceBaseManager.GetOrderBySubQuery(q, subq, cacheQ.Field("vpc_id"), userCred, query.VpcFilterListInput, orders, fields)
  199. zoneQuery := api.ZonalFilterListInput{
  200. ZonalFilterListBase: query.ZonalFilterListBase,
  201. }
  202. q, orders, fields = manager.SZoneResourceBaseManager.GetOrderBySubQuery(q, subq, cacheQ.Field("zone_id"), userCred, zoneQuery, orders, fields)
  203. return q, orders, fields
  204. }
  205. func (manager *SElasticcacheResourceBaseManager) GetOrderByFields(query api.ElasticcacheFilterListInput) []string {
  206. fields := make([]string, 0)
  207. vpcFields := manager.SVpcResourceBaseManager.GetOrderByFields(query.VpcFilterListInput)
  208. fields = append(fields, vpcFields...)
  209. zoneQuery := api.ZonalFilterListInput{
  210. ZonalFilterListBase: query.ZonalFilterListBase,
  211. }
  212. zoneFields := manager.SZoneResourceBaseManager.GetOrderByFields(zoneQuery)
  213. fields = append(fields, zoneFields...)
  214. fields = append(fields, query.OrderByElasticcache)
  215. return fields
  216. }
  217. func (manager *SElasticcacheResourceBaseManager) ListItemExportKeys(ctx context.Context,
  218. q *sqlchemy.SQuery,
  219. userCred mcclient.TokenCredential,
  220. keys stringutils2.SSortedStrings,
  221. ) (*sqlchemy.SQuery, error) {
  222. if keys.ContainsAny(manager.GetExportKeys()...) {
  223. var err error
  224. subq := ElasticcacheManager.Query("id", "name", "vpc_id", "zone_id").SubQuery()
  225. q = q.LeftJoin(subq, sqlchemy.Equals(q.Field("elasticcache_id"), subq.Field("id")))
  226. if keys.Contains("elasticcache") {
  227. q = q.AppendField(subq.Field("name", "elasticcache"))
  228. }
  229. if keys.ContainsAny(manager.SVpcResourceBaseManager.GetExportKeys()...) {
  230. q, err = manager.SVpcResourceBaseManager.ListItemExportKeys(ctx, q, userCred, keys)
  231. if err != nil {
  232. return nil, errors.Wrap(err, "SVpcResourceBaseManager.ListItemExportKeys")
  233. }
  234. }
  235. if keys.Contains("zone") {
  236. q, err = manager.SZoneResourceBaseManager.ListItemExportKeys(ctx, q, userCred, keys)
  237. if err != nil {
  238. return nil, errors.Wrap(err, "SZoneResourceBaseManager.ListItemExportKeys")
  239. }
  240. }
  241. }
  242. return q, nil
  243. }
  244. func (manager *SElasticcacheResourceBaseManager) GetExportKeys() []string {
  245. keys := []string{"elasticcache"}
  246. keys = append(keys, manager.SVpcResourceBaseManager.GetExportKeys()...)
  247. keys = append(keys, "zone")
  248. return keys
  249. }
  250. func (self *SElasticcacheResourceBase) GetChangeOwnerCandidateDomainIds() []string {
  251. cache, _ := self.GetElasticcache()
  252. if cache != nil {
  253. return cache.GetChangeOwnerCandidateDomainIds()
  254. }
  255. return nil
  256. }