~sircmpwn/godocs.io

This thread contains a patchset. You're looking at the original emails, but you may wish to use the patch review UI. Review patch
1

[PATCH gddo] internal/database: Fix search SQL query

Details
Message ID
<20210501175315.19689-1-me@adnano.co>
DKIM signature
pass
Download raw message
Patch: +1 -1
---
Order scores in descending order, not ascending.

 internal/database/database.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/internal/database/database.go b/internal/database/database.go
index 5fd8d18..57deab1 100644
--- a/internal/database/database.go
+++ b/internal/database/database.go
@@ -133,7 +133,7 @@ func (db *Database) Search(ctx context.Context, q string) ([]Package, error) {
				AND m.module_path = p.module_path AND p.version = m.latest_version
				AND i.import_path = p.import_path
			ORDER BY ts_rank(p.searchtext, to_tsquery('english', $1)) DESC,
				p.score ASC
				p.score DESC
			LIMIT 20;
			`, q)
		if err != nil {
-- 
2.31.1
Details
Message ID
<CB24FP2490EU.2WP47HA79VOEK@taiga>
In-Reply-To
<20210501175315.19689-1-me@adnano.co> (view parent)
DKIM signature
fail
Download raw message
DKIM signature: fail
Thanks!

To git@git.sr.ht:~sircmpwn/gddo
   2904362..dfc2f02  master -> master
Reply to thread Export thread (mbox)