summaryrefslogtreecommitdiff
path: root/internal/db/pg/pg.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/pg/pg.go')
-rw-r--r--internal/db/pg/pg.go15
1 files changed, 15 insertions, 0 deletions
diff --git a/internal/db/pg/pg.go b/internal/db/pg/pg.go
index 30b073bcc..01dc71434 100644
--- a/internal/db/pg/pg.go
+++ b/internal/db/pg/pg.go
@@ -500,6 +500,13 @@ func (ps *postgresService) GetStatusesByTimeDescending(accountID string, statuse
return q.Where("? IS NOT NULL", pg.Ident("attachments")).Where("attachments != '{}'"), nil
})
}
+ if maxID != "" {
+ s := &gtsmodel.Status{}
+ if err := ps.conn.Model(s).Where("id = ?", maxID).Select(); err != nil {
+ return err
+ }
+ q = q.Where("status.created_at < ?", s.CreatedAt)
+ }
if err := q.Select(); err != nil {
if err == pg.ErrNoRows {
return db.ErrNoEntries{}
@@ -1113,6 +1120,14 @@ func (ps *postgresService) GetHomeTimelineForAccount(accountID string, maxID str
Limit(limit).
Order("status.created_at DESC")
+ if maxID != "" {
+ s := &gtsmodel.Status{}
+ if err := ps.conn.Model(s).Where("id = ?", maxID).Select(); err != nil {
+ return nil, err
+ }
+ q = q.Where("status.created_at < ?", s.CreatedAt)
+ }
+
err := q.Select()
if err != nil {
if err != pg.ErrNoRows {