Working with the Database

To access data stored in the database, the VMSDatabase class.

An instance of this class is already initialised at the top of the main.cpp file. (VMSDatabase VMSDatabase;)

Functions

Function Name	Example	Available
getData(table)	VMSDatabase.getData("pets");	✅
printTable(table)	VMSDatabase.printTable("pets");	❌
addRecord(table, data)	VMSDatabase.addRecord("pets", {"Bob", "Pug", "3", "Has asthma", "1", "1"});	❌
deleteRecord(table, id)	VMSDatabase.deleteRecord("pets", "1")	❌

Table parameter

The table parameter is made easy with a set of short options for each table. It is passed as a single word string.

Valid strings

• pets - Pet Management
• owners - Owner Management
• appointments - Appointment Table
• staff - Staff Management

getData

This function is used to retrieve data from the database.

The table