Merge branch 'release/2.1.0' into develop

[github/Chocobozzz/PeerTube.git] / server / models / video / video-views.ts

diff --git a/server/models/video/video-views.ts b/server/models/video/video-views.ts
index fde5f7056a0182d1f7500f1747900eebd0ebacff..40db5effdbf54507c870f1c011d61128dafa1694 100644 (file)
--- a/server/models/video/video-views.ts
+++ b/server/models/video/video-views.ts
@@ -4,6 +4,7 @@ import * as Sequelize from 'sequelize'
 
 @Table({
   tableName: 'videoView',
+  updatedAt: false,
   indexes: [
     {
       fields: [ 'videoId' ]
@@ -41,4 +42,18 @@ export class VideoViewModel extends Model<VideoViewModel> {
   })
   Video: VideoModel
 
+  static removeOldRemoteViewsHistory (beforeDate: string) {
+    const query = {
+      where: {
+        startDate: {
+          [Sequelize.Op.lt]: beforeDate
+        },
+        videoId: {
+          [Sequelize.Op.in]: Sequelize.literal('(SELECT "id" FROM "video" WHERE "remote" IS TRUE)')
+        }
+      }
+    }
+
+    return VideoViewModel.destroy(query)
+  }
 }