aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMax Magorsch <arzano@gentoo.org>2020-06-23 15:47:11 +0200
committerMax Magorsch <arzano@gentoo.org>2020-06-23 15:47:11 +0200
commite82baa3d0262e8c01658935453aee6a2d96d8311 (patch)
treefc6e81d2daee11b35c41587ffa0a571e27039b96 /pkg/app/list/messages.go
parentClean up the code (diff)
downloadarchives-e82baa3d0262e8c01658935453aee6a2d96d8311.tar.gz
archives-e82baa3d0262e8c01658935453aee6a2d96d8311.tar.bz2
archives-e82baa3d0262e8c01658935453aee6a2d96d8311.zip
Speed up loading the messages for a list
Signed-off-by: Max Magorsch <arzano@gentoo.org>
Diffstat (limited to 'pkg/app/list/messages.go')
-rw-r--r--pkg/app/list/messages.go14
1 files changed, 1 insertions, 13 deletions
diff --git a/pkg/app/list/messages.go b/pkg/app/list/messages.go
index 7a78811..a9564a8 100644
--- a/pkg/app/list/messages.go
+++ b/pkg/app/list/messages.go
@@ -3,7 +3,6 @@ package list
import (
"archives/pkg/database"
"archives/pkg/models"
- "github.com/go-pg/pg/v10/orm"
"math"
"net/http"
"strconv"
@@ -35,18 +34,7 @@ func Messages(w http.ResponseWriter, r *http.Request) {
query := database.DBCon.Model(&messages).
Column("id", "subject", "from", "date").
Where("to_char(date, 'YYYY-MM') = ?", combinedDate).
- WhereGroup(func(q *orm.Query) (*orm.Query, error) {
- q = q.WhereOr(`subject LIKE '[` + listName + `]%'`).
- WhereOr(`subject LIKE 'Re: [` + listName + `]%'`)
- return q, nil
- }).
- //WhereGroup(func(q *orm.Query) (*orm.Query, error) {
- // q = q.WhereOr(`headers::jsonb->>'To' LIKE '%` + listName + `@lists.gentoo.org%'`).
- // WhereOr(`headers::jsonb->>'Cc' LIKE '%` + listName + `@lists.gentoo.org%'`).
- // WhereOr(`headers::jsonb->>'To' LIKE '%` + listName + `@gentoo.org%'`).
- // WhereOr(`headers::jsonb->>'Cc' LIKE '%` + listName + `@gentoo.org%'`)
- // return q, nil
- //}).
+ Where("list = ?", listName).
Order("date DESC")
messagesCount, _ := query.Count()