X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=server%2Fmodels%2Fvideo%2Fvideo-views.ts;h=6071e8c22297ddcbf5127a97df7838a21037236f;hb=cda03765fe366f028897e9b02dd4a0a19af3c935;hp=90ce671fd10857057ccfe506655469cbd0db6abf;hpb=6b6168606bc86430f6b7821c9d5f1c80d0425ebf;p=github%2FChocobozzz%2FPeerTube.git

diff --git a/server/models/video/video-views.ts b/server/models/video/video-views.ts
index 90ce671fd..6071e8c22 100644
--- a/server/models/video/video-views.ts
+++ b/server/models/video/video-views.ts
@@ -7,6 +7,9 @@ import * as Sequelize from 'sequelize'
   indexes: [
     {
       fields: [ 'videoId' ]
+    },
+    {
+      fields: [ 'startDate' ]
     }
   ]
 })
@@ -38,4 +41,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)
+  }
 }