QuestionsService.ts

import type { SupabaseClient } from "@supabase/supabase-js";
import type { 
    QuestionOverview,
    QuestionMeta,
    QuestionScores,
    VOTE_OPTIONS
} from "$models/Models";

import { createHash } from 'node:crypto'

export class QuestionService {
    private supaInstance: SupabaseClient

    private QUESTIONS_TABLE = 'questions'
    private SCORES_TABLE = 'scores'
    private VOTERS_TABLE = 'voters'

    constructor(supabaseInstance: SupabaseClient) {
        //setup the needs here
        this.supaInstance = supabaseInstance;
    }

    /**
     * Adds a new question to the system
     * @param title Question title
     * @param options Array of strings representing question voting options 
     * @returns `true` in case of success
     */
    async addQuestion(title: string, options: string[]): Promise<boolean> {
        const { data, error } = await this.supaInstance
            .from(this.QUESTIONS_TABLE)
            .insert({
                title: title,
                question_options: options
            })
            .select()
        
        // check for errors
        if(error) { return Promise.reject(error); }
        
        // then add initial score to scores table
        const questionID = data[0].id;
        const response = await this.supaInstance
            .from(this.SCORES_TABLE)
            .insert({
                question_id: questionID,
            });

        // finally, check if score addition resulted in error
        if(response.error) {
            console.error("Adding default scores failed. Manually deleting associated question...")
            
            // NOTE: as of now, Supabase does NOT support SQL transactions
            // in case of failure here, we should delete previous insertion, as we might end up with ghost data
            const deleteResponse = await this.supaInstance
                .from(this.QUESTIONS_TABLE)
                .delete()
                .eq('id', questionID)
            
            if(deleteResponse.error) { return Promise.reject(deleteResponse.error); }

            console.debug("After failing to add scores, associated question was removed successfully...")
            return Promise.reject(response.error);
        }

        // return positive outcome
        return Promise.resolve(true);
    }

    /**
     * Fetches all the questions of the system
     * @returns `QuestionSummary[]` array of question objects
     */
    async fetchAllQuestions(): Promise<QuestionOverview[]> {
        const { data, error } = await this.supaInstance
            .from(this.QUESTIONS_TABLE)
            .select(`
                id, 
                title,
                created_at,
                voters_count:voters (
                    question_id
                )
            `)

        // check for errors
        if(error) {
            return Promise.reject(error);
        }

        return Promise.resolve(data);
    }

    /**
     * Loads and returns `QuestionMeta` for given question ID
     * @param questionID ID of the question
     * @returns `QuestionMeda` object
     */
    async loadQuestionMeta(questionID: number): Promise<QuestionMeta> {
        const { data, error } = await this.supaInstance
            .from(this.QUESTIONS_TABLE)
            .select()
            .eq('id', questionID)
            .returns<QuestionMeta>()
            .maybeSingle();
        
        // check for errors
        if(error) { return Promise.reject(error) }

        // return the success
        return Promise.resolve(data);
    }

    async hasAnsweredQuestion(questionID: number): Promise<boolean> {
        // get commitment hash
        const commitmentHash = await this.getCommitHash(questionID);

        // check for entries
        const { data , error } = await this.supaInstance
            .from(this.VOTERS_TABLE)
            .select('user_hash')
            .eq('question_id', questionID)
            .eq('user_hash', commitmentHash)
            .maybeSingle()

        // check for errors
        if(error) { return Promise.reject(error) }
        //        
        return Promise.resolve(data !== null);
    }

    async loadQuestionScores(questionID: number): Promise<QuestionScores> {
        const { data, error } = await this.supaInstance
            .from(this.QUESTIONS_TABLE)
            .select(`
                *,
                scores(*),
                voters(question_id)
            `)
            .eq('id', questionID)
            .maybeSingle()
        
        // check for errors
        if(error) { return Promise.reject(error) }
        
        // construct return value
        const returnValue: QuestionScores = {
            id: data.id,
            title: data.title,
            question_options: data.question_options,
            created_at: data.created_at,

            option_scores: [
                data.scores.option_1,
                data.scores.option_2,
                data.scores.option_3,
                data.scores.option_4,
                data.scores.option_5,
            ],
            none: data.scores.none,
            not_clear: data.scores.not_clear,
            inadequate: data.scores.inadequate,

            total_voters: data.voters.length
        }

        return Promise.resolve(returnValue);
    }

    /**
     * Performs question voting operation and commits the change
     * @param questionID ID of the question to vote fore
     * @param vote_option `VOTE_OPTIONS` enum representing the actual user's choice
     * @returns `true` in case of success; `error` object in case of various errors
     */
    async commitQuestionVote(questionID: number, vote_option: VOTE_OPTIONS): Promise<boolean> {
        // 1. pull out column name
        const columnName = vote_option.toString().toLowerCase();
        //
        // 2. fetch the latest score
        const qResult = await this.supaInstance
            .from(this.SCORES_TABLE)
            .select(columnName)
            .eq('question_id', questionID)
            .maybeSingle()
        //
        // 2.a) check for fetch errors
        if(qResult.error) { return Promise.reject(qResult.error) }

        // 3. increase current score by 1 vote
        // and cache the result in case of further failures
        const oldValue = qResult.data[[columnName]];
        const newValue = oldValue + 1;

        // 4. upsert scores table with new score
        const scoreResult = await this.supaInstance
            .from(this.SCORES_TABLE)
            .upsert({
                question_id: questionID,
                [columnName]: newValue,
                last_updated: new Date()
            })
            .eq('question_id', questionID);

        // 4.a) check for upsert errors
        if(scoreResult.error) { 
            return Promise.reject(scoreResult.error)
        }

        // 5. calculate commit hash
        const commitHash = await this.getCommitHash(questionID);

        // 6. update voters table
        const commitResult = await this.supaInstance
            .from('voters')
            .insert({
                question_id: questionID,
                user_hash: commitHash
            })
        //
        // 6.a) check for commit errors
        if( commitResult.error ) {
            // revert the last update of the scoring table
            // to it's original value
            const rollbackResult = await this.supaInstance
                .from(this.SCORES_TABLE)
                .upsert({
                    question_id: questionID,
                    [columnName]: oldValue,
                    last_updated: new Date()
                })
                .eq('question_id', questionID);
            //
            // check for failures (if this happens, we end with ghost data)
            if(rollbackResult.error) {
                return Promise.reject(rollbackResult.error)
            }
            
            return Promise.reject(commitResult.error)
        }

        // 7. finally:
        return Promise.resolve(true);
    }

    private async getCommitHash(questionID: number): Promise<string> {
        // get the user info
        const { data: { user }, error } = await this.supaInstance.auth.getUser();
        // throw if errors
        if(error) { return Promise.reject(error) }

        // get question basics and check for errors
        const qResponse = await this.supaInstance
            .from(this.QUESTIONS_TABLE)
            .select('*')
            .eq('id', questionID)
            .maybeSingle()
        
        if(qResponse.error) { return Promise.reject(qResponse.error) }
        const qInfo = qResponse.data;

        // create hashers and combine values
        const qHasher = createHash('ripemd-160');
        const finalHasher = createHash('sha-384');

        qHasher.update(qInfo.id.toString());
        qHasher.update(user?.id);
        qHasher.update(qInfo.title);
        for(const anOption in qInfo.question_options) {
            qHasher.update(anOption);
        }
        //
        finalHasher.update(user?.id);
        finalHasher.update(qHasher.digest('hex'));

        const finalOutput = finalHasher.digest('hex');
        return Promise.resolve(finalOutput);
    }
}