Use raw SQL for video get request

1 files changed, 22 insertions, 0 deletions

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