aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2019-11-29 11:16:43 +0100
committerChocobozzz <me@florianbigard.com>2019-11-29 11:16:43 +0100
commitcb5ce4cb13095dbea6e5f05b96eaa42ffccf0716 (patch)
treefbfcb2b23b78a7dc464df22c166bee34b5b8bcb0 /server/models
parent97ecddae104f4013d261f0e9645e8b319ff0f1a6 (diff)
downloadPeerTube-cb5ce4cb13095dbea6e5f05b96eaa42ffccf0716.tar.gz
PeerTube-cb5ce4cb13095dbea6e5f05b96eaa42ffccf0716.tar.zst
PeerTube-cb5ce4cb13095dbea6e5f05b96eaa42ffccf0716.zip
Add more filters to admin follows table
Diffstat (limited to 'server/models')
-rw-r--r--server/models/activitypub/actor-follow.ts6
-rw-r--r--server/models/utils.ts14
2 files changed, 17 insertions, 3 deletions
diff --git a/server/models/activitypub/actor-follow.ts b/server/models/activitypub/actor-follow.ts
index c3c4d61ab..c65b975d2 100644
--- a/server/models/activitypub/actor-follow.ts
+++ b/server/models/activitypub/actor-follow.ts
@@ -23,7 +23,7 @@ import { logger } from '../../helpers/logger'
23import { getServerActor } from '../../helpers/utils' 23import { getServerActor } from '../../helpers/utils'
24import { ACTOR_FOLLOW_SCORE, FOLLOW_STATES, SERVER_ACTOR_NAME } from '../../initializers/constants' 24import { ACTOR_FOLLOW_SCORE, FOLLOW_STATES, SERVER_ACTOR_NAME } from '../../initializers/constants'
25import { ServerModel } from '../server/server' 25import { ServerModel } from '../server/server'
26import { createSafeIn, getSort } from '../utils' 26import { createSafeIn, getSort, getFollowsSort } from '../utils'
27import { ActorModel, unusedActorAttributesForAPI } from './actor' 27import { ActorModel, unusedActorAttributesForAPI } from './actor'
28import { VideoChannelModel } from '../video/video-channel' 28import { VideoChannelModel } from '../video/video-channel'
29import { AccountModel } from '../account/account' 29import { AccountModel } from '../account/account'
@@ -324,7 +324,7 @@ export class ActorFollowModel extends Model<ActorFollowModel> {
324 distinct: true, 324 distinct: true,
325 offset: start, 325 offset: start,
326 limit: count, 326 limit: count,
327 order: getSort(sort), 327 order: getFollowsSort(sort),
328 where: followWhere, 328 where: followWhere,
329 include: [ 329 include: [
330 { 330 {
@@ -391,7 +391,7 @@ export class ActorFollowModel extends Model<ActorFollowModel> {
391 distinct: true, 391 distinct: true,
392 offset: start, 392 offset: start,
393 limit: count, 393 limit: count,
394 order: getSort(sort), 394 order: getFollowsSort(sort),
395 where: followWhere, 395 where: followWhere,
396 include: [ 396 include: [
397 { 397 {
diff --git a/server/models/utils.ts b/server/models/utils.ts
index ccdbcd1cf..b53a52a05 100644
--- a/server/models/utils.ts
+++ b/server/models/utils.ts
@@ -58,6 +58,19 @@ function getBlacklistSort (model: any, value: string, lastSort: OrderItem = [ 'i
58 return [ firstSort, lastSort ] 58 return [ firstSort, lastSort ]
59} 59}
60 60
61function getFollowsSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): OrderItem[] {
62 const { direction, field } = buildDirectionAndField(value)
63
64 if (field === 'redundancyAllowed') {
65 return [
66 [ 'ActorFollowing', 'Server', 'redundancyAllowed', direction ],
67 lastSort
68 ]
69 }
70
71 return getSort(value, lastSort)
72}
73
61function isOutdated (model: { createdAt: Date, updatedAt: Date }, refreshInterval: number) { 74function isOutdated (model: { createdAt: Date, updatedAt: Date }, refreshInterval: number) {
62 const now = Date.now() 75 const now = Date.now()
63 const createdAtTime = model.createdAt.getTime() 76 const createdAtTime = model.createdAt.getTime()
@@ -163,6 +176,7 @@ export {
163 buildWhereIdOrUUID, 176 buildWhereIdOrUUID,
164 isOutdated, 177 isOutdated,
165 parseAggregateResult, 178 parseAggregateResult,
179 getFollowsSort,
166 createSafeIn 180 createSafeIn
167} 181}
168 182