GPT

Basic Database Operations

// src/users.js import { sql } from './db.js'; export async function getUsers() { try { const users = await sql SELECT id, name, email FROM users ORDER BY name ASC ; return users; } catch (error) { console.erro

Prompt text

Original English text. Replace placeholders with your own details.

// src/users.js
import { sql } from './db.js';

export async function getUsers() {
 try {
 const users = await sql`
 SELECT id, name, email
 FROM users
 ORDER BY name ASC
 `;
 return users;
 } catch (error) {
 console.error('Failed to fetch users:', error);
 throw error;
 }
}

export async function getUserById(id) {
 try {
 const [user] = await sql`
 SELECT id, name, email
 FROM users
 WHERE id = ${id}
 `;
 return user;
 } catch (error) {
 console.error(`Failed to fetch user ${id}:`, error);
 throw error;
 }
}

export async function createUser({ name, email }) {
 try {
 const [user] = await sql`
 INSERT INTO users (name, email)
 VALUES (${name}, ${email})
 RETURNING id, name, email
 `;
 return user;
 } catch (error) {
 console.error('Failed to create user:', error);
 throw error;
 }
}

export async function updateUser(id, { name, email }) {
 try {
 const [user] = await sql`
 UPDATE users
 SET name = ${name}, email = ${email}
 WHERE id = ${id}
 RETURNING id, name, email
 `;
 return user;
 } catch (error) {
 console.error(`Failed to update user ${id}:`, error);
 throw error;
 }
}

export async function deleteUser(id) {
 try {
 await sql`
 DELETE FROM users
 WHERE id = ${id}
 `;
 } catch (error) {
 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 →