How protonium04/hostel-accommodation-system works
This Streamlit hostel administration app lets an administrator review dashboard metrics and manage students, rooms, bookings, checkout, payments, complaints, and pending dues. Domain pages access MySQL through a shared database helper; several searchable lists also use a shared table filter. The README documents reset and analytics capabilities, and the SQL artifact supports database setup. For unsampled pages, connections are limited to references in the source index or explicit README statements.
Main entry points: db.py Database helper · search.py Searchable tables · students.py Student records · rooms.py Room availability
Components 14
Administration UI
- Dashboard analytics
app.py - Admin reset
pages/admin_rest.py
Accommodation
- Student records
pages/students.py - Room availability
pages/rooms.py - Room bookings
pages/bookings.py - Booking checkout
pages/checkout.py
Fees and payments
- Payment records
pages/payments.py - Pending dues
pages/pending_dues.py
Student services
- Complaint handling
pages/complaints.py
Shared infrastructure
- Database helper
utils/db.py - Searchable tables
utils/search.py - Database schema
HostelAccomodation.sql
Other components
- Administrator
- MySQL database
Connections 17
- Administrator → Dashboard analytics: opens app
README.md - Dashboard analytics → Database helper: queries metrics
app.py - Student records → Database helper: reads and updates
pages/students.py - Student records → Searchable tables: filters list
pages/students.py - Room availability → Database helper: reads and updates
pages/rooms.py - Room availability → Searchable tables: filters lists
pages/rooms.py - Room bookings → Database helper: reads and updates
pages/bookings.py - Room bookings → Searchable tables: filters list
pages/bookings.py - Booking checkout → Database helper: completes booking
pages/checkout.py - Payment records → Database helper: reads and updates
pages/payments.py - Payment records → Searchable tables: filters list
pages/payments.py - Pending dues → Database helper: reads payment data
pages/pending_dues.py - Complaint handling → Database helper: reads and updates
pages/complaints.py - Complaint handling → Searchable tables: filters list
pages/complaints.py - Admin reset → Database helper: uses database
pages/admin_rest.py - Database helper → MySQL database: queries and writes
utils/db.py - Database schema → MySQL database: sets up schema
README.md