1 files changed, 15 insertions, 0 deletions

diff --git a/server/models/video/sql/abstract-videos-query-builder.ts b/server/models/video/sql/abstract-videos-query-builder.ts
new file mode 100644
index 000000000..597a02af7
--- /dev/null
+++ b/server/models/video/sql/abstract-videos-query-builder.ts
@@ -0,0 +1,15 @@
+import { logger } from '@server/helpers/logger'
+import { Sequelize, QueryTypes } from 'sequelize'
+
+export class AbstractVideosQueryBuilder {
+  protected sequelize: Sequelize
+
+  protected query: string
+  protected replacements: any = {}
+
+  protected runQuery (nest?: boolean) {
+    logger.info('Running video query.', { query: this.query, replacements: this.replacements })
+
+    return this.sequelize.query<any>(this.query, { replacements: this.replacements, type: QueryTypes.SELECT, nest })
+  }
+}