diff options
author | Adrian Carolli <adrian.caarolli@gmail.com> | 2018-01-11 16:30:55 -0500 |
---|---|---|
committer | Joram Wilander <jwawilander@gmail.com> | 2018-01-11 16:30:55 -0500 |
commit | b1d13a2d897147de8290a03e624efe4000dc9aa7 (patch) | |
tree | a75464c6eb48b753c96d7210254ff6985c7e4a4c /store/sqlstore/user_access_token_store.go | |
parent | 1d9efd0e39a9663bb2fbf52b3353fe21ac3b6954 (diff) | |
download | chat-b1d13a2d897147de8290a03e624efe4000dc9aa7.tar.gz chat-b1d13a2d897147de8290a03e624efe4000dc9aa7.tar.bz2 chat-b1d13a2d897147de8290a03e624efe4000dc9aa7.zip |
[PLT-7793] Add /users/tokens/search endpoint (#8088)
* Add /users/tokens/search endpoint + tests
* Fix check-style
* Unnecessary deletion
Diffstat (limited to 'store/sqlstore/user_access_token_store.go')
-rw-r--r-- | store/sqlstore/user_access_token_store.go | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/store/sqlstore/user_access_token_store.go b/store/sqlstore/user_access_token_store.go index deba9f7ea..b90ba773f 100644 --- a/store/sqlstore/user_access_token_store.go +++ b/store/sqlstore/user_access_token_store.go @@ -211,6 +211,26 @@ func (s SqlUserAccessTokenStore) GetByUser(userId string, offset, limit int) sto }) } +func (s SqlUserAccessTokenStore) Search(term string) store.StoreChannel { + return store.Do(func(result *store.StoreResult) { + tokens := []*model.UserAccessToken{} + params := map[string]interface{}{"Term": term + "%"} + query := ` + SELECT + uat.* + FROM UserAccessTokens uat + INNER JOIN Users u + ON uat.UserId = u.Id + WHERE uat.Id LIKE :Term OR uat.UserId LIKE :Term OR u.Username LIKE :Term` + + if _, err := s.GetReplica().Select(&tokens, query, params); err != nil { + result.Err = model.NewAppError("SqlUserAccessTokenStore.Search", "store.sql_user_access_token.search.app_error", nil, "term="+term+", "+err.Error(), http.StatusInternalServerError) + } + + result.Data = tokens + }) +} + func (s SqlUserAccessTokenStore) UpdateTokenEnable(tokenId string) store.StoreChannel { return store.Do(func(result *store.StoreResult) { if _, err := s.GetMaster().Exec("UPDATE UserAccessTokens SET IsActive = TRUE WHERE Id = :Id", map[string]interface{}{"Id": tokenId}); err != nil { |