GPT

Database Operations with Tanstack Query

// src/hooks/useUsers.ts import { useQuery, useMutation, useQueryClient } from '@tanstack/react-query'; import { sql } from '../lib/db'; interface User { id: number; name: string; email: string; } // Fetch all users

Prompt text

Original English text. Replace placeholders with your own details.

// src/hooks/useUsers.ts
import { useQuery, useMutation, useQueryClient } from '@tanstack/react-query';
import { sql } from '../lib/db';

interface User {
 id: number;
 name: string;
 email: string;
}

// Fetch all users
export function useUsers() {
 return useQuery({
 queryKey: ['users'],
 queryFn: async () => {
 const users = await sql<User[]>`
 SELECT id, name, email
 FROM users
 ORDER BY name ASC
 `;
 return users;
 },
 });
}

// Fetch user by ID
export function useUser(id: number) {
 return useQuery({
 queryKey: ['users', id],
 queryFn: async () => {
 const [user] = await sql<User[]>`
 SELECT id, name, email
 FROM users
 WHERE id = ${id}
 `;
 return user;
 },
 enabled: !!id,
 });
}

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

 return useMutation({
 mutationFn: async ({ name, email }: Omit<User, 'id'>) => {
 const [user] = await sql<User[]>`
 INSERT INTO users (name, email)
 VALUES (${name}, ${email})
 RETURNING id, name, email
 `;
 return user;
 },
 onSuccess: () => {
 queryClient.invalidateQueries({ queryKey: ['users'] });
 },
 });
}

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

 return useMutation({
 mutationFn: async ({ id, ...data }: User) => {
 const [user] = await sql<User[]>`
 UPDATE users
 SET name = ${data.name}, email = ${data.email}
 WHERE id = ${id}
 RETURNING id, name, email
 `;
 return user;
 },
 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 sql`DELETE FROM users WHERE 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 →