import db from "./database";

export const findTokenUser = async (token: string ) => {
    return new Promise<number>((res, rej) => {
        db.get('SELECT user_id FROM auth_tokens WHERE token = ?', [token], (err: any, row: {user_id: number} | null) => {
            if (err) {
                rej(err)
            } else if (!row) {
                rej('Token not found')
            } else {
                res(row.user_id)
            }
        })
    })
}

export const findAllTokens = async (user: number | string): Promise<{token: string}[]> => {
    return new Promise<{token: string}[]>((res, rej) => {
        db.all('SELECT token FROM auth_tokens WHERE user_id = ?', [user], (err: any, rows: {token: string}[] | null) => {
            if (err) {
                rej(err)
            } else if (!rows) {
                res([])
            } else {
                res(rows)
            }
        })
    })
}