Remote Procedure Call (RPC) Reference

Attendrix utilizes PostgreSQL Remote Procedure Calls (RPCs) over Supabase PostgREST to encapsulate transactional mutations, state calculations, and atomic operations. RPCs run directly inside the database engine, providing guaranteed consistency and sub-50ms execution times.

Overview of Client RPCs

Attendance RPCs

mark_absent

Marks an explicit absence for a specific class slot on behalf of the calling student.

mark_absent(
  p_class_id uuid,
  p_source text,
  p_reason text DEFAULT NULL
) RETURNS jsonb

• Security: SECURITY DEFINER
• Permission: Authenticated user (auth.uid())

Parameters

Response Schema

{
  "success": true,
  "is_absent": true,
  "class_id": "00000000-0000-0000-0000-000000000001",
  "user_id": "00000000-0000-0000-0000-000000000002",
  "timestamp": "2026-09-04T10:15:00.000Z",
  "course_id": "CS301",
  "attendance": {
    "attended": 24,
    "missed": 3,
    "percentage": 88.89,
    "required": 80
  }
}

Error Codes

• CLASS_NOT_FOUND: The specified p_class_id does not exist.
• CLASS_CANCELLED: Cannot mark absence for a cancelled class slot.
• ALREADY_MARKED: Absence record already exists for this student and class.

un_mark_absent

Removes a previously logged absence, reverting the student's status for that class slot to present.

un_mark_absent(
  p_class_id uuid
) RETURNS jsonb

• Security: SECURITY DEFINER
• Permission: Authenticated user (auth.uid())

Response Schema

{
  "success": true,
  "is_absent": false,
  "class_id": "00000000-0000-0000-0000-000000000001",
  "user_id": "00000000-0000-0000-0000-000000000002",
  "timestamp": "2026-09-04T10:20:00.000Z",
  "course_id": "CS301",
  "attendance": {
    "attended": 25,
    "missed": 2,
    "percentage": 92.59,
    "required": 80
  }
}

Timetable & Schedule RPCs

get_classes_for_dates

Retrieves all scheduled, rescheduled, and extra classes for an array of calendar dates, joining course metadata and absence indicators.

get_classes_for_dates(
  p_dates text[]
) RETURNS TABLE(
  class_id uuid,
  course_id text,
  course_code text,
  course_name text,
  batch_id text,
  scheduled_start timestamptz,
  scheduled_end timestamptz,
  venue text,
  is_cancelled boolean,
  is_extra_class boolean,
  is_plus_slot boolean,
  is_absent boolean
)

• Security: SECURITY DEFINER
• Permission: Authenticated user

Onboarding & Enrollment RPCs

complete_user_onboarding

Initializes student profile details, assigns academic department and batch, and sets up default user preferences within a single atomic database transaction.

complete_user_onboarding(
  p_department_id text,
  p_batch_id text,
  p_roll_number text,
  p_username text,
  p_full_name text,
  p_section text,
  p_sub_batch text,
  p_mess_name text
) RETURNS jsonb

Routing & Navigation RPCs

get_published_routing_dataset

Streams the latest published offline pedestrian routing dataset to the mobile client for in-memory caching.

get_published_routing_dataset() RETURNS jsonb

• Security: SECURITY DEFINER
• Response Size: Approximately 15.3 MB of precomputed shortest-path route records across 152,904 origin-destination pairs.
• Client Cache Strategy: Downloaded once upon bootstrap; stored locally in SQLite / shared preferences with cache invalidation triggered only by a version bump in routing_dataset_versions.