GPT

Basic Database Operations

// src/pages/users.astro import { db } from '../db'; import { users, type User } from '../db/schema'; import { eq } from 'drizzle-orm'; let userList: User[] = []; let error: string | null = null; try { userList = awai

Prompt text

Original English text. Replace placeholders with your own details.

---
// src/pages/users.astro
import { db } from '../db';
import { users, type User } from '../db/schema';
import { eq } from 'drizzle-orm';

let userList: User[] = [];
let error: string | null = null;

try {
 userList = await db.select().from(users).orderBy(users.name);
} catch (e: any) {
 error = e.message;
}
---

<div>
 <h1>Users</h1>
 
 {error && <div class="error">{error}</div>}
 
 <ul>
 {userList.map((user) => (
 <li>
 {user.name} ({user.email})
 <form method="POST" action="/api/users/delete">
 <input type="hidden" name="id" value={user.id} />
 <button type="submit">Delete</button>
 </form>
 </li>
 ))}
 </ul>

 <form method="POST" action="/api/users/create">
 <input type="text" name="name" placeholder="Name" required />
 <input type="email" name="email" placeholder="Email" required />
 <button type="submit">Add User</button>
 </form>
</div>

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 →