+ static listCommentsForApi (parameters: {
+ start: number
+ count: number
+ sort: string
+
+ onLocalVideo?: boolean
+ isLocal?: boolean
+ search?: string
+ searchAccount?: string
+ searchVideo?: string
+ }) {
+ const { start, count, sort, isLocal, search, searchAccount, searchVideo, onLocalVideo } = parameters
+
+ const where: WhereOptions = {
+ deletedAt: null
+ }
+
+ const whereAccount: WhereOptions = {}
+ const whereActor: WhereOptions = {}
+ const whereVideo: WhereOptions = {}
+
+ if (isLocal === true) {
+ Object.assign(whereActor, {
+ serverId: null
+ })
+ } else if (isLocal === false) {
+ Object.assign(whereActor, {
+ serverId: {
+ [Op.ne]: null
+ }
+ })
+ }
+
+ if (search) {
+ Object.assign(where, {
+ [Op.or]: [
+ searchAttribute(search, 'text'),
+ searchAttribute(search, '$Account.Actor.preferredUsername$'),
+ searchAttribute(search, '$Account.name$'),
+ searchAttribute(search, '$Video.name$')
+ ]
+ })
+ }
+
+ if (searchAccount) {
+ Object.assign(whereActor, {
+ [Op.or]: [
+ searchAttribute(searchAccount, '$Account.Actor.preferredUsername$'),
+ searchAttribute(searchAccount, '$Account.name$')
+ ]
+ })
+ }
+
+ if (searchVideo) {
+ Object.assign(whereVideo, searchAttribute(searchVideo, 'name'))
+ }
+
+ if (exists(onLocalVideo)) {
+ Object.assign(whereVideo, { remote: !onLocalVideo })
+ }
+
+ const getQuery = (forCount: boolean) => {
+ return {
+ offset: start,
+ limit: count,
+ order: getCommentSort(sort),
+ where,
+ include: [
+ {
+ model: AccountModel.unscoped(),
+ required: true,
+ where: whereAccount,
+ include: [
+ {
+ attributes: {
+ exclude: unusedActorAttributesForAPI
+ },
+ model: forCount === true
+ ? ActorModel.unscoped() // Default scope includes avatar and server
+ : ActorModel,
+ required: true,
+ where: whereActor
+ }
+ ]
+ },
+ {
+ model: VideoModel.unscoped(),
+ required: true,
+ where: whereVideo
+ }
+ ]
+ }
+ }
+
+ return Promise.all([
+ VideoCommentModel.count(getQuery(true)),
+ VideoCommentModel.findAll(getQuery(false))
+ ]).then(([ total, data ]) => ({ total, data }))
+ }
+