GPT

Database Operations with Tanstack Query

// src/hooks/useUsers.ts import { useQuery, useMutation, useQueryClient } from '@tanstack/react-query'; import { db } from '../db'; import { users, type User, type NewUser } from '../db/schema'; import { eq } from 'drizz

Prompt text

Original English text. Replace placeholders with your own details.

// src/hooks/useUsers.ts
import { useQuery, useMutation, useQueryClient } from '@tanstack/react-query';
import { db } from '../db';
import { users, type User, type NewUser } from '../db/schema';
import { eq } from 'drizzle-orm';

// Fetch all users
export function useUsers() {
 return useQuery({
 queryKey: ['users'],
 queryFn: async () => {
 const users = await db.select().from(users).orderBy(users.name);
 return users;
 },
 });
}

// Fetch user by ID
export function useUser(id: number) {
 return useQuery({
 queryKey: ['users', id],
 queryFn: async () => {
 const [user] = await db
 .select()
 .from(users)
 .where(eq(users.id, id));
 return user;
 },
 enabled: !!id,
 });
}

// Create user mutation
export function useCreateUser() {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: async (user: NewUser) => {
 const [newUser] = await db
 .insert(users)
 .values(user)
 .returning();
 return newUser;
 },
 onSuccess: () => {
 queryClient.invalidateQueries({ queryKey: ['users'] });
 },
 });
}

// Update user mutation
export function useUpdateUser() {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: async ({ id, ...data }: User) => {
 const [updatedUser] = await db
 .update(users)
 .set(data)
 .where(eq(users.id, id))
 .returning();
 return updatedUser;
 },
 onSuccess: (data) => {
 queryClient.invalidateQueries({ queryKey: ['users'] });
 queryClient.invalidateQueries({ queryKey: ['users', data.id] });
 },
 });
}

// Delete user mutation
export function useDeleteUser() {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: async (id: number) => {
 await db.delete(users).where(eq(users.id, id));
 },
 onSuccess: () => {
 queryClient.invalidateQueries({ queryKey: ['users'] });
 },
 });
}

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →