DylanDev Posts - Convex Community

DylanDev

•Created by DylanDev on 3/20/2025 in #support-community

Patching two values in a document causes functions to be re triggered

I have a function called checkGuess which checks the user's guess and returns data relating to their guess. Additionally, it updates a the "level" document in my levels table by adding 1 to times played and adding 1 to correctguesses if they got it right. However, when I add this patch code, it is triggering my original function again that pulls down 5 random levels and is causing the game to loop indefinitely?

export const checkGuess = mutation({
  args: { levelId: v.id("levels"), selectedImageId: v.id("images") },
  handler: async(ctx, args) => {
    const level = await ctx.db.get(args.levelId);

    if(!level) {
      throw new Error("No levels exist");
    }

    let AIGeneratedImageId;
    let AIGeneratedImagePrompt;

    for (const imageId of level.images) {
      const image = await ctx.db.get(imageId);
      if (image && image.isAIGenerated) {
        AIGeneratedImageId = image;
        AIGeneratedImagePrompt = image.AIGeneratedPrompt;
        break;
      }
    }

    if(!AIGeneratedImageId) {
      throw new Error("No AI-generated image found.");
    }

    let score = 0;
    let correct = false;

    if(args.selectedImageId === AIGeneratedImageId._id) {
      score = 50;
      correct = true;
    } else {
      score = 0;
      correct = false;
    }

    const totalPlays = level.totalPlays + 1n;
    const correctAnswers = correct ? (level.correctAnswers + 1n) : level.correctAnswers;
    const globalAccuracy = totalPlays > 0n ? ((correctAnswers * 100n) / totalPlays) : 0n;

    await ctx.db.patch(level._id, {
      totalPlays,
      correctAnswers
    });

    return {
      correct,
      correctImageId: AIGeneratedImageId._id,
      groupName: level.groupName,
      classification: level.classification,
      hints: level.hints,
      aiImagePrompt: AIGeneratedImagePrompt,
      score,
      globalAccuracy: globalAccuracy
    };
  }
});

export const checkGuess = mutation({
  args: { levelId: v.id("levels"), selectedImageId: v.id("images") },
  handler: async(ctx, args) => {
    const level = await ctx.db.get(args.levelId);

    if(!level) {
      throw new Error("No levels exist");
    }

    let AIGeneratedImageId;
    let AIGeneratedImagePrompt;

    for (const imageId of level.images) {
      const image = await ctx.db.get(imageId);
      if (image && image.isAIGenerated) {
        AIGeneratedImageId = image;
        AIGeneratedImagePrompt = image.AIGeneratedPrompt;
        break;
      }
    }

    if(!AIGeneratedImageId) {
      throw new Error("No AI-generated image found.");
    }

    let score = 0;
    let correct = false;

    if(args.selectedImageId === AIGeneratedImageId._id) {
      score = 50;
      correct = true;
    } else {
      score = 0;
      correct = false;
    }

    const totalPlays = level.totalPlays + 1n;
    const correctAnswers = correct ? (level.correctAnswers + 1n) : level.correctAnswers;
    const globalAccuracy = totalPlays > 0n ? ((correctAnswers * 100n) / totalPlays) : 0n;

    await ctx.db.patch(level._id, {
      totalPlays,
      correctAnswers
    });

    return {
      correct,
      correctImageId: AIGeneratedImageId._id,
      groupName: level.groupName,
      classification: level.classification,
      hints: level.hints,
      aiImagePrompt: AIGeneratedImagePrompt,
      score,
      globalAccuracy: globalAccuracy
    };
  }
});

15 replies

CCConvex Community

•Created by DylanDev on 12/20/2024 in #support-community

Deleting Users from Backend Function that are Synced with Clerk

12 replies

CCConvex Community

•Created by DylanDev on 11/7/2024 in #support-community

npx convex deploy does not send my dev data including files to production

Why does running npx convex deploy not send over my tables from my dev instance and files to the production instance?

7 replies

CCConvex Community

•Created by DylanDev on 10/14/2024 in #support-community

Clerk With Convex in Backend Functions

I want to store a score variable in the public metadata but I can't figure out how to modify that from the backend and I get an error? Error:

Uncaught Error
    at UserAPI.request (../node_modules/@clerk/backend/src/api/request.ts:186:15)
    at async handler (../convex/game.ts:102:61)

Uncaught Error
    at UserAPI.request (../node_modules/@clerk/backend/src/api/request.ts:186:15)
    at async handler (../convex/game.ts:102:61)

Code:

import { v } from "convex/values";

import { mutation, query } from "./_generated/server";
import { createClerkClient } from '@clerk/backend';

const clerkClient = createClerkClient({ secretKey: process.env.CLERK_SECRET_KEY });

...

export const checkGuess = mutation({
    args: { id: v.id("levels"), guessLatitude: v.float64(), guessLongitude: v.float64() },
    handler: async(ctx, args) => {
        const level = await ctx.db.get(args.id);

        if(!level) {
            throw new Error("No levels exist");
        }

        const correctLat = level.latitude;
        const correctLng = level.longitude;

        const distanceAway = parseInt(haversineDistanceInFeet(correctLat, correctLng, args.guessLatitude, args.guessLongitude).toFixed(0));
        // give some leniency to the distance
        let lenientDistance = distanceAway - 20;
        if (lenientDistance < 0) {
            lenientDistance = 0;
        }
        // If within 250 feet, score increases by distance if outside of 250 feet score = 0
        let score = 250 - lenientDistance; 
        if (score < 0) { // no negative score
            score = 0;
        }

        // Fetch the user from Clerk
        const user = await ctx.auth.getUserIdentity();
        if(user !== null) {
            console.log(user); // THIS IS PRINTING OUT CORRECTLY
            await clerkClient.users.updateUser(user.subject, {
                publicMetadata: {
                    score: score,
                },
            });
        }

        return {
            correctLat,
            correctLng,
            distanceAway,
            score,
        }
    }
});

import { v } from "convex/values";

import { mutation, query } from "./_generated/server";
import { createClerkClient } from '@clerk/backend';

const clerkClient = createClerkClient({ secretKey: process.env.CLERK_SECRET_KEY });

...

export const checkGuess = mutation({
    args: { id: v.id("levels"), guessLatitude: v.float64(), guessLongitude: v.float64() },
    handler: async(ctx, args) => {
        const level = await ctx.db.get(args.id);

        if(!level) {
            throw new Error("No levels exist");
        }

        const correctLat = level.latitude;
        const correctLng = level.longitude;

        const distanceAway = parseInt(haversineDistanceInFeet(correctLat, correctLng, args.guessLatitude, args.guessLongitude).toFixed(0));
        // give some leniency to the distance
        let lenientDistance = distanceAway - 20;
        if (lenientDistance < 0) {
            lenientDistance = 0;
        }
        // If within 250 feet, score increases by distance if outside of 250 feet score = 0
        let score = 250 - lenientDistance; 
        if (score < 0) { // no negative score
            score = 0;
        }

        // Fetch the user from Clerk
        const user = await ctx.auth.getUserIdentity();
        if(user !== null) {
            console.log(user); // THIS IS PRINTING OUT CORRECTLY
            await clerkClient.users.updateUser(user.subject, {
                publicMetadata: {
                    score: score,
                },
            });
        }

        return {
            correctLat,
            correctLng,
            distanceAway,
            score,
        }
    }
});

26 replies

CCConvex Community

•Created by DylanDev on 10/8/2024 in #support-community

Supposed to return ids in random order but mostly does one image

I'm trying to pull down 5 document entries in my "levels" table and it seems to only ever return the ids in the same order most of the time. Every once and a while and sometimes when I have to refresh the npx convex dev server, will it then pull a different image. Is my code wrong?

import { v } from "convex/values";

import { mutation, query } from "./_generated/server";
import { Doc, Id } from "./_generated/dataModel";

// Gets the number of random Levels from the database
export const getRandomLevels = query({
    handler: async (ctx) => {
        // TODO: Implement a way to choose number of levels based on backend settings
        const numOfLevels = 5;
        const levels = await ctx.db.query("levels").collect();

        if(levels.length < numOfLevels) {
            throw new Error("Not enough levels to complete request!");
        }

        console.log(levels);

        const selectedLevels = [];

        for(let i = 0; i < numOfLevels; i++) {
            const randomIndex = Math.floor(Math.random() * levels.length);
            selectedLevels[i] = levels[randomIndex];
            levels.splice(randomIndex, 1);
        }

        // Extract and return the Ids of the selected levels
        const levelIds = selectedLevels.map(level => level._id);
        console.log("[SERVER SIDE] Ids", levelIds);
        return levelIds;
    }
});

export const getImageSrc = query({
    args: { id: v.id("levels") },
    handler: async (ctx, args) => {
        if(!args.id) {
            throw new Error("Missing entryId parameter.");
        }

        const level = await ctx.db.get(args.id);

        if(!level) {
            throw new Error("No levels exist");
        }

        const imageUrl = await ctx.storage.getUrl(level.imageId);

        return imageUrl;
    }
});

import { v } from "convex/values";

import { mutation, query } from "./_generated/server";
import { Doc, Id } from "./_generated/dataModel";

// Gets the number of random Levels from the database
export const getRandomLevels = query({
    handler: async (ctx) => {
        // TODO: Implement a way to choose number of levels based on backend settings
        const numOfLevels = 5;
        const levels = await ctx.db.query("levels").collect();

        if(levels.length < numOfLevels) {
            throw new Error("Not enough levels to complete request!");
        }

        console.log(levels);

        const selectedLevels = [];

        for(let i = 0; i < numOfLevels; i++) {
            const randomIndex = Math.floor(Math.random() * levels.length);
            selectedLevels[i] = levels[randomIndex];
            levels.splice(randomIndex, 1);
        }

        // Extract and return the Ids of the selected levels
        const levelIds = selectedLevels.map(level => level._id);
        console.log("[SERVER SIDE] Ids", levelIds);
        return levelIds;
    }
});

export const getImageSrc = query({
    args: { id: v.id("levels") },
    handler: async (ctx, args) => {
        if(!args.id) {
            throw new Error("Missing entryId parameter.");
        }

        const level = await ctx.db.get(args.id);

        if(!level) {
            throw new Error("No levels exist");
        }

        const imageUrl = await ctx.storage.getUrl(level.imageId);

        return imageUrl;
    }
});

7 replies

CCConvex Community

•Created by DylanDev on 10/8/2024 in #support-community

API Functions Returning from Server but showing undefined in client

3 replies

CCConvex Community

•Created by DylanDev on 10/7/2024 in #support-community

How to find a table entry from _id

I want to query the my table and find the table document that has the _id i pass in. How do I do this?

6 replies

CCConvex Community

•Created by DylanDev on 10/5/2024 in #support-community

Help with loading images from image id in a table and image sitting in the Files

5 replies