Avraj Posts - Answer Overflow

Avraj

Explore posts from servers

DIAdiscord.js - Imagine an app TtRPC DTDrizzle Team

•Created by Avraj on 1/23/2024 in #❓-help

Is there a way to refetch a query with new parameters?

Hi I'm using tRPC in a Next.js app and I have a button that a user can click to get the latest data from the server. By default this data is cached in the server because the query is expensive. I've added an optional param/input in my query that looks like this:

guilds: privateProcedure
    .input(
        z
            .object({
                skipCache: z.boolean().optional(),
            })
            .optional()
    )
    .query(async ({ input, ctx }) => {
        // Get data
    });

guilds: privateProcedure
    .input(
        z
            .object({
                skipCache: z.boolean().optional(),
            })
            .optional()
    )
    .query(async ({ input, ctx }) => {
        // Get data
    });

So when { skipCache: true } is set, the user can bypass the cache and get the latest data. I'm feeling a bit lost however when it comes to the implementation itself. I can't find anything in the docs regarding refetching with new/updated params.

const trpcUtils = trpc.useUtils(); // This will return cached data from the server.

const { data: guilds, error } = trpc.private.guilds.useQuery();

const handleRefresh = () => {
    // The implementation to bypass cached data => { skipCache: true }
}

return <button onClick={handleRefresh}>Refresh</button>

const trpcUtils = trpc.useUtils(); // This will return cached data from the server.

const { data: guilds, error } = trpc.private.guilds.useQuery();

const handleRefresh = () => {
    // The implementation to bypass cached data => { skipCache: true }
}

return <button onClick={handleRefresh}>Refresh</button>

Is this something that's possible?

29 replies

DTDrizzle Team

•Created by Avraj on 12/25/2023 in #help

Update and return a single row only when using .update()?

Hi, I have the following drizzle code which updates levels in a table.

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

const updatedLevel = await db
    .update(levels)
    .set(queriedLevel)
    .where(
        and(
            eq(levels.userId, user_id),
            eq(levels.guildId, guild_id)
        )
    )
    .returning();

Is it possible to only update a single row in the levels table instead of all that match the where clause? I'm asking this because I want the returning() value to be a single object instead of an array of objects. I'm fairly new to pg and drizzle so I apologise if it's a silly question xD

5 replies

Gaming

Programming