From a15871560f80e07386c1dabb8370cd2664ecfd1f Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Fri, 31 Jan 2020 16:56:52 +0100 Subject: Move to eslint --- shared/extra-utils/miscs/sql.ts | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) (limited to 'shared/extra-utils/miscs/sql.ts') diff --git a/shared/extra-utils/miscs/sql.ts b/shared/extra-utils/miscs/sql.ts index 42599c20e..5bd5d5d8a 100644 --- a/shared/extra-utils/miscs/sql.ts +++ b/shared/extra-utils/miscs/sql.ts @@ -1,7 +1,7 @@ import { QueryTypes, Sequelize } from 'sequelize' import { ServerInfo } from '../server/servers' -let sequelizes: { [ id: number ]: Sequelize } = {} +const sequelizes: { [ id: number ]: Sequelize } = {} function getSequelize (internalServerNumber: number) { if (sequelizes[internalServerNumber]) return sequelizes[internalServerNumber] @@ -52,7 +52,8 @@ async function countVideoViewsOf (internalServerNumber: number, uuid: string) { const seq = getSequelize(internalServerNumber) // tslint:disable - const query = `SELECT SUM("videoView"."views") AS "total" FROM "videoView" INNER JOIN "video" ON "video"."id" = "videoView"."videoId" WHERE "video"."uuid" = '${uuid}'` + const query = 'SELECT SUM("videoView"."views") AS "total" FROM "videoView" ' + + `INNER JOIN "video" ON "video"."id" = "videoView"."videoId" WHERE "video"."uuid" = '${uuid}'` const options = { type: QueryTypes.SELECT as QueryTypes.SELECT } const [ { total } ] = await seq.query<{ total: number }>(query, options) @@ -64,9 +65,10 @@ async function countVideoViewsOf (internalServerNumber: number, uuid: string) { async function closeAllSequelize (servers: ServerInfo[]) { for (const server of servers) { - if (sequelizes[ server.internalServerNumber ]) { - await sequelizes[ server.internalServerNumber ].close() - delete sequelizes[ server.internalServerNumber ] + if (sequelizes[server.internalServerNumber]) { + await sequelizes[server.internalServerNumber].close() + // eslint-disable-next-line + delete sequelizes[server.internalServerNumber] } } } -- cgit v1.2.3