diff options
| author | M Somerville <matthew-github@dracos.co.uk> | 2020-08-05 15:56:10 +0100 |
|---|---|---|
| committer | M Somerville <matthew-github@dracos.co.uk> | 2020-08-06 20:28:57 +0100 |
| commit | 7af4f2cc87cd6ff55501bb2856193a03fe72158c (patch) | |
| tree | e2c1f396bb4a34220379b94d9e25d4671f29b052 /perllib/FixMyStreet/DB/ResultSet/User.pm | |
| parent | 21efead606530cb754bb7b54586dbb8c1a1502ca (diff) | |
Add database index for user full text search.
Diffstat (limited to 'perllib/FixMyStreet/DB/ResultSet/User.pm')
| -rw-r--r-- | perllib/FixMyStreet/DB/ResultSet/User.pm | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/perllib/FixMyStreet/DB/ResultSet/User.pm b/perllib/FixMyStreet/DB/ResultSet/User.pm index 9a8a50559..baae024bf 100644 --- a/perllib/FixMyStreet/DB/ResultSet/User.pm +++ b/perllib/FixMyStreet/DB/ResultSet/User.pm @@ -5,6 +5,11 @@ use strict; use warnings; use Moo; +with 'FixMyStreet::Roles::FullTextSearch'; +__PACKAGE__->load_components('Helper::ResultSet::Me'); +sub text_search_columns { qw(id name email phone) } +sub text_search_nulls { qw(name email phone) } +sub text_search_translate { '@.' } # The database has a partial unique index on email (when email_verified is # true), and phone (when phone_verified is true). In the code, we can only |