GPT

Database Implementation

import { useMutation, useQuery, useQueryClient } from '@tanstack/react-query'; import { databases, ID } from '../lib/appwrite'; import { Query } from 'appwrite'; export function useDocuments(databaseId: string, collecti

Prompt text

Original English text. Replace placeholders with your own details.

import { useMutation, useQuery, useQueryClient } from '@tanstack/react-query';
import { databases, ID } from '../lib/appwrite';
import { Query } from 'appwrite';

export function useDocuments(databaseId: string, collectionId: string) {
 return useQuery({
 queryKey: ['documents', databaseId, collectionId],
 queryFn: () => databases.listDocuments(
 databaseId,
 collectionId,
 [
 Query.limit(20),
 Query.orderDesc('$createdAt')
 ]
 ),
 });
}

export function useDocument(databaseId: string, collectionId: string, documentId: string) {
 return useQuery({
 queryKey: ['document', databaseId, collectionId, documentId],
 queryFn: () => databases.getDocument(
 databaseId,
 collectionId,
 documentId
 ),
 });
}

export function useCreateDocument(databaseId: string, collectionId: string) {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: (data: any) => databases.createDocument(
 databaseId,
 collectionId,
 ID.unique(),
 data
 ),
 onSuccess: () => {
 queryClient.invalidateQueries(['documents', databaseId, collectionId]);
 },
 });
}

export function useUpdateDocument(databaseId: string, collectionId: string) {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: ({ documentId, data }: { documentId: string; data: any }) => databases.updateDocument(
 databaseId,
 collectionId,
 documentId,
 data
 ),
 onSuccess: (_, { documentId }) => {
 queryClient.invalidateQueries(['document', databaseId, collectionId, documentId]);
 queryClient.invalidateQueries(['documents', databaseId, collectionId]);
 },
 });
}

export function useDeleteDocument(databaseId: string, collectionId: string) {
 const queryClient = useQueryClient();

 return useMutation({
 mutationFn: (documentId: string) => databases.deleteDocument(
 databaseId,
 collectionId,
 documentId
 ),
 onSuccess: () => {
 queryClient.invalidateQueries(['documents', databaseId, collectionId]);
 },
 });
}

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 →