[github/Chocobozzz/PeerTube.git] / server / models / video / sql / video / shared / abstract-run-query.ts

import { QueryTypes, Sequelize, Transaction } from 'sequelize'

/**
 *
 * Abstact builder to run video SQL queries
 *
 */

export class AbstractRunQuery {
  protected sequelize: Sequelize

  protected query: string
  protected replacements: any = {}

  protected runQuery (options: { transaction?: Transaction, logging?: boolean } = {}) {
    const queryOptions = {
      transaction: options.transaction,
      logging: options.logging,
      replacements: this.replacements,
      type: QueryTypes.SELECT as QueryTypes.SELECT,
      nest: false
    }

    return this.sequelize.query<any>(this.query, queryOptions)
  }
}
Commit	Line	Data
	1	import { QueryTypes, Sequelize, Transaction } from 'sequelize'
	2
	3	/**
	4	*
	5	* Abstact builder to run video SQL queries
	6	*
	7	*/
	8
	9	export class AbstractRunQuery {
	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	}