]>
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 | } |