import { Calculator } from ".";
import { SqlGenerator } from "@rolesvillesoftware/tsentity/dist/src/SqlGenerator";

export class StudentPevCalculator extends Calculator<boolean, number> {

    /*
    Sql Used:

    Insert Into StudentPev
        (ExamDimId, QuestionDimId, ExamQuestionFactId, StudentDimId, isCorrect, QuestionPev, StudentPev)
        Select
            Q.ExamDimId,
            Q.QuestionDimId,
            Q.StudentDimId,
            EQ.Id  As ExamQuestionFactId,
            Q.isCorrect,
            QS.Pev As QuestionPev,
            QS.Pev * Case When Q.isCorrect = 0 Then -1 Else 1 End StudentPev
        From QuestionFact Q
            Inner Join ExamQuestionFact EQ On EQ.ExamDimId = Q.ExamDimId And EQ.QuestionDimId = Q.QuestionDimId
            Inner Join QuestionStat QS On QS.examQuestionFactId = EQ.Id
        ;
     */

    async calculate(input?: boolean): Promise<number> {
        let rows = 0;
       return rows;
    }

}