GPT

Database Service

// src/app/services/user.service.ts import { Injectable } from '@angular/core'; import { db } from '../db'; import { users, type User, type NewUser } from '../db/schema'; import { eq } from 'drizzle-orm'; import { Observ

Prompt text

Original English text. Replace placeholders with your own details.

// src/app/services/user.service.ts
import { Injectable } from '@angular/core';
import { db } from '../db';
import { users, type User, type NewUser } from '../db/schema';
import { eq } from 'drizzle-orm';
import { Observable, from } from 'rxjs';

@Injectable({
 providedIn: 'root',
})
export class UserService {
 getUsers(): Observable<User[]> {
 return from(
 db.select().from(users).orderBy(users.name)
 );
 }

 getUserById(id: number): Observable<User | undefined> {
 return from(
 db.select()
 .from(users)
 .where(eq(users.id, id))
 .then(([user]) => user)
 );
 }

 createUser(user: NewUser): Observable<User> {
 return from(
 db.insert(users)
 .values(user)
 .returning()
 .then(([newUser]) => newUser)
 );
 }

 updateUser(id: number, user: Partial<NewUser>): Observable<User> {
 return from(
 db.update(users)
 .set(user)
 .where(eq(users.id, id))
 .returning()
 .then(([updatedUser]) => updatedUser)
 );
 }

 deleteUser(id: number): Observable<void> {
 return from(
 db.delete(users)
 .where(eq(users.id, id))
 .then(() => void 0)
 );
 }
}

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 →