From fa47956ecf51a6d5d10aeb25d2e4db3da90c7d58 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Wed, 28 Jul 2021 10:32:40 +0200 Subject: Filter host for channels and playlists search --- server/models/shared/query.ts | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 server/models/shared/query.ts (limited to 'server/models/shared/query.ts') diff --git a/server/models/shared/query.ts b/server/models/shared/query.ts new file mode 100644 index 000000000..036cc13c6 --- /dev/null +++ b/server/models/shared/query.ts @@ -0,0 +1,17 @@ +import { BindOrReplacements, QueryTypes } from 'sequelize' +import { sequelizeTypescript } from '@server/initializers/database' + +function doesExist (query: string, bind?: BindOrReplacements) { + const options = { + type: QueryTypes.SELECT as QueryTypes.SELECT, + bind, + raw: true + } + + return sequelizeTypescript.query(query, options) + .then(results => results.length === 1) +} + +export { + doesExist +} -- cgit v1.2.3