ufoaz Comments - Convex Community

hmm ya seems we will need a schema sooner rather than later. if we had a schema, then would the best bet be to try catch bc the column for location id would be unique? then it would error out if already exists. then we wouldnt need to check if the location exists?

18 replies

CCConvex Community

•Created by ufoaz on 6/2/2024 in #support-community

Locking mechanism in custom Action (getOrCreate)?

I did try this:

export const create = internalMutation({
  args: {
    location_id: v.string(),
    combinedObj: v.any(),
  },
  handler: async (ctx, { location_id, combinedObj }) => {

    const location = await ctx.db
        .query("locations")
        .filter((q) => q.eq(q.field("location_id"), location_id))
        .unique();
      if (location) {
        return location;
      }
    return await ctx.db.insert("locations", {
      location_id,
      ...combinedObj,
    });
  },
});

export const create = internalMutation({
  args: {
    location_id: v.string(),
    combinedObj: v.any(),
  },
  handler: async (ctx, { location_id, combinedObj }) => {

    const location = await ctx.db
        .query("locations")
        .filter((q) => q.eq(q.field("location_id"), location_id))
        .unique();
      if (location) {
        return location;
      }
    return await ctx.db.insert("locations", {
      location_id,
      ...combinedObj,
    });
  },
});

However then i get this error:

Error: [CONVEX A(locations:getOrCreate)] [Request ID: 0b58f445eec01b4f] Server Error
Uncaught Error: Documents read from or written to the "locations" table changed while this mutation was being run and on every subsequent retry. Another call to this mutation changed the document with ID "jn7583h56b0az3g8szkn49mjw96t8d22". See https://docs.convex.dev/error#1
    at async handler (../../convex/locations.ts:25:53)

  Called by client

Error: [CONVEX A(locations:getOrCreate)] [Request ID: 0b58f445eec01b4f] Server Error
Uncaught Error: Documents read from or written to the "locations" table changed while this mutation was being run and on every subsequent retry. Another call to this mutation changed the document with ID "jn7583h56b0az3g8szkn49mjw96t8d22". See https://docs.convex.dev/error#1
    at async handler (../../convex/locations.ts:25:53)

  Called by client

Fetching like this client side:

  const [location, setLocation] = useState<any | null>(null);

  const getOrCreate = useAction(api.locations.getOrCreate);
  useEffect(() => {
    const fetchLocation = async () => {
      const result = await getOrCreate({ location_id: locationId });
      setLocation(result);
    };

    fetchLocation();
  }, [getOrCreate, locationId]);

  const [location, setLocation] = useState<any | null>(null);

  const getOrCreate = useAction(api.locations.getOrCreate);
  useEffect(() => {
    const fetchLocation = async () => {
      const result = await getOrCreate({ location_id: locationId });
      setLocation(result);
    };

    fetchLocation();
  }, [getOrCreate, locationId]);

18 replies

CCConvex Community

•Created by Khalil on 5/5/2024 in #show-and-tell

Join the waitlsit for Fastmind

@Khalil makes sense! very interesting gtm strategy i think, to not have to crawl. so OOTB bot is super lightweight.

12 replies

CCConvex Community

•Created by Khalil on 5/5/2024 in #show-and-tell

Join the waitlsit for Fastmind

Interesting idea! Would this lead to lower quality answers than a bot with access to more data sources of a company's, like Slack or CRM? It's interesting though, bc public facing docs is likely best as a source of truth, so maybe that's enough.

12 replies

CCConvex Community

•Created by Khalil on 5/5/2024 in #show-and-tell

Join the waitlsit for Fastmind

Cool! How does it work without scraping? Wouldn’t you need to embed the site?

12 replies

CCConvex Community

•Created by ufoaz on 4/27/2024 in #show-and-tell

Remi - AI Travel Assistant

The urls are public by default for itineraries. So those that you shared above should be viewable by anyone

15 replies

CCConvex Community

•Created by ufoaz on 4/27/2024 in #show-and-tell

Remi - AI Travel Assistant

Happy to take any feedback on what could make Remi more useful also!

15 replies

CCConvex Community

•Created by ufoaz on 4/27/2024 in #show-and-tell

Remi - AI Travel Assistant

Haha glad u like the feature, we just added it yesterday.

15 replies

CCConvex Community

•Created by ufoaz on 4/27/2024 in #show-and-tell

Remi - AI Travel Assistant

Thanks @Indy and @Matt Luo !

15 replies

CCConvex Community

•Created by ufoaz on 4/7/2024 in #support-community

What's the recommendation to include a 3rd party auth provider without OIDC?

I suppose it'd be great to better understand when the issuer url and i assumt OIDC authorize/userinfo calls come into play. Seems that the isAuthenticated is passed in the client side to the useConvexAuth hook directly so theoretically this doesn't need the issuer url. It seems that in the convex functions is when it could be used to validate a session token?

3 replies