Data Layer high complexity backend
0
Dependencies
0
Dependents
34
Entities
0
Integrations

Description

Data access layer for all admin portal persistence operations, querying user accounts, organizational metadata, settings, and audit records through Supabase with Row Level Security policies enforcing scope boundaries. Provides transactional operations for role assignments and settings updates, and streams real-time updates for dashboard metrics via Supabase subscriptions.

Feature: Admin Portal

admin-repository

Responsibilities

  • Query users and roles within the admin's Supabase RLS-enforced scope
  • Persist organization settings and label configurations
  • Write audit log entries for all admin mutations
  • Aggregate dashboard metric data from activities, users, and org tables
  • Stream real-time metric updates via Supabase subscriptions

Interfaces

fetchUsersInOrg(orgId)
fetchUserById(userId)
insertUserRole(userId, roleId, orgId)
deleteUserRole(userId, roleId)
updateUserStatus(userId, status)
fetchOrgSettings(orgId)
upsertOrgSettings(orgId, settings)
fetchOrgLabels(orgId)
upsertOrgLabel(orgId, labelKey, labelValue)
fetchAuditLog(orgId, filters, page)
insertAuditEntry(entry)
fetchDashboardMetrics(orgId)
subscribeToMetrics(orgId, onUpdate)