1 import { QueryTypes, Sequelize, Transaction } from 'sequelize'
2 import { logger } from '@server/helpers/logger'
6 * Abstact builder to run video SQL queries
10 export class AbstractVideosQueryBuilder {
11 protected sequelize: Sequelize
13 protected query: string
14 protected replacements: any = {}
16 protected runQuery (options: { transaction?: Transaction, logging?: boolean } = {}) {
17 logger.debug('Running videos query.', { query: this.query, replacements: this.replacements })
19 const queryOptions = {
20 transaction: options.transaction,
21 logging: options.logging,
22 replacements: this.replacements,
23 type: QueryTypes.SELECT as QueryTypes.SELECT,
27 return this.sequelize.query<any>(this.query, queryOptions)