Spaces:
Sleeping
Sleeping
Commit History
-
feat: implement geofences API with merchant-scoped security
- Created GET /tracker/geofences endpoint - Merchant isolation with JWT validation - Active/inactive status filtering - Haversine distance calculation for point-in-geofence checks - Database table with validation constraints - Indexes on merchant_id, active status, and location - Comprehensive security: users only see their own merchant's geofences - Migration script with test data (4 geofences) - Complete documentation and test suite - Production-ready error handling6bf0a90
-
feat: implement location tracking API with TimescaleDB hypertable
- Created POST /tracker/tracking/points endpoint for batch location upload - Implemented TimescaleDB hypertable with 1-day partitioning - Added compression policy (7 days) and retention policy (90 days) - Created indexes on user_id, merchant_id, and recorded_at - Batch upload supports up to 1000 points per request - Comprehensive validation (timestamp order, ranges, coordinates) - JWT authentication required - Migration script with test data - Complete documentation and test suite - Performance: 10-100x faster time-range queries956cecd