/** Tests authored by ChatGPT; function below generated by Google Docs Gemini. */ function testGeminiAggregation() { const tests=[]; function check(name,fn){try{tests.push({name,pass:!!fn()});}catch(e){tests.push({name,pass:false,error:String(e)});}} function rejects(value){try{geminiSummarizeEventRows(value);return false;}catch(e){return true;}} check('normal_fixture',()=>{const r=geminiSummarizeEventRows([['Setup',20,18,0],['First demo',30,24,150],['Export check',10,8,50]]);return r.registrations===60&&r.attendances===50&&r.revenueCAD===200&&Math.abs(r.attendanceRate-5/6)<1e-12;}); check('empty_rows',()=>{const r=geminiSummarizeEventRows([]);return r.registrations===0&&r.attendances===0&&r.revenueCAD===0&&r.attendanceRate===null;}); check('zero_registrations',()=>geminiSummarizeEventRows([['Zero',0,0,0]]).attendanceRate===null); check('decimal_revenue',()=>geminiSummarizeEventRows([['Paid',1,1,1.25]]).revenueCAD===1.25); check('reject_nonarray',()=>rejects(null)); check('reject_short_row',()=>rejects([['Bad',1,1]])); check('reject_extra_column',()=>rejects([['Bad',1,1,0,'extra']])); check('reject_nonstring_name',()=>rejects([[123,1,1,0]])); check('reject_empty_name',()=>rejects([['',1,1,0]])); check('reject_whitespace_name',()=>rejects([[' ',1,1,0]])); check('reject_numeric_string',()=>rejects([['Bad','1',1,0]])); check('reject_fractional_count',()=>rejects([['Bad',1.5,1,0]])); check('reject_negative',()=>rejects([['Bad',1,1,-1]])); check('reject_attendance_over_registration',()=>rejects([['Bad',1,2,0]])); check('reject_infinite',()=>rejects([['Bad',1,1,Infinity]])); const passed=tests.filter(t=>t.pass).length; console.log(JSON.stringify({passed,total:tests.length,tests})); if(passed!==tests.length) throw new Error((tests.length-passed)+' validation checks failed'); } function geminiSummarizeEventRows(rows) { if (!Array.isArray(rows)) { throw new Error("Rows must be an array."); } let registrations = 0; let attendances = 0; let revenueCAD = 0; for (const row of rows) { if (!Array.isArray(row) || row.length !== 4) { throw new Error("Row must have exactly four columns."); } const [sessionName, reg, att, rev] = row; if (typeof sessionName !== "string" || sessionName.trim() === "") { throw new Error("Session name must be a nonempty string."); } if (!Number.isFinite(reg) || !Number.isInteger(reg) || reg < 0) { throw new Error("Registrations must be a finite, nonnegative integer."); } if (!Number.isFinite(att) || !Number.isInteger(att) || att < 0) { throw new Error("Attendances must be a finite, nonnegative integer."); } if (att > reg) { throw new Error("Attendances cannot exceed registrations."); } if (!Number.isFinite(rev) || rev < 0) { throw new Error("Revenue must be a finite, nonnegative number."); } registrations += reg; attendances += att; revenueCAD += rev; } const attendanceRate = registrations === 0 ? null : attendances / registrations; return { registrations, attendances, revenueCAD, attendanceRate }; }