elysia-admin: Instructions file for Kiro

后端模块规范（Elysia + Bun）

与 .cursor/rules/backend.mdc 同源。详细代码模板：

#[[file:.ai/AI_CODE_EXAMPLES_BACKEND.md]]

Backend Module Structure

Every module under server/src/modules/{group}-{name}/ should contain:

modules/{group}-{name}/
    dto.ts      ← Elysia 校验 + 路由片段（body/query/response 等）；必要时可含 `afterHandle` 等 hook
    handle.ts   ← business logic only
    route.ts    ← HTTP mapping only
    task.ts     ← 供 BullMQ / 沙箱 worker 调度的导出函数（按需添加；无任务可不建此文件）

No extra files. No renaming. Route auto-registers on startup.

task.ts：仅当模块需要向 server/src/worker-sandbox/ 注册队列/定时任务时添加。

跨模块 handle：系统域（auth / user / role / menu / dept 等）允许 handle 之间互相 import 已导出的查询或命令；新业务模块优先单模块内聚，避免网状依赖。

---

Layer Rules (Strict)

File	Allowed	Forbidden
dto.ts	Elysia schema、响应 DTO、可选 afterHandle 等 hook	复杂业务编排、直接 DB
handle.ts	repository、QueryBuilder、shared、infrastructure；系统域可调其他模块已导出函数	raw SQL、直连 pg、在 handle 里 new Elysia
route.ts	bind dto+handle, return result	business logic, DB access
task.ts	export plain functions, call handle functions	duplicate business logic, direct DB access

---

Repository Functions (from @/core/database/repository)

InsertOne(schema, ctx)                          // insert, no return
InsertOneAndRes(schema, ctx)                    // insert, return record
InsertMany(schema, ctx, dataArray)              // bulk insert
FindOneByKey(schema, 'primaryKey', value)       // find by key
FindAll(schema, whereSQL, options?)             // find all (no pagination)
FindPage(schema, whereSQL, paginationOptions)   // paginated query
UpdateByKey(schema, 'primaryKey', ctx)          // update by key
UpdateByKeyAndRes(schema, 'primaryKey', ctx)    // update, return record
SoftDeleteByKeys(schema, 'primaryKey', ctx)     // soft delete (sets delFlag=true)
HardDelete(schema, whereSQL)                    // permanent delete
HardDeleteByKeys(schema, 'primaryKey', values) // permanent delete by keys
FindAllWithJoin(schema, builder, options?)      // find all with join
FindPageWithJoin(schema, builder, options)      // paginated with join