GPT

Basic Data Service

// src/app/services/user.service.ts import { Injectable } from '@angular/core'; import { DatabaseService } from './database.service'; import { Observable } from 'rxjs'; export interface User { id: number; name: string

Prompt text

Original English text. Replace placeholders with your own details.

// src/app/services/user.service.ts
import { Injectable } from '@angular/core';
import { DatabaseService } from './database.service';
import { Observable } from 'rxjs';

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

@Injectable({
 providedIn: 'root'
})
export class UserService {
 constructor(private db: DatabaseService) {}

 getUsers(): Observable<User[]> {
 return this.db.query<User[]>('SELECT * FROM users ORDER BY name ASC');
 }

 getUserById(id: number): Observable<User> {
 return this.db.query<User>(
 'SELECT * FROM users WHERE id = $1',
 [id]
 );
 }

 createUser(user: Omit<User, 'id'>): Observable<User> {
 return this.db.query<User>(
 'INSERT INTO users (name, email) VALUES ($1, $2) RETURNING *',
 [user.name, user.email]
 );
 }

 updateUser(id: number, user: Partial<User>): Observable<User> {
 const updates = [];
 const values = [];
 let paramIndex = 1;

 if (user.name) {
 updates.push(`name = $${paramIndex}`);
 values.push(user.name);
 paramIndex++;
 }

 if (user.email) {
 updates.push(`email = $${paramIndex}`);
 values.push(user.email);
 paramIndex++;
 }

 values.push(id);
 return this.db.query<User>(
 `UPDATE users SET ${updates.join(', ')} WHERE id = $${paramIndex} RETURNING *`,
 values
 );
 }

 deleteUser(id: number): Observable<void> {
 return this.db.execute('DELETE FROM users WHERE id = $1', [id]);
 }
}

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 →