Home Inventory System Test Page

This page tests all the foundation components we've built.

System Tests

Testing database connection, API routes, and configurations

Environment Variables

Supabase Connection

Database Tables

Room API (Unauthenticated)

Authentication Required

Next Steps After Testing:
1. If tests pass: Set up Supabase database using the SQL files in the `/database` folder
2. Create a user account to test authenticated features
3. Test the Room API with authentication
4. Begin building the frontend interfaces

Manual Testing Instructions

1. Database Setup

Go to your Supabase project → SQL Editor → Run the contents of `database/schema.sql`

2. Add Database Functions

In SQL Editor, run the contents of `database/functions.sql`

3. Test API with curl

# Test unauthenticated request (should return 401)
curl http://localhost:3000/api/rooms

# Test with invalid data (should return 400)
curl -X POST http://localhost:3000/api/rooms \
  -H "Content-Type: application/json" \
  -d '{"name": ""}'

4. Create User & Test

After creating auth UI, create a user account and test authenticated API calls