1-// User Account Service v1.0
1+// User Account Service v2.0
22 export interface User {
33 id: string;
44 name: string;
55 email: string;
6- role: 'member' | 'admin';
6+ role: 'member' | 'admin' | 'owner';
7+ createdAt: Date;
78 }
89
9-export function getUser(id: string): User | null {
10- console.log('Fetching user with ID:', id);
11- return db.query('SELECT * FROM users WHERE id = ?', [id]);
10+export async function getUser(id: string): Promise<User | null> {
11+ console.log('Fetching user with ID (async):', id);
12+ return await db.query('SELECT * FROM users WHERE id = ? AND deleted_at IS NULL', [id]);
1213 }
1314
14-export function deleteUser(id: string): boolean {
15- return db.execute('DELETE FROM users WHERE id = ?', [id]);
15+export async function deleteUser(id: string): Promise<boolean> {
16+ // Soft delete implementation
17+ return await db.execute('UPDATE users SET deleted_at = NOW() WHERE id = ?', [id]);
1618 }