/
codiart
/
sirus_bot
Обзор
Документация
Войти
/
codiart
/
sirus_bot
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/database/DataProvider.ts
29 строк
925 B
MediartTeam
Initial for gitverse
03 июл 2024, 16:33
03 июл 2024, 16:33
33bbf94
Код
Авторство
О чём код?
import SQL from './sql'; import type { Character, UserExist } from './models'; import type { Connection, FieldPacket, QueryResult } from 'mysql2/promise'; export class DataProvider { private connection: Connection; constructor(connection: Connection) { this.connection = connection; } get user() { return { getUserInfo: async (id: string): Promise<[QueryResult, FieldPacket[]] | undefined> => await this.connection.execute(SQL.user.get, [id]), checkUser: async (userid: string): Promise<boolean> => { const [rows, query] = await this.connection.execute<UserExist[]>('SELECT COUNT(*) as `user` FROM `users` WHERE `discord_id` = ?', [userid]); return rows.length && rows[0] ? rows[0].user === 1 : false; }, }; } get character() { return { getCharacters: async (id: string): Promise<[Character[], FieldPacket[]]> => await this.connection.execute(SQL.character.get, [id]), }; } }