User Reviews and Moderation

When to use this skill

• Implementing the "Reviews" collection logic.
• Building the admin approval dashboard.

Workflow

• [ ] Users post a review (Doc created in reviews collection).
• [ ] Status set to pending by default.
• [ ] Admin changes status to approved.
• [ ] Tour details page only shows reviews where status === 'approved'.

Calculations (Aggregation)

• Problem: Calculating average rating every time is slow.
• Solution: Use an Appwrite Function to update the averageRating and reviewCount on the Tour document whenever a review is approved.

Instructions

• Abuse: Limit users to 1 review per tour.
• Content: Ensure Zod sanitization (see sanitizing-inputs-zod) to prevent profanity or spam.