diff options
| author |  tobi <31960611+tsmethurst@users.noreply.github.com> | 2024-01-16 18:50:17 +0100 |
|---|---|---|
| committer |  GitHub <noreply@github.com> | 2024-01-16 18:50:17 +0100 |
| commit | c5eced5fd195a07ca23893e086f2f940788630b1 (patch) | |
| tree | b7d015ec84aba1fd08c097515f2400cc3a4e842c /internal/db/bundb/search_test.go | |
| parent | [feature] Move + alias account via settings panel (#2519) (diff) | |
| download | gotosocial-c5eced5fd195a07ca23893e086f2f940788630b1.tar.xz | |
[bugfix] Better Postgres search case insensitivity (#2526)
* [bugfix] Better Postgres search case insensitivity
* use ilike for postgres
Diffstat (limited to 'internal/db/bundb/search_test.go')
| -rw-r--r-- | internal/db/bundb/search_test.go | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/internal/db/bundb/search_test.go b/internal/db/bundb/search_test.go index bc791271e..75a2d8c8e 100644 --- a/internal/db/bundb/search_test.go +++ b/internal/db/bundb/search_test.go @@ -46,6 +46,15 @@ func (suite *SearchTestSuite) TestSearchAccounts1HappyWithPrefix() { suite.Len(accounts, 1) } +func (suite *SearchTestSuite) TestSearchAccounts1HappyWithPrefixUpper() { + testAccount := suite.testAccounts["local_account_1"] + + // Query will just look for usernames that start with "1HAPPY". + accounts, err := suite.db.SearchForAccounts(context.Background(), testAccount.ID, "@1HAPPY", "", "", 10, false, 0) + suite.NoError(err) + suite.Len(accounts, 1) +} + func (suite *SearchTestSuite) TestSearchAccounts1HappyNoPrefix() { testAccount := suite.testAccounts["local_account_1"] @@ -63,6 +72,14 @@ func (suite *SearchTestSuite) TestSearchAccountsTurtleFollowing() { suite.Len(accounts, 1) } +func (suite *SearchTestSuite) TestSearchAccountsTurtleFollowingUpper() { + testAccount := suite.testAccounts["local_account_1"] + + accounts, err := suite.db.SearchForAccounts(context.Background(), testAccount.ID, "TURTLE", "", "", 10, true, 0) + suite.NoError(err) + suite.Len(accounts, 1) +} + func (suite *SearchTestSuite) TestSearchAccountsPostFollowing() { testAccount := suite.testAccounts["local_account_1"] |