File size: 3,501 Bytes
1a45d5d aeb9637 a64b653 aeb9637 8ec33d8 a64b653 8ec33d8 a64b653 8ec33d8 1a45d5d 8ec33d8 a64b653 8ec33d8 aeb9637 a64b653 aeb9637 a64b653 aeb9637 1a45d5d aeb9637 1a45d5d |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 |
import { createClient } from 'https://esm.sh/@supabase/[email protected]';
import * as Sentry from "https://deno.land/x/sentry/index.mjs";
Sentry.init({
dsn: "https://ca41c3f96489cc1b3e69c9a44704f7ee@o4508722276007936.ingest.de.sentry.io/4508772265558096",
defaultIntegrations: false,
// Performance Monitoring
tracesSampleRate: 1.0,
// Set sampling rate for profiling - this is relative to tracesSampleRate
profilesSampleRate: 1.0,
});
Sentry.setTag('region', Deno.env.get('SB_REGION'));
Sentry.setTag('execution_id', Deno.env.get('SB_EXECUTION_ID'));
const corsHeaders = {
'Access-Control-Allow-Origin': '*',
'Access-Control-Allow-Headers': 'authorization, x-client-info, apikey, content-type',
}
Deno.serve(async (req) => {
if (req.method === 'OPTIONS') {
return new Response(null, { headers: corsHeaders })
}
try {
const { playerName, score, avgWordsPerRound, sessionId, theme, gameId } = await req.json()
if (!playerName || !score || !avgWordsPerRound || !sessionId || !theme) {
throw new Error('Missing required fields')
}
const supabaseClient = createClient(
Deno.env.get('SUPABASE_URL') ?? '',
Deno.env.get('SUPABASE_ANON_KEY') ?? '',
{
auth: {
persistSession: false,
},
}
)
console.log('Verifying game results for session:', sessionId)
// First verify that the claimed score matches actual game results
const { data: gameResults, error: gameError } = await supabaseClient
.from('game_results')
.select('is_correct')
.eq('session_id', sessionId)
if (gameError) {
throw new Error('Failed to verify game results')
}
console.log('Fetched game results:', {
sessionId,
gameResults: gameResults?.length
})
// Count successful rounds
const successfulRounds = gameResults?.filter(result => result.is_correct).length ?? 0
console.log('Verified game results:', {
sessionId,
claimedScore: score,
actualSuccessfulRounds: successfulRounds,
gameId
})
// Verify that claimed score matches actual successful rounds
if (score !== successfulRounds) {
Sentry.captureException('Score verification failed')
return new Response(
JSON.stringify({
error: 'Score verification failed',
message: 'Submitted score does not match game results'
}),
{
headers: { ...corsHeaders, 'Content-Type': 'application/json' },
status: 400,
},
)
}
console.log('Submitting verified score:', { playerName, score, avgWordsPerRound, sessionId, theme })
const { data, error } = await supabaseClient.rpc('check_and_update_high_score', {
p_player_name: playerName,
p_score: score,
p_avg_words_per_round: avgWordsPerRound,
p_session_id: sessionId,
p_theme: theme,
p_game_id: gameId
})
if (error) {
throw error
}
return new Response(
JSON.stringify({
success: data[0].success,
isUpdate: data[0].is_update
}),
{
headers: { ...corsHeaders, 'Content-Type': 'application/json' },
status: 200,
},
)
} catch (error) {
Sentry.captureException(error)
console.error('Error:', error.message)
return new Response(
JSON.stringify({ error: error.message }),
{
headers: { ...corsHeaders, 'Content-Type': 'application/json' },
status: 400,
},
)
}
})
|