diff options
author | Jebbs <qjebbs@gmail.com> | 2019-02-12 14:20:07 +0800 |
---|---|---|
committer | fguillot <fred@miniflux.net> | 2019-02-11 22:20:07 -0800 |
commit | 267b7065444b2904e1172817c661709e0b456b80 (patch) | |
tree | 1880cef296793738bf862ffd32690815b1b31dd8 /database | |
parent | ed6ae7e0d277c53ac77b5f17327355ca76275556 (diff) |
Sort search results by relevance
Diffstat (limited to 'database')
-rw-r--r-- | database/migration.go | 2 | ||||
-rw-r--r-- | database/sql.go | 2 | ||||
-rw-r--r-- | database/sql/schema_version_22.sql | 1 |
3 files changed, 4 insertions, 1 deletions
diff --git a/database/migration.go b/database/migration.go index 39d15b7..7e37dc6 100644 --- a/database/migration.go +++ b/database/migration.go @@ -12,7 +12,7 @@ import ( "miniflux.app/logger" ) -const schemaVersion = 21 +const schemaVersion = 22 // Migrate executes database migrations. func Migrate(db *sql.DB) { diff --git a/database/sql.go b/database/sql.go index 817feba..d4002c8 100644 --- a/database/sql.go +++ b/database/sql.go @@ -145,6 +145,7 @@ create index users_extra_idx on users using gin(extra); update entries set document_vectors = to_tsvector(substring(title || ' ' || coalesce(content, '') for 1000000)); create index document_vectors_idx on entries using gin(document_vectors);`, "schema_version_21": `alter table feeds add column user_agent text default '';`, + "schema_version_22": `update entries set document_vectors = setweight(to_tsvector(substring(coalesce(title, '') for 1000000)), 'A') || setweight(to_tsvector(substring(coalesce(content, '') for 1000000)), 'B');`, "schema_version_3": `create table tokens ( id text not null, value text not null, @@ -194,6 +195,7 @@ var SqlMapChecksums = map[string]string{ "schema_version_2": "e8e9ff32478df04fcddad10a34cba2e8bb1e67e7977b5bd6cdc4c31ec94282b4", "schema_version_20": "5d414c0cfc0da2863c641079afa58b7ff42dccb0f0e01c822ad435c3e3aa9201", "schema_version_21": "77da01ee38918ff4fe33985fbb20ed3276a717a7584c2ca9ebcf4d4ab6cb6910", + "schema_version_22": "51ed5fbcae9877e57274511f0ef8c61d254ebd78dfbcbc043a2acd30f4c93ca3", "schema_version_3": "a54745dbc1c51c000f74d4e5068f1e2f43e83309f023415b1749a47d5c1e0f12", "schema_version_4": "216ea3a7d3e1704e40c797b5dc47456517c27dbb6ca98bf88812f4f63d74b5d9", "schema_version_5": "46397e2f5f2c82116786127e9f6a403e975b14d2ca7b652a48cd1ba843e6a27c", diff --git a/database/sql/schema_version_22.sql b/database/sql/schema_version_22.sql new file mode 100644 index 0000000..1b51e8a --- /dev/null +++ b/database/sql/schema_version_22.sql @@ -0,0 +1 @@ +update entries set document_vectors = setweight(to_tsvector(substring(coalesce(title, '') for 1000000)), 'A') || setweight(to_tsvector(substring(coalesce(content, '') for 1000000)), 'B');
\ No newline at end of file |