diff options
| author | Christopher Speller <crspeller@gmail.com> | 2018-09-10 06:20:01 -0700 |
|---|---|---|
| committer | Carlos Tadeu Panato Junior <ctadeu@gmail.com> | 2018-09-10 15:20:01 +0200 |
| commit | a8d116b381ec9c28c5da5c8ee39a3699f568130d (patch) | |
| tree | deac1ed66cbd21dd08f865e36feba230b433b2fd /store | |
| parent | bb605a6b91073714f6b9a59b86c25c1b46bd2ba9 (diff) | |
| download | chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.tar.gz chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.tar.bz2 chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.zip | |
Speed up search results post selection. (#9380)
Diffstat (limited to 'store')
| -rw-r--r-- | store/sqlstore/post_store.go | 2 | ||||
| -rw-r--r-- | store/storetest/post_store.go | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/store/sqlstore/post_store.go b/store/sqlstore/post_store.go index 14a6039bc..9cf33888d 100644 --- a/store/sqlstore/post_store.go +++ b/store/sqlstore/post_store.go @@ -1156,7 +1156,7 @@ func (s *SqlPostStore) GetPostsByIds(postIds []string) store.StoreChannel { params[key] = postId } - query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) and DeleteAt = 0 ORDER BY CreateAt DESC` + query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) ORDER BY CreateAt DESC` var posts []*model.Post _, err := s.GetReplica().Select(&posts, query, params) diff --git a/store/storetest/post_store.go b/store/storetest/post_store.go index b3a7e8d12..235d6f9b7 100644 --- a/store/storetest/post_store.go +++ b/store/storetest/post_store.go @@ -1674,8 +1674,8 @@ func testPostStoreGetPostsByIds(t *testing.T, ss store.Store) { store.Must(ss.Post().Delete(ro1.Id, model.GetMillis(), "")) - if ro5 := store.Must(ss.Post().GetPostsByIds(postIds)).([]*model.Post); len(ro5) != 2 { - t.Fatalf("Expected 2 posts in results. Got %v", len(ro5)) + if ro5 := store.Must(ss.Post().GetPostsByIds(postIds)).([]*model.Post); len(ro5) != 3 { + t.Fatalf("Expected 3 posts in results. Got %v", len(ro5)) } } |