aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models
diff options
context:
space:
mode:
Diffstat (limited to 'server/models')
-rw-r--r--server/models/utils.ts15
-rw-r--r--server/models/video/video-playlist.ts4
2 files changed, 15 insertions, 4 deletions
diff --git a/server/models/utils.ts b/server/models/utils.ts
index 6e5522346..a06d57831 100644
--- a/server/models/utils.ts
+++ b/server/models/utils.ts
@@ -1,7 +1,7 @@
1import { literal, Op, OrderItem } from 'sequelize'
1import { Model, Sequelize } from 'sequelize-typescript' 2import { Model, Sequelize } from 'sequelize-typescript'
2import validator from 'validator'
3import { Col } from 'sequelize/types/lib/utils' 3import { Col } from 'sequelize/types/lib/utils'
4import { literal, OrderItem, Op } from 'sequelize' 4import validator from 'validator'
5 5
6type SortType = { sortModel: string, sortValue: string } 6type SortType = { sortModel: string, sortValue: string }
7 7
@@ -22,6 +22,16 @@ function getSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): OrderIt
22 return [ [ finalField, direction ], lastSort ] 22 return [ [ finalField, direction ], lastSort ]
23} 23}
24 24
25function getPlaylistSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): OrderItem[] {
26 const { direction, field } = buildDirectionAndField(value)
27
28 if (field.toLowerCase() === 'name') {
29 return [ [ 'displayName', direction ], lastSort ]
30 }
31
32 return getSort(value, lastSort)
33}
34
25function getCommentSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): OrderItem[] { 35function getCommentSort (value: string, lastSort: OrderItem = [ 'id', 'ASC' ]): OrderItem[] {
26 const { direction, field } = buildDirectionAndField(value) 36 const { direction, field } = buildDirectionAndField(value)
27 37
@@ -227,6 +237,7 @@ export {
227 buildBlockedAccountSQL, 237 buildBlockedAccountSQL,
228 buildBlockedAccountSQLOptimized, 238 buildBlockedAccountSQLOptimized,
229 buildLocalActorIdsIn, 239 buildLocalActorIdsIn,
240 getPlaylistSort,
230 SortType, 241 SortType,
231 buildLocalAccountIdsIn, 242 buildLocalAccountIdsIn,
232 getSort, 243 getSort,
diff --git a/server/models/video/video-playlist.ts b/server/models/video/video-playlist.ts
index 581179640..b020bfa45 100644
--- a/server/models/video/video-playlist.ts
+++ b/server/models/video/video-playlist.ts
@@ -16,7 +16,7 @@ import {
16 UpdatedAt 16 UpdatedAt
17} from 'sequelize-typescript' 17} from 'sequelize-typescript'
18import { VideoPlaylistPrivacy } from '../../../shared/models/videos/playlist/video-playlist-privacy.model' 18import { VideoPlaylistPrivacy } from '../../../shared/models/videos/playlist/video-playlist-privacy.model'
19import { buildServerIdsFollowedBy, buildWhereIdOrUUID, getSort, isOutdated, throwIfNotValid } from '../utils' 19import { buildServerIdsFollowedBy, buildWhereIdOrUUID, getPlaylistSort, getPlaylistSort, isOutdated, throwIfNotValid } from '../utils'
20import { 20import {
21 isVideoPlaylistDescriptionValid, 21 isVideoPlaylistDescriptionValid,
22 isVideoPlaylistNameValid, 22 isVideoPlaylistNameValid,
@@ -312,7 +312,7 @@ export class VideoPlaylistModel extends Model<VideoPlaylistModel> {
312 const query = { 312 const query = {
313 offset: options.start, 313 offset: options.start,
314 limit: options.count, 314 limit: options.count,
315 order: getSort(options.sort) 315 order: getPlaylistSort(options.sort)
316 } 316 }
317 317
318 const scopes: (string | ScopeOptions)[] = [ 318 const scopes: (string | ScopeOptions)[] = [