All files / dal ho-users.dal.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
 
 
 
 
 
4x
 
 
 
 
2x
 
 
 
2x
 
 
 
// Data Access Layer for Homeowner accounts (ho_users)
import { eq } from "drizzle-orm";
import type { DrizzleD1Database } from "drizzle-orm/d1";
import * as schema from "../db/schema";
 
export class HoUsersDal {
	constructor(private db: DrizzleD1Database<typeof schema>) {}
 
	// Hard-delete a homeowner account. FK ON DELETE CASCADE on the homeowner
	// child tables (favorites, mood boards, profile, etc.) cleans up dependents.
	async deleteById(id: string): Promise<boolean> {
		const result = await this.db
			.delete(schema.hoUsers)
			.where(eq(schema.hoUsers.id, id))
			.returning();
		return result.length > 0;
	}
}