HappyPaws

HappyPaws – Spring PetClinic Application

Care for Every Paw! Visit Website

HappyPaws is a full-stack web application developed using React and Spring Boot, based on the modern Spring PetClinic architecture. The project demonstrates real-world enterprise application development practices such as layered architecture, RESTful APIs, database persistence, and role-based security.

This project is submitted as a Final Year B.Tech project for the Computer Science & Machine Learning (CSM) program at SVCET, Chittoor.

–

Project Overview

The traditional Spring PetClinic application mainly focuses on backend concepts and does not reflect modern enterprise-level development. HappyPaws enhances this by integrating a React-based frontend with a Spring Boot backend, making it closer to a production-oriented full-stack application.

The system is designed to manage veterinary clinic operations including owners, pets, visits, and veterinarians through a centralized and structured platform.

Objectives

Technology Stack

Frontend

Backend

Database

Tools

Modules Implemented

Key Features

System Architecture

The application follows a Client–Server Architecture model:

How to Run the Project

Backend

Frontend

Team Members

Project Documentation

Project Report (PDF): Click here to open final year project pdf

Limitations

Future Enhancements

🔗 Reference Websites

🐾 Pet Care & Veterinary Platforms

Conclusion

HappyPaws demonstrates a modern full-stack web application using React and Spring Boot. The project effectively bridges academic learning with industry-level development practices by showcasing clean architecture, structured design, and real-world application workflows.

Helping Guides Below

🐾 HappyPaws Database Documentation!

Database Schema: clinic
Database Engine: MySQL 8.0+
Management Tool: MySQL Workbench

📋 1. Prerequisites

Before starting, ensure you have the following installed and ready:

📥 2. How to Import the Database

Follow these steps to restore the clinic database from the project dump files.

Step 1: Open Data Import

  1. Open MySQL Workbench.
  2. Connect to your local instance (e.g., Local instance MySQL).
  3. In the top menu bar, go to Server $\rightarrow$ Data Import.

Step 2: Select the Source Folder

  1. Under Import Options, select the radio button:

    🔘 Import from Dump Project Folder

  2. Click the ... button and browse to your project’s dump folder:
    • Select: .../HappyPaws/database/Dump
  3. Important: Do NOT select “Import from Self-Contained File”.

Step 3: Configure Target Schema

  1. Look at the “Default Schema to be Imported To” section.
  2. Check the dropdown list for clinic.
    • If clinic exists: Select it.
    • If clinic is MISSING:
      1. Click the New… button.
      2. Type clinic as the name.
      3. Click OK.
  3. Ensure clinic is selected in the dropdown.

Step 4: Execute Import

  1. In the Select Database Objects to Import box, click on clinic.
  2. Ensure all table checkboxes on the right side are checked.
  3. Verify the dropdown setting below is set to: Dump Structure and Data.
  4. Click the Start Import button (bottom right corner).

✅ 3. Verification

To verify the database is set up correctly:

  1. Go to the Schemas tab in the left Navigator panel.
  2. Right-click empty space $\rightarrow$ Refresh All.
  3. Expand clinic $\rightarrow$ Tables.
  4. Right-click pets (or any table) $\rightarrow$ Select Rows - Limit 1000.
  5. Success: You should see data populated in the results grid.

📤 4. How to Backup (Export)

If you make changes to the database and want to save a new backup:

  1. Go to Server $\rightarrow$ Data Export.
  2. In the left column, click the checkbox for clinic.
  3. Under Export Options:
    • Select Export to Dump Project Folder.
    • Choose the path to your .../HappyPaws/database/Dump folder.
  4. Check “Include Create Schema”.
  5. Click Start Export.

🛠️ 5. Troubleshooting Common Errors

Error Cause Solution
ERROR 1049: Unknown database ‘clinic’ The database schema has not been created yet. See Step 3: Click the New… button to create the clinic schema first.
Dump file not found / Access Denied The tool is looking for a single .sql file but you provided a folder. In Step 2, ensure you selected “Import from Dump Project Folder”.
Table ‘clinic.xyz’ doesn’t exist You imported data but not the table structure. Ensure Dump Structure and Data is selected in the dropdown menu.
Connection Refused MySQL Server is not running. Open Services (Windows) and start the MySQL80 service.

Backend API

Welcome to the backend API for HappyPaws PetClinic. This system is built with Spring Boot and features a secure, robust authentication system using Spring Security and JSON Web Tokens (JWT).

It serves as the foundation for the PetClinic application, managing Users (Admins, Vets, Owners), Pets, and medical history.

🚀 Key Features

🔑 Authentication Guide

The API is secured by default. To interact with it, you must Login first to get a “Key” (Token), and then use that Key to access data.

1. Default Admin Credentials

Use these credentials to test the system immediately or create new Vets:

2. How to Log In (Get Your Token)

This step proves your identity and provides you with a JWT Token.

Steps:

  1. Open Postman.
  2. Set request method to POST.
  3. In the Body tab, select raw -> JSON.
  4. Paste the credentials: 
    {
  "email": "admin@happypaws.com",
  "password": "admin123"
}
  5. Click Send.
  6. Copy the Response: The long string starting with eyJ... is your Token.

Sample Response:

{
    "role": "ROLE_ADMIN",
    "token": "eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJhZG1pbkBoYXBweXBhd3MuY29tIiwiaWF0IjoxNzY3ODUwNTA5LCJleHAiOjE3Njc4ODY1MDl9.qtR15YjS4HgPA56mjWp56NRFcy3VVXzX6KoTm1EtVc8"
}

3. How to Access Protected Data

Once you have the token, you can access locked pages (like Pets, Owners, Vets).

Steps:

  1. Create a new GET request in Postman.
  2. Go to the Authorization tab (under the URL bar).
  3. In the Type dropdown, select Bearer Token.
  4. In the Token field on the right, paste your JWT Token.
  5. Click Send.

Note: If you get a 403 Forbidden error, your token may be missing, expired, or you don’t have the correct Role (e.g., trying to access Admin routes as an Owner).

🛠️ Development Journey & Challenges Solved

We encountered and solved several real-world challenges while building this backend. Here is how we fixed them:

1. Role Prefix Mismatch (The “403 Forbidden” Mystery)

2. User-to-Profile Linking

3. Secure “Me” Endpoints

📂 Project Structure (Security)

This project follows a standard layered architecture:

❓ Troubleshooting

Common errors you might face while testing:

Error Cause Solution
403 Forbidden (Login) Wrong password or email. Check your JSON body for typos. Register the user if they don’t exist.
403 Forbidden (Data) Role Mismatch or Missing Token. Ensure you are using the correct Token (Admin vs Owner). Check SecurityConfig.
405 Method Not Allowed Wrong Request Type. Check if you are using GET instead of POST (or vice versa).
400 Bad Request Missing fields or duplicates. Check if the email is already registered.
ECONNREFUSED Server is down. Restart the Spring Boot application.

🏃‍♂️ How to Run

  1. Clone the repository.
  2. Update application.properties with your MySQL database details.
  3. Run the application: 
    mvn spring-boot:run
  4. Server will start on: http://localhost:8082

##🖥️ How Your React Frontend Will Use This Now your React code becomes super simple:

Hypothetical React Code
handleLogin(response) {
  localStorage.setItem('token', response.token); // Save the key

  if (response.role === 'ROLE_ADMIN') {
      navigate('/admin-dashboard'); // Redirect to secret Admin area
  } else if (response.role === 'ROLE_VET') {
      navigate('/vet-portal');      // Redirect to Vet area
  } else {
      navigate('/my-pets');         // Redirect to Owner area
  }
}

🗺️ HappyPaws Frontend Roadmap

This document describes how each frontend page connects to backend APIs and its purpose.

Page-to-API Mapping

Page Name Who sees it? API Used Purpose
Landing Page Everyone None (Static) Marketing, “Get Started” button, Clinic Info
Login / Register Everyone POST /auth/login Authenticate users & get Token
Owner Dashboard Owners GET /owners/me, GET /pets View My Profile and My Pets list
Pet Details Owners GET /pets/{id}, GET /visits See specific pet’s medical history
Add Pet Form Owners POST /pets Register a new pet
Admin Dashboard Admins GET /vets, POST /vets Hire new Vets, View all Owners
Vet Dashboard Vets GET /visits See upcoming appointments/patients

🐾 HappyPaws ML Service

This is the Machine Learning microservice for the HappyPaws Pet Care platform. It provides a real-time AI “Brain” that connects your React frontend to a custom-trained medical model.

🚀 Quick Start

1. Prerequisites

Ensure you have Python 3.11 or higher installed.

2. Installation

Open your terminal in the ml_service directory and run:

pip install flask flask-cors pandas scikit-learn numpy

⚠️ Note : Team Update the process of running and importing as Guide to Help!.