Skip to content

A Ruby/Sinatra web app for a vet surgery to manage registration and appointments via PostgreSQL CRUD operations. Built as a solo project on the CodeClan Professional Software Development course, Week 4/5

Notifications You must be signed in to change notification settings

peaky76/vet_management

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

71 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Paws & Claws Vet Surgery Project

A simple vet surgery app, built as an individual project as part of the CodeClan (Edinburgh) Professional Software Development Course (Week 5).

The app allows a vet surgery to

  • create a list of vets at the surgery, and create schedules for them
  • maintain a list of registered owners and their pets
  • maintain an inventory of treatments and products
  • manage appointments
  • record product sales to owners
  • record treatments for pets
  • track payments for those treatments and products

Getting Started

  • Clone the repo and save it to your local computer.
  • Create a local database in PostgreSQL and name it vet_surgery.
  • Navigate to the repo in your console.
  • Run the following, which will populate the db with seed data:
psql -d vet_surgery -f db/vet_surgery.sql
ruby seeds.rb

Prerequisites

You will need the following ruby gems installed:

Built With

  • PostgreSQL - Database
  • Ruby/Sinatra - MVC
  • HTML/CSS - Front end

Brief

The project was responding to the following brief:

A veterinary practice has approached you to build a web application to help them manage their animals and vets. A vet may look after many animals at a time. An animal is registered with only one vet.

MVP

  • The practice wants to be able to register / track animals. Important information for the vets to know is -
    • Name
    • Date Of Birth (use a VARCHAR initially)
    • Type of animal
    • Contact details for the owner
    • Treatment notes
  • Be able to assign animals to vets
  • CRUD actions for vets / animals - remember the user - what would they want to see on each View? What Views should there be?

Possible Extensions

  • Mark owners as being registered/unregistered with the Vet. unregistered owners won't be able to add any more animals.
  • If an owner has multiple animals we don't want to keep updating contact details separately for each pet. Extend your application to reflect that an owner can have many pets and to more sensibly keep track of owners' details (avoiding repetition / inconsistencies)
  • Handle check-in / check-out dates
  • Let the practice see all animals currently in the practice (today's date is between the check-in and check-out?)
  • Sometimes an owner does not know the DOB. Allow them to enter an age instead. Try and make sure this always up to date - ie if they visit again a year from now a 3 yr old dog is now 4.
  • Add extra functionality of your choosing - assigning treatments, a more comprehensive way of maintaining treatment notes over time. Appointments. Pricing / billing.

Acknowledgments

About

A Ruby/Sinatra web app for a vet surgery to manage registration and appointments via PostgreSQL CRUD operations. Built as a solo project on the CodeClan Professional Software Development course, Week 4/5

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published