user_group_memberships.go 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
  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. "fmt"
  19. "sort"
  20. "yunion.io/x/log"
  21. "yunion.io/x/pkg/errors"
  22. "yunion.io/x/onecloud/pkg/cloudcommon/db"
  23. "yunion.io/x/onecloud/pkg/mcclient"
  24. "yunion.io/x/onecloud/pkg/util/stringutils2"
  25. )
  26. // +onecloud:swagger-gen-ignore
  27. type SUsergroupManager struct {
  28. db.SResourceBaseManager
  29. }
  30. var UsergroupManager *SUsergroupManager
  31. func init() {
  32. db.InitManager(func() {
  33. UsergroupManager = &SUsergroupManager{
  34. SResourceBaseManager: db.NewResourceBaseManager(
  35. SUsergroupMembership{},
  36. "user_group_membership",
  37. "usergroup",
  38. "usergroups",
  39. ),
  40. }
  41. UsergroupManager.SetVirtualObject(UsergroupManager)
  42. })
  43. }
  44. /*
  45. +----------+-------------+------+-----+---------+-------+
  46. | Field | Type | Null | Key | Default | Extra |
  47. +----------+-------------+------+-----+---------+-------+
  48. | user_id | varchar(64) | NO | PRI | NULL | |
  49. | group_id | varchar(64) | NO | PRI | NULL | |
  50. +----------+-------------+------+-----+---------+-------+
  51. */
  52. // +onecloud:swagger-gen-ignore
  53. type SUsergroupMembership struct {
  54. db.SResourceBase
  55. UserId string `width:"64" charset:"ascii" nullable:"false" primary:"true"`
  56. GroupId string `width:"64" charset:"ascii" nullable:"false" primary:"true"`
  57. }
  58. func (membership *SUsergroupMembership) GetId() string {
  59. return fmt.Sprintf("%s-%s", membership.UserId, membership.GroupId)
  60. }
  61. func (membership *SUsergroupMembership) GetName() string {
  62. return fmt.Sprintf("%s-%s", membership.UserId, membership.GroupId)
  63. }
  64. func (manager *SUsergroupManager) getUserGroupIds(userId string) []string {
  65. members := make([]SUsergroupMembership, 0)
  66. q := manager.Query().Equals("user_id", userId)
  67. err := db.FetchModelObjects(manager, q, &members)
  68. if err != nil {
  69. log.Errorf("GetUserGroupIds fail %s", err)
  70. return nil
  71. }
  72. groupIds := make([]string, len(members))
  73. for i := range members {
  74. groupIds[i] = members[i].GroupId
  75. }
  76. return groupIds
  77. }
  78. func (manager *SUsergroupManager) getGroupUserIds(groupId string) []string {
  79. members := make([]SUsergroupMembership, 0)
  80. q := manager.Query().Equals("group_id", groupId)
  81. err := db.FetchModelObjects(manager, q, &members)
  82. if err != nil {
  83. log.Errorf("getGroupUserIds fail %s", err)
  84. return nil
  85. }
  86. userIds := make([]string, len(members))
  87. for i := range members {
  88. userIds[i] = members[i].UserId
  89. }
  90. return userIds
  91. }
  92. func (manager *SUsergroupManager) SyncUserGroups(ctx context.Context, userCred mcclient.TokenCredential, userId string, groupIds []string) {
  93. oldGroupIds := manager.getUserGroupIds(userId)
  94. sort.Strings(oldGroupIds)
  95. sort.Strings(groupIds)
  96. deleted, _, added := stringutils2.Split(stringutils2.SSortedStrings(oldGroupIds), stringutils2.SSortedStrings(groupIds))
  97. usr, _ := UserManager.fetchUserById(userId)
  98. for _, gid := range deleted {
  99. grp := GroupManager.fetchGroupById(gid)
  100. manager.remove(ctx, userCred, usr, grp)
  101. }
  102. for _, gid := range added {
  103. grp := GroupManager.fetchGroupById(gid)
  104. manager.add(ctx, userCred, usr, grp)
  105. }
  106. }
  107. func (manager *SUsergroupManager) SyncGroupUsers(ctx context.Context, userCred mcclient.TokenCredential, groupId string, userIds []string) {
  108. oldUserIds := manager.getGroupUserIds(groupId)
  109. sort.Strings(oldUserIds)
  110. sort.Strings(userIds)
  111. deleted, _, added := stringutils2.Split(stringutils2.SSortedStrings(oldUserIds), stringutils2.SSortedStrings(userIds))
  112. grp := GroupManager.fetchGroupById(groupId)
  113. if grp != nil {
  114. for _, uid := range deleted {
  115. usr, _ := UserManager.fetchUserById(uid)
  116. if usr != nil {
  117. manager.remove(ctx, userCred, usr, grp)
  118. }
  119. }
  120. for _, uid := range added {
  121. usr, _ := UserManager.fetchUserById(uid)
  122. if usr != nil {
  123. manager.add(ctx, userCred, usr, grp)
  124. }
  125. }
  126. }
  127. }
  128. func (manager *SUsergroupManager) remove(ctx context.Context, userCred mcclient.TokenCredential, usr *SUser, grp *SGroup) error {
  129. q := manager.Query().Equals("user_id", usr.Id).Equals("group_id", grp.Id)
  130. membership := SUsergroupMembership{}
  131. membership.SetModelManager(manager, &membership)
  132. err := q.First(&membership)
  133. if err != nil {
  134. return errors.Wrap(err, "Query")
  135. }
  136. _, err = db.Update(&membership, func() error {
  137. return membership.MarkDelete()
  138. })
  139. if err != nil {
  140. return errors.Wrap(err, "MarkDelete")
  141. }
  142. db.OpsLog.LogEvent(usr, db.ACT_DETACH, grp.GetShortDesc(ctx), userCred)
  143. return nil
  144. }
  145. func (manager *SUsergroupManager) add(ctx context.Context, userCred mcclient.TokenCredential, user *SUser, group *SGroup) error {
  146. q := manager.RawQuery().Equals("user_id", user.Id).Equals("group_id", group.Id)
  147. membership := SUsergroupMembership{}
  148. membership.SetModelManager(manager, &membership)
  149. err := q.First(&membership)
  150. if err != nil && err != sql.ErrNoRows {
  151. return errors.Wrap(err, "Query")
  152. }
  153. if err == nil {
  154. if membership.Deleted {
  155. _, err = db.Update(&membership, func() error {
  156. membership.Deleted = false
  157. return nil
  158. })
  159. if err != nil {
  160. return errors.Wrap(err, "Update to undelete")
  161. }
  162. } else {
  163. return nil
  164. }
  165. } else {
  166. // create one
  167. membership.UserId = user.Id
  168. membership.GroupId = group.Id
  169. err = manager.TableSpec().Insert(ctx, &membership)
  170. if err != nil {
  171. return errors.Wrap(err, "insert")
  172. }
  173. }
  174. db.OpsLog.LogEvent(user, db.ACT_ATTACH, group.GetShortDesc(ctx), userCred)
  175. return nil
  176. }
  177. func (manager *SUsergroupManager) delete(userId string, groupId string) error {
  178. q := manager.Query()
  179. if len(userId) > 0 {
  180. q = q.Equals("user_id", userId)
  181. }
  182. if len(groupId) > 0 {
  183. q = q.Equals("group_id", groupId)
  184. }
  185. memberships := make([]SUsergroupMembership, 0)
  186. err := db.FetchModelObjects(manager, q, &memberships)
  187. if err != nil {
  188. return errors.Wrap(err, "Query")
  189. }
  190. for i := range memberships {
  191. _, err = db.Update(&memberships[i], func() error {
  192. return memberships[i].MarkDelete()
  193. })
  194. if err != nil {
  195. return errors.Wrap(err, "MarkDelete")
  196. }
  197. }
  198. return nil
  199. }