tree 88d6e48a2b5b19613930ba230108dbd670c350b1
parent 7624e4766ea785e034eef99e45d5df11778722d0
author Julie Qiu <julie@golang.org> 1631026141 -0400
committer Julie Qiu <julie@golang.org> 1631027863 +0000

migrations: add column search_documents.ln_imported_by_count

Column search_documents.ln_imported_by_count is added, since both symbol
and package search use that value for computing scores.

At the moment, symbol search uses
symbol_search_documents.ln_imported_by_count (which can be dropped after
this column is populated), and package search computes the value for
each result during search. Instead, this column can be used.

trigger_modify_ln_imported_by_count is used to set the value of
ln_imported_by_count every time imported_by_count is upserted.

For golang/go#44142

Change-Id: Icce55811e0c5fce5e5607787aaf11cb3bf65b818
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/347989
Trust: Julie Qiu <julie@golang.org>
Run-TryBot: Julie Qiu <julie@golang.org>
Reviewed-by: Jamal Carvalho <jamal@golang.org>
TryBot-Result: kokoro <noreply+kokoro@google.com>