GPT

Database Service

// src/services/userService.ts import { db } from '@/db'; import { users, type User, type NewUser } from '@/db/schema'; import { eq } from 'drizzle-orm'; export const userService = { async getUsers() { try { return a

Prompt text

Original English text. Replace placeholders with your own details.

// src/services/userService.ts
import { db } from '@/db';
import { users, type User, type NewUser } from '@/db/schema';
import { eq } from 'drizzle-orm';

export const userService = {
 async getUsers() {
 try {
 return await db.select().from(users).orderBy(users.name);
 } catch (error: any) {
 console.error('Failed to fetch users:', error);
 throw error;
 }
 },

 async getUserById(id: number) {
 try {
 const [user] = await db
 .select()
 .from(users)
 .where(eq(users.id, id));
 return user;
 } catch (error: any) {
 console.error(`Failed to fetch user ${id}:`, error);
 throw error;
 }
 },

 async createUser(user: NewUser) {
 try {
 const [newUser] = await db
 .insert(users)
 .values(user)
 .returning();
 return newUser;
 } catch (error: any) {
 console.error('Failed to create user:', error);
 throw error;
 }
 },

 async updateUser(id: number, user: Partial<NewUser>) {
 try {
 const [updatedUser] = await db
 .update(users)
 .set(user)
 .where(eq(users.id, id))
 .returning();
 return updatedUser;
 } catch (error: any) {
 console.error(`Failed to update user ${id}:`, error);
 throw error;
 }
 },

 async deleteUser(id: number) {
 try {
 await db.delete(users).where(eq(users.id, id));
 } catch (error: any) {
 console.error(`Failed to delete user ${id}:`, error);
 throw error;
 }
 },
};

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 →