user_mail.go 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. // Copyright 2016 The Gogs Authors. All rights reserved.
  2. // Use of this source code is governed by a MIT-style
  3. // license that can be found in the LICENSE file.
  4. package db
  5. import (
  6. "fmt"
  7. "strings"
  8. "gogs.io/gogs/internal/db/errors"
  9. "gogs.io/gogs/internal/errutil"
  10. "gogs.io/gogs/internal/userutil"
  11. )
  12. // EmailAddresses is the list of all email addresses of a user. Can contain the
  13. // primary email address, but is not obligatory.
  14. type EmailAddress struct {
  15. ID int64
  16. UID int64 `xorm:"INDEX NOT NULL" gorm:"index;not null"`
  17. Email string `xorm:"UNIQUE NOT NULL" gorm:"unique;not null"`
  18. IsActivated bool `gorm:"not null;default:FALSE"`
  19. IsPrimary bool `xorm:"-" gorm:"-" json:"-"`
  20. }
  21. // GetEmailAddresses returns all email addresses belongs to given user.
  22. func GetEmailAddresses(uid int64) ([]*EmailAddress, error) {
  23. emails := make([]*EmailAddress, 0, 5)
  24. if err := x.Where("uid=?", uid).Find(&emails); err != nil {
  25. return nil, err
  26. }
  27. u, err := GetUserByID(uid)
  28. if err != nil {
  29. return nil, err
  30. }
  31. isPrimaryFound := false
  32. for _, email := range emails {
  33. if email.Email == u.Email {
  34. isPrimaryFound = true
  35. email.IsPrimary = true
  36. } else {
  37. email.IsPrimary = false
  38. }
  39. }
  40. // We always want the primary email address displayed, even if it's not in
  41. // the emailaddress table (yet).
  42. if !isPrimaryFound {
  43. emails = append(emails, &EmailAddress{
  44. Email: u.Email,
  45. IsActivated: true,
  46. IsPrimary: true,
  47. })
  48. }
  49. return emails, nil
  50. }
  51. func isEmailUsed(e Engine, email string) (bool, error) {
  52. if email == "" {
  53. return true, nil
  54. }
  55. has, err := e.Get(&EmailAddress{Email: email})
  56. if err != nil {
  57. return false, err
  58. } else if has {
  59. return true, nil
  60. }
  61. // We need to check primary email of users as well.
  62. return e.Where("type=?", UserTypeIndividual).And("email=?", email).Get(new(User))
  63. }
  64. // IsEmailUsed returns true if the email has been used.
  65. func IsEmailUsed(email string) (bool, error) {
  66. return isEmailUsed(x, email)
  67. }
  68. func addEmailAddress(e Engine, email *EmailAddress) error {
  69. email.Email = strings.ToLower(strings.TrimSpace(email.Email))
  70. used, err := isEmailUsed(e, email.Email)
  71. if err != nil {
  72. return err
  73. } else if used {
  74. return ErrEmailAlreadyUsed{args: errutil.Args{"email": email.Email}}
  75. }
  76. _, err = e.Insert(email)
  77. return err
  78. }
  79. func AddEmailAddress(email *EmailAddress) error {
  80. return addEmailAddress(x, email)
  81. }
  82. func AddEmailAddresses(emails []*EmailAddress) error {
  83. if len(emails) == 0 {
  84. return nil
  85. }
  86. // Check if any of them has been used
  87. for i := range emails {
  88. emails[i].Email = strings.ToLower(strings.TrimSpace(emails[i].Email))
  89. used, err := IsEmailUsed(emails[i].Email)
  90. if err != nil {
  91. return err
  92. } else if used {
  93. return ErrEmailAlreadyUsed{args: errutil.Args{"email": emails[i].Email}}
  94. }
  95. }
  96. if _, err := x.Insert(emails); err != nil {
  97. return fmt.Errorf("Insert: %v", err)
  98. }
  99. return nil
  100. }
  101. func (email *EmailAddress) Activate() error {
  102. user, err := GetUserByID(email.UID)
  103. if err != nil {
  104. return err
  105. }
  106. if user.Rands, err = userutil.RandomSalt(); err != nil {
  107. return err
  108. }
  109. sess := x.NewSession()
  110. defer sess.Close()
  111. if err = sess.Begin(); err != nil {
  112. return err
  113. }
  114. email.IsActivated = true
  115. if _, err := sess.ID(email.ID).AllCols().Update(email); err != nil {
  116. return err
  117. } else if err = updateUser(sess, user); err != nil {
  118. return err
  119. }
  120. return sess.Commit()
  121. }
  122. func DeleteEmailAddress(email *EmailAddress) (err error) {
  123. if email.ID > 0 {
  124. _, err = x.Id(email.ID).Delete(new(EmailAddress))
  125. } else {
  126. _, err = x.Where("email=?", email.Email).Delete(new(EmailAddress))
  127. }
  128. return err
  129. }
  130. func DeleteEmailAddresses(emails []*EmailAddress) (err error) {
  131. for i := range emails {
  132. if err = DeleteEmailAddress(emails[i]); err != nil {
  133. return err
  134. }
  135. }
  136. return nil
  137. }
  138. func MakeEmailPrimary(userID int64, email *EmailAddress) error {
  139. has, err := x.Get(email)
  140. if err != nil {
  141. return err
  142. } else if !has {
  143. return errors.EmailNotFound{Email: email.Email}
  144. }
  145. if email.UID != userID {
  146. return errors.New("not the owner of the email")
  147. }
  148. if !email.IsActivated {
  149. return errors.EmailNotVerified{Email: email.Email}
  150. }
  151. user := &User{ID: email.UID}
  152. has, err = x.Get(user)
  153. if err != nil {
  154. return err
  155. } else if !has {
  156. return ErrUserNotExist{args: map[string]interface{}{"userID": email.UID}}
  157. }
  158. // Make sure the former primary email doesn't disappear.
  159. formerPrimaryEmail := &EmailAddress{Email: user.Email}
  160. has, err = x.Get(formerPrimaryEmail)
  161. if err != nil {
  162. return err
  163. }
  164. sess := x.NewSession()
  165. defer sess.Close()
  166. if err = sess.Begin(); err != nil {
  167. return err
  168. }
  169. if !has {
  170. formerPrimaryEmail.UID = user.ID
  171. formerPrimaryEmail.IsActivated = user.IsActive
  172. if _, err = sess.Insert(formerPrimaryEmail); err != nil {
  173. return err
  174. }
  175. }
  176. user.Email = email.Email
  177. if _, err = sess.ID(user.ID).AllCols().Update(user); err != nil {
  178. return err
  179. }
  180. return sess.Commit()
  181. }