A flexible, open-source appointment scheduling system built with Flask.

# Clone the repository
git clone https://github.com/luisadrianpuga/schedule.git

# Navigate to project directory
cd schedule

# Activate virtual environment
source venv/bin/activate

# Install dependencies
pip install -r requirements.txt

# Set up the database
python3 sqlite_setup.py

# Run the application
python3 app.py

The API will be available at http://localhost:8080

• 📱 User Management: Registration, authentication, and role-based permissions
• ⏰ Availability Management: Professionals can define their available time slots
• 📅 Appointment Booking: Students/parents can book appointments with professionals
• 📣 Notifications: Email notifications for appointment status changes
• 💬 Communication: Messaging between professionals and students
• ⭐ Rating System: Review completed appointments
• 🛡️ Role-Based Access: Different capabilities for professionals, students/parents, and admins

• Python 3.6+
• SQLite (embedded, no separate installation required)
• Virtual environment with dependencies (included in repo)

Note: The repository includes a virtual environment (venv) with all required dependencies.

Configuration is done through environment variables:

Example:

PORT=9000 FLASK_ENV=production python app.py

The API is organized around RESTful principles with the following main endpoints:

When the database is created, the following test users are available:

schedule/
├── app.py               # Main application entry point
├── sqlite_setup.py      # Database schema and setup
├── api_utilities.py     # Shared utilities for the API
└── requirements.txt     # Python dependencies

Here are some common API calls you can make with curl:

curl -X POST http://localhost:8080/api/auth/register \
  -H "Content-Type: application/json" \
  -d '{
    "email": "[email protected]",
    "password": "securepassword",
    "name": "John Smith",
    "role": "student_parent"
  }'

curl -X POST http://localhost:8080/api/auth/login \
  -H "Content-Type: application/json" \
  -d '{
    "email": "[email protected]",
    "password": "securepassword"
  }'

Save the token from the response:

{
  "success": true,
  "data": {
    "token": "your-auth-token-here",
    "user": {...}
  }
}

curl -X GET http://localhost:8080/api/professionals/[professional_id]/availability \
  -H "Authorization: Bearer your-auth-token-here"

curl -X POST http://localhost:8080/api/appointments \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer your-auth-token-here" \
  -d '{
    "professional_id": "[professional_id]",
    "slot_id": "[slot_id]",
    "appointment_type_id": "[appointment_type_id]"
  }'

The system uses SQLite with the following main tables:

• USERS: User accounts
• ROLES: System roles (admin, professional, student_parent)
• AVAILABILITY: Professional availability blocks
• APPOINTMENT_SLOTS: Individual bookable time slots
• APPOINTMENTS: Booked appointments
• COMMUNICATION_LOGS: Messages between users
• NOTIFICATIONS: System notifications

The database needs to be set up manually before running the application:

# Create and populate the database
python3 sqlite_setup.py

This will create appointment_system.db with test data including:

• Admin user (email: [email protected], password: adminpassword)
• Test professional users with availability slots
• Test student/parent users
• Sample appointment types

If you want to reset the database:

# Delete the existing database
rm appointment_system.db

# Run the setup script again
python3 sqlite_setup.py

1. Define the route in app.py
2. Implement authentication/authorization with @auth_required()
3. Add necessary database operations in the route function
4. Return standardized responses using success_response() or error_response()

Contributions are welcome! Please feel free to submit a Pull Request.

1. Fork the repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

This project is licensed under the MIT License - see the LICENSE file for details.

• Flask - The web framework used
• SQLite - Embedded database
• Flask-CORS - CORS handling for the API