user.go 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161
  1. // Copyright 2014 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. "bytes"
  7. "crypto/sha256"
  8. "crypto/subtle"
  9. "encoding/hex"
  10. "fmt"
  11. "image"
  12. _ "image/jpeg"
  13. "image/png"
  14. "os"
  15. "path/filepath"
  16. "strings"
  17. "time"
  18. "unicode/utf8"
  19. "github.com/nfnt/resize"
  20. "github.com/unknwon/com"
  21. "golang.org/x/crypto/pbkdf2"
  22. log "unknwon.dev/clog/v2"
  23. "xorm.io/xorm"
  24. "github.com/gogs/git-module"
  25. api "github.com/gogs/go-gogs-client"
  26. "gogs.io/gogs/internal/avatar"
  27. "gogs.io/gogs/internal/conf"
  28. "gogs.io/gogs/internal/db/errors"
  29. "gogs.io/gogs/internal/errutil"
  30. "gogs.io/gogs/internal/tool"
  31. )
  32. // USER_AVATAR_URL_PREFIX is used to identify a URL is to access user avatar.
  33. const USER_AVATAR_URL_PREFIX = "avatars"
  34. type UserType int
  35. const (
  36. USER_TYPE_INDIVIDUAL UserType = iota // Historic reason to make it starts at 0.
  37. USER_TYPE_ORGANIZATION
  38. )
  39. // User represents the object of individual and member of organization.
  40. type User struct {
  41. ID int64
  42. LowerName string `xorm:"UNIQUE NOT NULL"`
  43. Name string `xorm:"UNIQUE NOT NULL"`
  44. FullName string
  45. // Email is the primary email address (to be used for communication)
  46. Email string `xorm:"NOT NULL"`
  47. Passwd string `xorm:"NOT NULL"`
  48. LoginType LoginType
  49. LoginSource int64 `xorm:"NOT NULL DEFAULT 0"`
  50. LoginName string
  51. Type UserType
  52. OwnedOrgs []*User `xorm:"-" json:"-"`
  53. Orgs []*User `xorm:"-" json:"-"`
  54. Repos []*Repository `xorm:"-" json:"-"`
  55. Location string
  56. Website string
  57. Rands string `xorm:"VARCHAR(10)"`
  58. Salt string `xorm:"VARCHAR(10)"`
  59. Created time.Time `xorm:"-" json:"-"`
  60. CreatedUnix int64
  61. Updated time.Time `xorm:"-" json:"-"`
  62. UpdatedUnix int64
  63. // Remember visibility choice for convenience, true for private
  64. LastRepoVisibility bool
  65. // Maximum repository creation limit, -1 means use gloabl default
  66. MaxRepoCreation int `xorm:"NOT NULL DEFAULT -1"`
  67. // Permissions
  68. IsActive bool // Activate primary email
  69. IsAdmin bool
  70. AllowGitHook bool
  71. AllowImportLocal bool // Allow migrate repository by local path
  72. ProhibitLogin bool
  73. // Avatar
  74. Avatar string `xorm:"VARCHAR(2048) NOT NULL"`
  75. AvatarEmail string `xorm:"NOT NULL"`
  76. UseCustomAvatar bool
  77. // Counters
  78. NumFollowers int
  79. NumFollowing int `xorm:"NOT NULL DEFAULT 0"`
  80. NumStars int
  81. NumRepos int
  82. // For organization
  83. Description string
  84. NumTeams int
  85. NumMembers int
  86. Teams []*Team `xorm:"-" json:"-"`
  87. Members []*User `xorm:"-" json:"-"`
  88. }
  89. func (u *User) BeforeInsert() {
  90. u.CreatedUnix = time.Now().Unix()
  91. u.UpdatedUnix = u.CreatedUnix
  92. }
  93. func (u *User) BeforeUpdate() {
  94. if u.MaxRepoCreation < -1 {
  95. u.MaxRepoCreation = -1
  96. }
  97. u.UpdatedUnix = time.Now().Unix()
  98. }
  99. func (u *User) AfterSet(colName string, _ xorm.Cell) {
  100. switch colName {
  101. case "created_unix":
  102. u.Created = time.Unix(u.CreatedUnix, 0).Local()
  103. case "updated_unix":
  104. u.Updated = time.Unix(u.UpdatedUnix, 0).Local()
  105. }
  106. }
  107. // IDStr returns string representation of user's ID.
  108. func (u *User) IDStr() string {
  109. return com.ToStr(u.ID)
  110. }
  111. func (u *User) APIFormat() *api.User {
  112. return &api.User{
  113. ID: u.ID,
  114. UserName: u.Name,
  115. Login: u.Name,
  116. FullName: u.FullName,
  117. Email: u.Email,
  118. AvatarUrl: u.AvatarLink(),
  119. }
  120. }
  121. // returns true if user login type is LOGIN_PLAIN.
  122. func (u *User) IsLocal() bool {
  123. return u.LoginType <= LOGIN_PLAIN
  124. }
  125. // HasForkedRepo checks if user has already forked a repository with given ID.
  126. func (u *User) HasForkedRepo(repoID int64) bool {
  127. _, has, _ := HasForkedRepo(u.ID, repoID)
  128. return has
  129. }
  130. func (u *User) RepoCreationNum() int {
  131. if u.MaxRepoCreation <= -1 {
  132. return conf.Repository.MaxCreationLimit
  133. }
  134. return u.MaxRepoCreation
  135. }
  136. func (u *User) CanCreateRepo() bool {
  137. if u.MaxRepoCreation <= -1 {
  138. if conf.Repository.MaxCreationLimit <= -1 {
  139. return true
  140. }
  141. return u.NumRepos < conf.Repository.MaxCreationLimit
  142. }
  143. return u.NumRepos < u.MaxRepoCreation
  144. }
  145. func (u *User) CanCreateOrganization() bool {
  146. return !conf.Admin.DisableRegularOrgCreation || u.IsAdmin
  147. }
  148. // CanEditGitHook returns true if user can edit Git hooks.
  149. func (u *User) CanEditGitHook() bool {
  150. return u.IsAdmin || u.AllowGitHook
  151. }
  152. // CanImportLocal returns true if user can migrate repository by local path.
  153. func (u *User) CanImportLocal() bool {
  154. return conf.Repository.EnableLocalPathMigration && (u.IsAdmin || u.AllowImportLocal)
  155. }
  156. // DashboardLink returns the user dashboard page link.
  157. func (u *User) DashboardLink() string {
  158. if u.IsOrganization() {
  159. return conf.Server.Subpath + "/org/" + u.Name + "/dashboard/"
  160. }
  161. return conf.Server.Subpath + "/"
  162. }
  163. // HomeLink returns the user or organization home page link.
  164. func (u *User) HomeLink() string {
  165. return conf.Server.Subpath + "/" + u.Name
  166. }
  167. func (u *User) HTMLURL() string {
  168. return conf.Server.ExternalURL + u.Name
  169. }
  170. // GenerateEmailActivateCode generates an activate code based on user information and given e-mail.
  171. func (u *User) GenerateEmailActivateCode(email string) string {
  172. code := tool.CreateTimeLimitCode(
  173. com.ToStr(u.ID)+email+u.LowerName+u.Passwd+u.Rands,
  174. conf.Auth.ActivateCodeLives, nil)
  175. // Add tail hex username
  176. code += hex.EncodeToString([]byte(u.LowerName))
  177. return code
  178. }
  179. // GenerateActivateCode generates an activate code based on user information.
  180. func (u *User) GenerateActivateCode() string {
  181. return u.GenerateEmailActivateCode(u.Email)
  182. }
  183. // CustomAvatarPath returns user custom avatar file path.
  184. func (u *User) CustomAvatarPath() string {
  185. return filepath.Join(conf.Picture.AvatarUploadPath, com.ToStr(u.ID))
  186. }
  187. // GenerateRandomAvatar generates a random avatar for user.
  188. func (u *User) GenerateRandomAvatar() error {
  189. seed := u.Email
  190. if len(seed) == 0 {
  191. seed = u.Name
  192. }
  193. img, err := avatar.RandomImage([]byte(seed))
  194. if err != nil {
  195. return fmt.Errorf("RandomImage: %v", err)
  196. }
  197. if err = os.MkdirAll(filepath.Dir(u.CustomAvatarPath()), os.ModePerm); err != nil {
  198. return fmt.Errorf("MkdirAll: %v", err)
  199. }
  200. fw, err := os.Create(u.CustomAvatarPath())
  201. if err != nil {
  202. return fmt.Errorf("Create: %v", err)
  203. }
  204. defer fw.Close()
  205. if err = png.Encode(fw, img); err != nil {
  206. return fmt.Errorf("Encode: %v", err)
  207. }
  208. log.Info("New random avatar created: %d", u.ID)
  209. return nil
  210. }
  211. // RelAvatarLink returns relative avatar link to the site domain,
  212. // which includes app sub-url as prefix. However, it is possible
  213. // to return full URL if user enables Gravatar-like service.
  214. func (u *User) RelAvatarLink() string {
  215. defaultImgUrl := conf.Server.Subpath + "/img/avatar_default.png"
  216. if u.ID == -1 {
  217. return defaultImgUrl
  218. }
  219. switch {
  220. case u.UseCustomAvatar:
  221. if !com.IsExist(u.CustomAvatarPath()) {
  222. return defaultImgUrl
  223. }
  224. return fmt.Sprintf("%s/%s/%d", conf.Server.Subpath, USER_AVATAR_URL_PREFIX, u.ID)
  225. case conf.Picture.DisableGravatar:
  226. if !com.IsExist(u.CustomAvatarPath()) {
  227. if err := u.GenerateRandomAvatar(); err != nil {
  228. log.Error("GenerateRandomAvatar: %v", err)
  229. }
  230. }
  231. return fmt.Sprintf("%s/%s/%d", conf.Server.Subpath, USER_AVATAR_URL_PREFIX, u.ID)
  232. }
  233. return tool.AvatarLink(u.AvatarEmail)
  234. }
  235. // AvatarLink returns user avatar absolute link.
  236. func (u *User) AvatarLink() string {
  237. link := u.RelAvatarLink()
  238. if link[0] == '/' && link[1] != '/' {
  239. return conf.Server.ExternalURL + strings.TrimPrefix(link, conf.Server.Subpath)[1:]
  240. }
  241. return link
  242. }
  243. // User.GetFollwoers returns range of user's followers.
  244. func (u *User) GetFollowers(page int) ([]*User, error) {
  245. users := make([]*User, 0, ItemsPerPage)
  246. sess := x.Limit(ItemsPerPage, (page-1)*ItemsPerPage).Where("follow.follow_id=?", u.ID)
  247. if conf.UsePostgreSQL {
  248. sess = sess.Join("LEFT", "follow", `"user".id=follow.user_id`)
  249. } else {
  250. sess = sess.Join("LEFT", "follow", "user.id=follow.user_id")
  251. }
  252. return users, sess.Find(&users)
  253. }
  254. func (u *User) IsFollowing(followID int64) bool {
  255. return IsFollowing(u.ID, followID)
  256. }
  257. // GetFollowing returns range of user's following.
  258. func (u *User) GetFollowing(page int) ([]*User, error) {
  259. users := make([]*User, 0, ItemsPerPage)
  260. sess := x.Limit(ItemsPerPage, (page-1)*ItemsPerPage).Where("follow.user_id=?", u.ID)
  261. if conf.UsePostgreSQL {
  262. sess = sess.Join("LEFT", "follow", `"user".id=follow.follow_id`)
  263. } else {
  264. sess = sess.Join("LEFT", "follow", "user.id=follow.follow_id")
  265. }
  266. return users, sess.Find(&users)
  267. }
  268. // NewGitSig generates and returns the signature of given user.
  269. func (u *User) NewGitSig() *git.Signature {
  270. return &git.Signature{
  271. Name: u.DisplayName(),
  272. Email: u.Email,
  273. When: time.Now(),
  274. }
  275. }
  276. // EncodePasswd encodes password to safe format.
  277. func (u *User) EncodePasswd() {
  278. newPasswd := pbkdf2.Key([]byte(u.Passwd), []byte(u.Salt), 10000, 50, sha256.New)
  279. u.Passwd = fmt.Sprintf("%x", newPasswd)
  280. }
  281. // ValidatePassword checks if given password matches the one belongs to the user.
  282. func (u *User) ValidatePassword(passwd string) bool {
  283. newUser := &User{Passwd: passwd, Salt: u.Salt}
  284. newUser.EncodePasswd()
  285. return subtle.ConstantTimeCompare([]byte(u.Passwd), []byte(newUser.Passwd)) == 1
  286. }
  287. // UploadAvatar saves custom avatar for user.
  288. // FIXME: split uploads to different subdirs in case we have massive number of users.
  289. func (u *User) UploadAvatar(data []byte) error {
  290. img, _, err := image.Decode(bytes.NewReader(data))
  291. if err != nil {
  292. return fmt.Errorf("decode image: %v", err)
  293. }
  294. _ = os.MkdirAll(conf.Picture.AvatarUploadPath, os.ModePerm)
  295. fw, err := os.Create(u.CustomAvatarPath())
  296. if err != nil {
  297. return fmt.Errorf("create custom avatar directory: %v", err)
  298. }
  299. defer fw.Close()
  300. m := resize.Resize(avatar.AVATAR_SIZE, avatar.AVATAR_SIZE, img, resize.NearestNeighbor)
  301. if err = png.Encode(fw, m); err != nil {
  302. return fmt.Errorf("encode image: %v", err)
  303. }
  304. return nil
  305. }
  306. // DeleteAvatar deletes the user's custom avatar.
  307. func (u *User) DeleteAvatar() error {
  308. log.Trace("DeleteAvatar [%d]: %s", u.ID, u.CustomAvatarPath())
  309. if err := os.Remove(u.CustomAvatarPath()); err != nil {
  310. return err
  311. }
  312. u.UseCustomAvatar = false
  313. return UpdateUser(u)
  314. }
  315. // IsAdminOfRepo returns true if user has admin or higher access of repository.
  316. func (u *User) IsAdminOfRepo(repo *Repository) bool {
  317. has, err := HasAccess(u.ID, repo, ACCESS_MODE_ADMIN)
  318. if err != nil {
  319. log.Error("HasAccess: %v", err)
  320. }
  321. return has
  322. }
  323. // IsWriterOfRepo returns true if user has write access to given repository.
  324. func (u *User) IsWriterOfRepo(repo *Repository) bool {
  325. has, err := HasAccess(u.ID, repo, ACCESS_MODE_WRITE)
  326. if err != nil {
  327. log.Error("HasAccess: %v", err)
  328. }
  329. return has
  330. }
  331. // IsOrganization returns true if user is actually a organization.
  332. func (u *User) IsOrganization() bool {
  333. return u.Type == USER_TYPE_ORGANIZATION
  334. }
  335. // IsUserOrgOwner returns true if user is in the owner team of given organization.
  336. func (u *User) IsUserOrgOwner(orgId int64) bool {
  337. return IsOrganizationOwner(orgId, u.ID)
  338. }
  339. // IsPublicMember returns true if user public his/her membership in give organization.
  340. func (u *User) IsPublicMember(orgId int64) bool {
  341. return IsPublicMembership(orgId, u.ID)
  342. }
  343. // IsEnabledTwoFactor returns true if user has enabled two-factor authentication.
  344. func (u *User) IsEnabledTwoFactor() bool {
  345. return IsUserEnabledTwoFactor(u.ID)
  346. }
  347. func (u *User) getOrganizationCount(e Engine) (int64, error) {
  348. return e.Where("uid=?", u.ID).Count(new(OrgUser))
  349. }
  350. // GetOrganizationCount returns count of membership of organization of user.
  351. func (u *User) GetOrganizationCount() (int64, error) {
  352. return u.getOrganizationCount(x)
  353. }
  354. // GetRepositories returns repositories that user owns, including private repositories.
  355. func (u *User) GetRepositories(page, pageSize int) (err error) {
  356. u.Repos, err = GetUserRepositories(&UserRepoOptions{
  357. UserID: u.ID,
  358. Private: true,
  359. Page: page,
  360. PageSize: pageSize,
  361. })
  362. return err
  363. }
  364. // GetRepositories returns mirror repositories that user owns, including private repositories.
  365. func (u *User) GetMirrorRepositories() ([]*Repository, error) {
  366. return GetUserMirrorRepositories(u.ID)
  367. }
  368. // GetOwnedOrganizations returns all organizations that user owns.
  369. func (u *User) GetOwnedOrganizations() (err error) {
  370. u.OwnedOrgs, err = GetOwnedOrgsByUserID(u.ID)
  371. return err
  372. }
  373. // GetOrganizations returns all organizations that user belongs to.
  374. func (u *User) GetOrganizations(showPrivate bool) error {
  375. orgIDs, err := GetOrgIDsByUserID(u.ID, showPrivate)
  376. if err != nil {
  377. return fmt.Errorf("GetOrgIDsByUserID: %v", err)
  378. }
  379. if len(orgIDs) == 0 {
  380. return nil
  381. }
  382. u.Orgs = make([]*User, 0, len(orgIDs))
  383. if err = x.Where("type = ?", USER_TYPE_ORGANIZATION).In("id", orgIDs).Find(&u.Orgs); err != nil {
  384. return err
  385. }
  386. return nil
  387. }
  388. // DisplayName returns full name if it's not empty,
  389. // returns username otherwise.
  390. func (u *User) DisplayName() string {
  391. if len(u.FullName) > 0 {
  392. return u.FullName
  393. }
  394. return u.Name
  395. }
  396. func (u *User) ShortName(length int) string {
  397. return tool.EllipsisString(u.Name, length)
  398. }
  399. // IsMailable checks if a user is elegible
  400. // to receive emails.
  401. func (u *User) IsMailable() bool {
  402. return u.IsActive
  403. }
  404. // IsUserExist checks if given user name exist,
  405. // the user name should be noncased unique.
  406. // If uid is presented, then check will rule out that one,
  407. // it is used when update a user name in settings page.
  408. func IsUserExist(uid int64, name string) (bool, error) {
  409. if len(name) == 0 {
  410. return false, nil
  411. }
  412. return x.Where("id != ?", uid).Get(&User{LowerName: strings.ToLower(name)})
  413. }
  414. // GetUserSalt returns a ramdom user salt token.
  415. func GetUserSalt() (string, error) {
  416. return tool.RandomString(10)
  417. }
  418. // NewGhostUser creates and returns a fake user for someone who has deleted his/her account.
  419. func NewGhostUser() *User {
  420. return &User{
  421. ID: -1,
  422. Name: "Ghost",
  423. LowerName: "ghost",
  424. }
  425. }
  426. var (
  427. reservedUsernames = []string{"-", "explore", "create", "assets", "css", "img", "js", "less", "plugins", "debug", "raw", "install", "api", "avatar", "user", "org", "help", "stars", "issues", "pulls", "commits", "repo", "template", "admin", "new", ".", ".."}
  428. reservedUserPatterns = []string{"*.keys"}
  429. )
  430. // isUsableName checks if name is reserved or pattern of name is not allowed
  431. // based on given reserved names and patterns.
  432. // Names are exact match, patterns can be prefix or suffix match with placeholder '*'.
  433. func isUsableName(names, patterns []string, name string) error {
  434. name = strings.TrimSpace(strings.ToLower(name))
  435. if utf8.RuneCountInString(name) == 0 {
  436. return errors.EmptyName{}
  437. }
  438. for i := range names {
  439. if name == names[i] {
  440. return ErrNameReserved{name}
  441. }
  442. }
  443. for _, pat := range patterns {
  444. if pat[0] == '*' && strings.HasSuffix(name, pat[1:]) ||
  445. (pat[len(pat)-1] == '*' && strings.HasPrefix(name, pat[:len(pat)-1])) {
  446. return ErrNamePatternNotAllowed{pat}
  447. }
  448. }
  449. return nil
  450. }
  451. func IsUsableUsername(name string) error {
  452. return isUsableName(reservedUsernames, reservedUserPatterns, name)
  453. }
  454. // CreateUser creates record of a new user.
  455. func CreateUser(u *User) (err error) {
  456. if err = IsUsableUsername(u.Name); err != nil {
  457. return err
  458. }
  459. isExist, err := IsUserExist(0, u.Name)
  460. if err != nil {
  461. return err
  462. } else if isExist {
  463. return ErrUserAlreadyExist{u.Name}
  464. }
  465. u.Email = strings.ToLower(u.Email)
  466. isExist, err = IsEmailUsed(u.Email)
  467. if err != nil {
  468. return err
  469. } else if isExist {
  470. return ErrEmailAlreadyUsed{u.Email}
  471. }
  472. u.LowerName = strings.ToLower(u.Name)
  473. u.AvatarEmail = u.Email
  474. u.Avatar = tool.HashEmail(u.AvatarEmail)
  475. if u.Rands, err = GetUserSalt(); err != nil {
  476. return err
  477. }
  478. if u.Salt, err = GetUserSalt(); err != nil {
  479. return err
  480. }
  481. u.EncodePasswd()
  482. u.MaxRepoCreation = -1
  483. sess := x.NewSession()
  484. defer sess.Close()
  485. if err = sess.Begin(); err != nil {
  486. return err
  487. }
  488. if _, err = sess.Insert(u); err != nil {
  489. return err
  490. } else if err = os.MkdirAll(UserPath(u.Name), os.ModePerm); err != nil {
  491. return err
  492. }
  493. return sess.Commit()
  494. }
  495. func countUsers(e Engine) int64 {
  496. count, _ := e.Where("type=0").Count(new(User))
  497. return count
  498. }
  499. // CountUsers returns number of users.
  500. func CountUsers() int64 {
  501. return countUsers(x)
  502. }
  503. // Users returns number of users in given page.
  504. func Users(page, pageSize int) ([]*User, error) {
  505. users := make([]*User, 0, pageSize)
  506. return users, x.Limit(pageSize, (page-1)*pageSize).Where("type=0").Asc("id").Find(&users)
  507. }
  508. // parseUserFromCode returns user by username encoded in code.
  509. // It returns nil if code or username is invalid.
  510. func parseUserFromCode(code string) (user *User) {
  511. if len(code) <= tool.TIME_LIMIT_CODE_LENGTH {
  512. return nil
  513. }
  514. // Use tail hex username to query user
  515. hexStr := code[tool.TIME_LIMIT_CODE_LENGTH:]
  516. if b, err := hex.DecodeString(hexStr); err == nil {
  517. if user, err = GetUserByName(string(b)); user != nil {
  518. return user
  519. } else if !IsErrUserNotExist(err) {
  520. log.Error("Failed to get user by name %q: %v", string(b), err)
  521. }
  522. }
  523. return nil
  524. }
  525. // verify active code when active account
  526. func VerifyUserActiveCode(code string) (user *User) {
  527. minutes := conf.Auth.ActivateCodeLives
  528. if user = parseUserFromCode(code); user != nil {
  529. // time limit code
  530. prefix := code[:tool.TIME_LIMIT_CODE_LENGTH]
  531. data := com.ToStr(user.ID) + user.Email + user.LowerName + user.Passwd + user.Rands
  532. if tool.VerifyTimeLimitCode(data, minutes, prefix) {
  533. return user
  534. }
  535. }
  536. return nil
  537. }
  538. // verify active code when active account
  539. func VerifyActiveEmailCode(code, email string) *EmailAddress {
  540. minutes := conf.Auth.ActivateCodeLives
  541. if user := parseUserFromCode(code); user != nil {
  542. // time limit code
  543. prefix := code[:tool.TIME_LIMIT_CODE_LENGTH]
  544. data := com.ToStr(user.ID) + email + user.LowerName + user.Passwd + user.Rands
  545. if tool.VerifyTimeLimitCode(data, minutes, prefix) {
  546. emailAddress := &EmailAddress{Email: email}
  547. if has, _ := x.Get(emailAddress); has {
  548. return emailAddress
  549. }
  550. }
  551. }
  552. return nil
  553. }
  554. // ChangeUserName changes all corresponding setting from old user name to new one.
  555. func ChangeUserName(u *User, newUserName string) (err error) {
  556. if err = IsUsableUsername(newUserName); err != nil {
  557. return err
  558. }
  559. isExist, err := IsUserExist(0, newUserName)
  560. if err != nil {
  561. return err
  562. } else if isExist {
  563. return ErrUserAlreadyExist{newUserName}
  564. }
  565. if err = ChangeUsernameInPullRequests(u.Name, newUserName); err != nil {
  566. return fmt.Errorf("ChangeUsernameInPullRequests: %v", err)
  567. }
  568. // Delete all local copies of repositories and wikis the user owns.
  569. if err = x.Where("owner_id=?", u.ID).Iterate(new(Repository), func(idx int, bean interface{}) error {
  570. repo := bean.(*Repository)
  571. deleteRepoLocalCopy(repo)
  572. // TODO: By the same reasoning, shouldn't we also sync access to the local wiki path?
  573. RemoveAllWithNotice("Delete repository wiki local copy", repo.LocalWikiPath())
  574. return nil
  575. }); err != nil {
  576. return fmt.Errorf("delete repository and wiki local copy: %v", err)
  577. }
  578. // Rename or create user base directory
  579. baseDir := UserPath(u.Name)
  580. newBaseDir := UserPath(newUserName)
  581. if com.IsExist(baseDir) {
  582. return os.Rename(baseDir, newBaseDir)
  583. }
  584. return os.MkdirAll(newBaseDir, os.ModePerm)
  585. }
  586. func updateUser(e Engine, u *User) error {
  587. // Organization does not need email
  588. if !u.IsOrganization() {
  589. u.Email = strings.ToLower(u.Email)
  590. has, err := e.Where("id!=?", u.ID).And("type=?", u.Type).And("email=?", u.Email).Get(new(User))
  591. if err != nil {
  592. return err
  593. } else if has {
  594. return ErrEmailAlreadyUsed{u.Email}
  595. }
  596. if len(u.AvatarEmail) == 0 {
  597. u.AvatarEmail = u.Email
  598. }
  599. u.Avatar = tool.HashEmail(u.AvatarEmail)
  600. }
  601. u.LowerName = strings.ToLower(u.Name)
  602. u.Location = tool.TruncateString(u.Location, 255)
  603. u.Website = tool.TruncateString(u.Website, 255)
  604. u.Description = tool.TruncateString(u.Description, 255)
  605. _, err := e.ID(u.ID).AllCols().Update(u)
  606. return err
  607. }
  608. // UpdateUser updates user's information.
  609. func UpdateUser(u *User) error {
  610. return updateUser(x, u)
  611. }
  612. // deleteBeans deletes all given beans, beans should contain delete conditions.
  613. func deleteBeans(e Engine, beans ...interface{}) (err error) {
  614. for i := range beans {
  615. if _, err = e.Delete(beans[i]); err != nil {
  616. return err
  617. }
  618. }
  619. return nil
  620. }
  621. // FIXME: need some kind of mechanism to record failure. HINT: system notice
  622. func deleteUser(e *xorm.Session, u *User) error {
  623. // Note: A user owns any repository or belongs to any organization
  624. // cannot perform delete operation.
  625. // Check ownership of repository.
  626. count, err := getRepositoryCount(e, u)
  627. if err != nil {
  628. return fmt.Errorf("GetRepositoryCount: %v", err)
  629. } else if count > 0 {
  630. return ErrUserOwnRepos{UID: u.ID}
  631. }
  632. // Check membership of organization.
  633. count, err = u.getOrganizationCount(e)
  634. if err != nil {
  635. return fmt.Errorf("GetOrganizationCount: %v", err)
  636. } else if count > 0 {
  637. return ErrUserHasOrgs{UID: u.ID}
  638. }
  639. // ***** START: Watch *****
  640. watches := make([]*Watch, 0, 10)
  641. if err = e.Find(&watches, &Watch{UserID: u.ID}); err != nil {
  642. return fmt.Errorf("get all watches: %v", err)
  643. }
  644. for i := range watches {
  645. if _, err = e.Exec("UPDATE `repository` SET num_watches=num_watches-1 WHERE id=?", watches[i].RepoID); err != nil {
  646. return fmt.Errorf("decrease repository watch number[%d]: %v", watches[i].RepoID, err)
  647. }
  648. }
  649. // ***** END: Watch *****
  650. // ***** START: Star *****
  651. stars := make([]*Star, 0, 10)
  652. if err = e.Find(&stars, &Star{UID: u.ID}); err != nil {
  653. return fmt.Errorf("get all stars: %v", err)
  654. }
  655. for i := range stars {
  656. if _, err = e.Exec("UPDATE `repository` SET num_stars=num_stars-1 WHERE id=?", stars[i].RepoID); err != nil {
  657. return fmt.Errorf("decrease repository star number[%d]: %v", stars[i].RepoID, err)
  658. }
  659. }
  660. // ***** END: Star *****
  661. // ***** START: Follow *****
  662. followers := make([]*Follow, 0, 10)
  663. if err = e.Find(&followers, &Follow{UserID: u.ID}); err != nil {
  664. return fmt.Errorf("get all followers: %v", err)
  665. }
  666. for i := range followers {
  667. if _, err = e.Exec("UPDATE `user` SET num_followers=num_followers-1 WHERE id=?", followers[i].UserID); err != nil {
  668. return fmt.Errorf("decrease user follower number[%d]: %v", followers[i].UserID, err)
  669. }
  670. }
  671. // ***** END: Follow *****
  672. if err = deleteBeans(e,
  673. &AccessToken{UID: u.ID},
  674. &Collaboration{UserID: u.ID},
  675. &Access{UserID: u.ID},
  676. &Watch{UserID: u.ID},
  677. &Star{UID: u.ID},
  678. &Follow{FollowID: u.ID},
  679. &Action{UserID: u.ID},
  680. &IssueUser{UID: u.ID},
  681. &EmailAddress{UID: u.ID},
  682. ); err != nil {
  683. return fmt.Errorf("deleteBeans: %v", err)
  684. }
  685. // ***** START: PublicKey *****
  686. keys := make([]*PublicKey, 0, 10)
  687. if err = e.Find(&keys, &PublicKey{OwnerID: u.ID}); err != nil {
  688. return fmt.Errorf("get all public keys: %v", err)
  689. }
  690. keyIDs := make([]int64, len(keys))
  691. for i := range keys {
  692. keyIDs[i] = keys[i].ID
  693. }
  694. if err = deletePublicKeys(e, keyIDs...); err != nil {
  695. return fmt.Errorf("deletePublicKeys: %v", err)
  696. }
  697. // ***** END: PublicKey *****
  698. // Clear assignee.
  699. if _, err = e.Exec("UPDATE `issue` SET assignee_id=0 WHERE assignee_id=?", u.ID); err != nil {
  700. return fmt.Errorf("clear assignee: %v", err)
  701. }
  702. if _, err = e.Id(u.ID).Delete(new(User)); err != nil {
  703. return fmt.Errorf("Delete: %v", err)
  704. }
  705. // FIXME: system notice
  706. // Note: There are something just cannot be roll back,
  707. // so just keep error logs of those operations.
  708. os.RemoveAll(UserPath(u.Name))
  709. os.Remove(u.CustomAvatarPath())
  710. return nil
  711. }
  712. // DeleteUser completely and permanently deletes everything of a user,
  713. // but issues/comments/pulls will be kept and shown as someone has been deleted.
  714. func DeleteUser(u *User) (err error) {
  715. sess := x.NewSession()
  716. defer sess.Close()
  717. if err = sess.Begin(); err != nil {
  718. return err
  719. }
  720. if err = deleteUser(sess, u); err != nil {
  721. // Note: don't wrapper error here.
  722. return err
  723. }
  724. if err = sess.Commit(); err != nil {
  725. return err
  726. }
  727. return RewriteAuthorizedKeys()
  728. }
  729. // DeleteInactivateUsers deletes all inactivate users and email addresses.
  730. func DeleteInactivateUsers() (err error) {
  731. users := make([]*User, 0, 10)
  732. if err = x.Where("is_active = ?", false).Find(&users); err != nil {
  733. return fmt.Errorf("get all inactive users: %v", err)
  734. }
  735. // FIXME: should only update authorized_keys file once after all deletions.
  736. for _, u := range users {
  737. if err = DeleteUser(u); err != nil {
  738. // Ignore users that were set inactive by admin.
  739. if IsErrUserOwnRepos(err) || IsErrUserHasOrgs(err) {
  740. continue
  741. }
  742. return err
  743. }
  744. }
  745. _, err = x.Where("is_activated = ?", false).Delete(new(EmailAddress))
  746. return err
  747. }
  748. // UserPath returns the path absolute path of user repositories.
  749. func UserPath(userName string) string {
  750. return filepath.Join(conf.Repository.Root, strings.ToLower(userName))
  751. }
  752. func GetUserByKeyID(keyID int64) (*User, error) {
  753. user := new(User)
  754. has, err := x.SQL("SELECT a.* FROM `user` AS a, public_key AS b WHERE a.id = b.owner_id AND b.id=?", keyID).Get(user)
  755. if err != nil {
  756. return nil, err
  757. } else if !has {
  758. return nil, errors.UserNotKeyOwner{KeyID: keyID}
  759. }
  760. return user, nil
  761. }
  762. var _ errutil.NotFound = (*ErrUserNotExist)(nil)
  763. type ErrUserNotExist struct {
  764. args map[string]interface{}
  765. }
  766. func IsErrUserNotExist(err error) bool {
  767. _, ok := err.(ErrUserNotExist)
  768. return ok
  769. }
  770. func (err ErrUserNotExist) Error() string {
  771. return fmt.Sprintf("user does not exist: %v", err.args)
  772. }
  773. func (ErrUserNotExist) NotFound() bool {
  774. return true
  775. }
  776. func getUserByID(e Engine, id int64) (*User, error) {
  777. u := new(User)
  778. has, err := e.ID(id).Get(u)
  779. if err != nil {
  780. return nil, err
  781. } else if !has {
  782. return nil, ErrUserNotExist{args: map[string]interface{}{"userID": id}}
  783. }
  784. return u, nil
  785. }
  786. // GetUserByID returns the user object by given ID if exists.
  787. func GetUserByID(id int64) (*User, error) {
  788. return getUserByID(x, id)
  789. }
  790. // GetAssigneeByID returns the user with write access of repository by given ID.
  791. func GetAssigneeByID(repo *Repository, userID int64) (*User, error) {
  792. has, err := HasAccess(userID, repo, ACCESS_MODE_READ)
  793. if err != nil {
  794. return nil, err
  795. } else if !has {
  796. return nil, ErrUserNotExist{args: map[string]interface{}{"userID": userID}}
  797. }
  798. return GetUserByID(userID)
  799. }
  800. // GetUserByName returns a user by given name.
  801. func GetUserByName(name string) (*User, error) {
  802. if len(name) == 0 {
  803. return nil, ErrUserNotExist{args: map[string]interface{}{"name": name}}
  804. }
  805. u := &User{LowerName: strings.ToLower(name)}
  806. has, err := x.Get(u)
  807. if err != nil {
  808. return nil, err
  809. } else if !has {
  810. return nil, ErrUserNotExist{args: map[string]interface{}{"name": name}}
  811. }
  812. return u, nil
  813. }
  814. // GetUserEmailsByNames returns a list of e-mails corresponds to names.
  815. func GetUserEmailsByNames(names []string) []string {
  816. mails := make([]string, 0, len(names))
  817. for _, name := range names {
  818. u, err := GetUserByName(name)
  819. if err != nil {
  820. continue
  821. }
  822. if u.IsMailable() {
  823. mails = append(mails, u.Email)
  824. }
  825. }
  826. return mails
  827. }
  828. // GetUserIDsByNames returns a slice of ids corresponds to names.
  829. func GetUserIDsByNames(names []string) []int64 {
  830. ids := make([]int64, 0, len(names))
  831. for _, name := range names {
  832. u, err := GetUserByName(name)
  833. if err != nil {
  834. continue
  835. }
  836. ids = append(ids, u.ID)
  837. }
  838. return ids
  839. }
  840. // UserCommit represents a commit with validation of user.
  841. type UserCommit struct {
  842. User *User
  843. *git.Commit
  844. }
  845. // ValidateCommitWithEmail chceck if author's e-mail of commit is corresponsind to a user.
  846. func ValidateCommitWithEmail(c *git.Commit) *User {
  847. u, err := GetUserByEmail(c.Author.Email)
  848. if err != nil {
  849. return nil
  850. }
  851. return u
  852. }
  853. // ValidateCommitsWithEmails checks if authors' e-mails of commits are corresponding to users.
  854. func ValidateCommitsWithEmails(oldCommits []*git.Commit) []*UserCommit {
  855. emails := make(map[string]*User)
  856. newCommits := make([]*UserCommit, len(oldCommits))
  857. for i := range oldCommits {
  858. var u *User
  859. if v, ok := emails[oldCommits[i].Author.Email]; !ok {
  860. u, _ = GetUserByEmail(oldCommits[i].Author.Email)
  861. emails[oldCommits[i].Author.Email] = u
  862. } else {
  863. u = v
  864. }
  865. newCommits[i] = &UserCommit{
  866. User: u,
  867. Commit: oldCommits[i],
  868. }
  869. }
  870. return newCommits
  871. }
  872. // GetUserByEmail returns the user object by given e-mail if exists.
  873. func GetUserByEmail(email string) (*User, error) {
  874. if len(email) == 0 {
  875. return nil, ErrUserNotExist{args: map[string]interface{}{"email": email}}
  876. }
  877. email = strings.ToLower(email)
  878. // First try to find the user by primary email
  879. user := &User{Email: email}
  880. has, err := x.Get(user)
  881. if err != nil {
  882. return nil, err
  883. }
  884. if has {
  885. return user, nil
  886. }
  887. // Otherwise, check in alternative list for activated email addresses
  888. emailAddress := &EmailAddress{Email: email, IsActivated: true}
  889. has, err = x.Get(emailAddress)
  890. if err != nil {
  891. return nil, err
  892. }
  893. if has {
  894. return GetUserByID(emailAddress.UID)
  895. }
  896. return nil, ErrUserNotExist{args: map[string]interface{}{"email": email}}
  897. }
  898. type SearchUserOptions struct {
  899. Keyword string
  900. Type UserType
  901. OrderBy string
  902. Page int
  903. PageSize int // Can be smaller than or equal to setting.UI.ExplorePagingNum
  904. }
  905. // SearchUserByName takes keyword and part of user name to search,
  906. // it returns results in given range and number of total results.
  907. func SearchUserByName(opts *SearchUserOptions) (users []*User, _ int64, _ error) {
  908. if len(opts.Keyword) == 0 {
  909. return users, 0, nil
  910. }
  911. opts.Keyword = strings.ToLower(opts.Keyword)
  912. if opts.PageSize <= 0 || opts.PageSize > conf.UI.ExplorePagingNum {
  913. opts.PageSize = conf.UI.ExplorePagingNum
  914. }
  915. if opts.Page <= 0 {
  916. opts.Page = 1
  917. }
  918. searchQuery := "%" + opts.Keyword + "%"
  919. users = make([]*User, 0, opts.PageSize)
  920. // Append conditions
  921. sess := x.Where("LOWER(lower_name) LIKE ?", searchQuery).
  922. Or("LOWER(full_name) LIKE ?", searchQuery).
  923. And("type = ?", opts.Type)
  924. var countSess xorm.Session
  925. countSess = *sess
  926. count, err := countSess.Count(new(User))
  927. if err != nil {
  928. return nil, 0, fmt.Errorf("Count: %v", err)
  929. }
  930. if len(opts.OrderBy) > 0 {
  931. sess.OrderBy(opts.OrderBy)
  932. }
  933. return users, count, sess.Limit(opts.PageSize, (opts.Page-1)*opts.PageSize).Find(&users)
  934. }
  935. // ___________ .__ .__
  936. // \_ _____/___ | | | | ______ _ __
  937. // | __)/ _ \| | | | / _ \ \/ \/ /
  938. // | \( <_> ) |_| |_( <_> ) /
  939. // \___ / \____/|____/____/\____/ \/\_/
  940. // \/
  941. // Follow represents relations of user and his/her followers.
  942. type Follow struct {
  943. ID int64
  944. UserID int64 `xorm:"UNIQUE(follow)"`
  945. FollowID int64 `xorm:"UNIQUE(follow)"`
  946. }
  947. func IsFollowing(userID, followID int64) bool {
  948. has, _ := x.Get(&Follow{UserID: userID, FollowID: followID})
  949. return has
  950. }
  951. // FollowUser marks someone be another's follower.
  952. func FollowUser(userID, followID int64) (err error) {
  953. if userID == followID || IsFollowing(userID, followID) {
  954. return nil
  955. }
  956. sess := x.NewSession()
  957. defer sess.Close()
  958. if err = sess.Begin(); err != nil {
  959. return err
  960. }
  961. if _, err = sess.Insert(&Follow{UserID: userID, FollowID: followID}); err != nil {
  962. return err
  963. }
  964. if _, err = sess.Exec("UPDATE `user` SET num_followers = num_followers + 1 WHERE id = ?", followID); err != nil {
  965. return err
  966. }
  967. if _, err = sess.Exec("UPDATE `user` SET num_following = num_following + 1 WHERE id = ?", userID); err != nil {
  968. return err
  969. }
  970. return sess.Commit()
  971. }
  972. // UnfollowUser unmarks someone be another's follower.
  973. func UnfollowUser(userID, followID int64) (err error) {
  974. if userID == followID || !IsFollowing(userID, followID) {
  975. return nil
  976. }
  977. sess := x.NewSession()
  978. defer sess.Close()
  979. if err = sess.Begin(); err != nil {
  980. return err
  981. }
  982. if _, err = sess.Delete(&Follow{UserID: userID, FollowID: followID}); err != nil {
  983. return err
  984. }
  985. if _, err = sess.Exec("UPDATE `user` SET num_followers = num_followers - 1 WHERE id = ?", followID); err != nil {
  986. return err
  987. }
  988. if _, err = sess.Exec("UPDATE `user` SET num_following = num_following - 1 WHERE id = ?", userID); err != nil {
  989. return err
  990. }
  991. return sess.Commit()
  992. }