aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models/shared/abstract-run-query.ts
diff options
context:
space:
mode:
Diffstat (limited to 'server/models/shared/abstract-run-query.ts')
-rw-r--r--server/models/shared/abstract-run-query.ts28
1 files changed, 28 insertions, 0 deletions
diff --git a/server/models/shared/abstract-run-query.ts b/server/models/shared/abstract-run-query.ts
new file mode 100644
index 000000000..c39b7bcfe
--- /dev/null
+++ b/server/models/shared/abstract-run-query.ts
@@ -0,0 +1,28 @@
1import { QueryTypes, Sequelize, Transaction } from 'sequelize'
2
3/**
4 *
5 * Abstact builder to run video SQL queries
6 *
7 */
8
9export class AbstractRunQuery {
10 protected query: string
11 protected replacements: any = {}
12
13 constructor (protected readonly sequelize: Sequelize) {
14
15 }
16
17 protected runQuery (options: { nest?: boolean, transaction?: Transaction, logging?: boolean } = {}) {
18 const queryOptions = {
19 transaction: options.transaction,
20 logging: options.logging,
21 replacements: this.replacements,
22 type: QueryTypes.SELECT as QueryTypes.SELECT,
23 nest: options.nest ?? false
24 }
25
26 return this.sequelize.query<any>(this.query, queryOptions)
27 }
28}