user-delete-auditing.ts

export class UsersController {
    // ----- other methods removed for clarity
    
    @ownerOrAdmin()
    @route.delete(":id")
    async delete(id: number, @bind.user() user: LoginUser) {
        const audit = <Audit>{
            userId: user.userId,
            action: "Delete",
            resource: "Users",
            data: JSON.stringify([id])
        }
        try {
            const result = db("User").update({ deleted: 1 }).where({ id })
            await db("Audit").insert(<Audit>{ ...audit, status: "Success" })
            return result;
        }
        catch (e) {
            await db("Audit").insert(<Audit>{ ...audit, status: "Error" })
            throw e;
        }
    }
}