JuliaLind / vteam-server

import { db } from "./db.js"

const card = {

    /**

     * Returns all valid cards.

     * Each card objects contains

     * id (int) and name (string)

     * @returns {Promise<Array>}

     */

    getTypes: async function() {

        const result = await db.queryNoArgs(`CALL card_types();`);

        return result[0];

    },

    /**

     * Returns card_nr, card_type

     * and card_type_descr

     * @param {Number} userId 

     * @returns {Promise<Object>}

     */

    userDetails: async function(userId) {

        const result = await db.queryWithArgs(`CALL user_card(?);`, [userId]);

        return result[0][0];

    },

    /**

     * Updates cardnr and cardtype

     * of a user. Returns the updated

     * card_nr, card_type and card_type_descr

     * @param {Number} userId 

     * @param {String} cardnr 

     * @param {Number} cardType 

     * @returns {Promise<Object>}

     */

    updUserDetails: async function(userId, cardnr, cardType) {

        // cardnr needs to contain 13-19 digits

        const check = cardnr ? cardnr.toString().replace(/\D/g, '') : "";

        if (!/^\d{13,19}$/.test(check)) {

            throw new Error('invalid cardnr');

        }

        const result = await db.queryWithArgs(`CALL upd_user_card(?, ?, ?);`, [userId, cardnr, cardType]);

        return result[0][0];

    },

};

export default card;