server/models/video/sql/shared/abstract-videos-query-builder.ts

   1 import { QueryTypes, Sequelize, Transaction } from 'sequelize'
   2
   3 /**
   4  *
   5  * Abstact builder to run video SQL queries
   6  *
   7  */
   8
   9 export class AbstractVideosQueryBuilder {
  10   protected sequelize: Sequelize
  11
  12   protected query: string
  13   protected replacements: any = {}
  14
  15   protected runQuery (options: { transaction?: Transaction, logging?: boolean } = {}) {
  16     const queryOptions = {
  17       transaction: options.transaction,
  18       logging: options.logging,
  19       replacements: this.replacements,
  20       type: QueryTypes.SELECT as QueryTypes.SELECT,
  21       nest: false
  22     }
  23
  24     return this.sequelize.query<any>(this.query, queryOptions)
  25   }
  26 }