- if (value.substring(0, 1) === '-') {
- direction = 'DESC'
- field = value.substring(1)
- } else {
- direction = 'ASC'
- field = value
+ if (field.toLowerCase() === 'match') { // Search
+ field = Sequelize.col('similarity')
+ }
+
+ return [ [ field, direction ], lastSort ]
+}
+
+function getVideoSort (value: string, lastSort: string[] = [ 'id', 'ASC' ]) {
+ let { direction, field } = buildDirectionAndField(value)
+
+ // Alias
+ if (field.toLowerCase() === 'match') { // Search
+ field = Sequelize.col('similarity')
+ } else if (field.toLowerCase() === 'trending') { // Sort by aggregation
+ return [
+ [ Sequelize.fn('COALESCE', Sequelize.fn('SUM', Sequelize.col('VideoViews.views')), '0'), direction ],
+
+ [ Sequelize.col('VideoModel.views'), direction ],
+
+ lastSort
+ ]