2 files changed, 139 insertions, 0 deletions

diff --git a/server/models/account/user.ts b/server/models/account/user.ts
index 89265774b..4b13e47a0 100644
--- a/server/models/account/user.ts
+++ b/server/models/account/user.ts
@@ -39,6 +39,7 @@ import { AccountModel } from './account'
 import { NSFWPolicyType } from '../../../shared/models/videos/nsfw-policy.type'
 import { values } from 'lodash'
 import { NSFW_POLICY_TYPES } from '../../initializers'
+import { VideoFileModel } from '../video/video-file'
 
 enum ScopeNames {
   WITH_VIDEO_CHANNEL = 'WITH_VIDEO_CHANNEL'
@@ -393,4 +394,15 @@ export class UserModel extends Model<UserModel> {
                       return parseInt(total, 10)
                     })
   }
+
+  static autocomplete (search: string) {
+    return UserModel.findAll({
+      where: {
+        username: {
+          [Sequelize.Op.like]: `%${search}%`
+        }
+      }
+    })
+      .then(u => u.map(u => u.username))
+  }
 }
diff --git a/server/models/video/video-change-ownership.ts b/server/models/video/video-change-ownership.ts
new file mode 100644
index 000000000..c9cff5054
--- /dev/null
+++ b/server/models/video/video-change-ownership.ts
@@ -0,0 +1,127 @@
+import { AllowNull, BelongsTo, Column, CreatedAt, ForeignKey, Model, Scopes, Table, UpdatedAt } from 'sequelize-typescript'
+import { AccountModel } from '../account/account'
+import { VideoModel } from './video'
+import { VideoChangeOwnership, VideoChangeOwnershipStatus } from '../../../shared/models/videos'
+import { getSort } from '../utils'
+import { VideoFileModel } from './video-file'
+
+enum ScopeNames {
+  FULL = 'FULL'
+}
+
+@Table({
+  tableName: 'videoChangeOwnership',
+  indexes: [
+    {
+      fields: ['videoId']
+    },
+    {
+      fields: ['initiatorAccountId']
+    },
+    {
+      fields: ['nextOwnerAccountId']
+    }
+  ]
+})
+@Scopes({
+  [ScopeNames.FULL]: {
+    include: [
+      {
+        model: () => AccountModel,
+        as: 'Initiator',
+        required: true
+      },
+      {
+        model: () => AccountModel,
+        as: 'NextOwner',
+        required: true
+      },
+      {
+        model: () => VideoModel,
+        required: true,
+        include: [{ model: () => VideoFileModel }]
+      }
+    ]
+  }
+})
+export class VideoChangeOwnershipModel extends Model<VideoChangeOwnershipModel> {
+  @CreatedAt
+  createdAt: Date
+
+  @UpdatedAt
+  updatedAt: Date
+
+  @AllowNull(false)
+  @Column
+  status: VideoChangeOwnershipStatus
+
+  @ForeignKey(() => AccountModel)
+  @Column
+  initiatorAccountId: number
+
+  @BelongsTo(() => AccountModel, {
+    foreignKey: {
+      name: 'initiatorAccountId',
+      allowNull: false
+    },
+    onDelete: 'cascade'
+  })
+  Initiator: AccountModel
+
+  @ForeignKey(() => AccountModel)
+  @Column
+  nextOwnerAccountId: number
+
+  @BelongsTo(() => AccountModel, {
+    foreignKey: {
+      name: 'nextOwnerAccountId',
+      allowNull: false
+    },
+    onDelete: 'cascade'
+  })
+  NextOwner: AccountModel
+
+  @ForeignKey(() => VideoModel)
+  @Column
+  videoId: number
+
+  @BelongsTo(() => VideoModel, {
+    foreignKey: {
+      allowNull: false
+    },
+    onDelete: 'cascade'
+  })
+  Video: VideoModel
+
+  static listForApi (nextOwnerId: number, start: number, count: number, sort: string) {
+    return VideoChangeOwnershipModel.scope(ScopeNames.FULL).findAndCountAll({
+      offset: start,
+      limit: count,
+      order: getSort(sort),
+      where: {
+        nextOwnerAccountId: nextOwnerId
+      }
+    })
+      .then(({ rows, count }) => ({ total: count, data: rows }))
+  }
+
+  static load (id: number) {
+    return VideoChangeOwnershipModel.scope(ScopeNames.FULL).findById(id)
+  }
+
+  toFormattedJSON (): VideoChangeOwnership {
+    return {
+      id: this.id,
+      status: this.status,
+      initiatorAccount: this.Initiator.toFormattedJSON(),
+      nextOwnerAccount: this.NextOwner.toFormattedJSON(),
+      video: {
+        id: this.Video.id,
+        uuid: this.Video.uuid,
+        url: this.Video.url,
+        name: this.Video.name
+      },
+      createdAt: this.createdAt
+    }
+  }
+}