Feat: Dr delete a cat

[notdanross]

Description

Modified categories table to hold a deleted property. Added SQL statements to handle updating the deleted category so that the client can stop "deleted" categories from rendering.

Fixes #16

Type of change

• [ ] New feature (non-breaking change which adds functionality)
• [ ] This change requires a documentation update

Testing Instructions

Please describe the tests required to verify your changes. Provide instructions so PR Tester can check functionality. Please also list any relevant details for your tests

git fetch --all git checkout dr-deleteCat

Run the following SQL queries:

Drop the old categories table: DROP TABLE "Categories";

Create updated table:

CREATE TABLE "Categories" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "label" varchar,
  "deleted" bit
);

Add new categories:

INSERT INTO Categories ('label', 'deleted') VALUES ('News', 0);
INSERT INTO Categories ('label', 'deleted') VALUES ('Toast', 0);
INSERT INTO Categories ('label', 'deleted') VALUES ('Baked beans', 0);

Checkout to client side branch to test

Checklist:

• [x] My code follows the style guidelines of this project
• [x] I have performed a self-review of my own code
• [ ] I have commented my code, particularly in hard-to-understand areas
• [x] My changes generate no new warnings or errors
• [x] I have added test instructions that prove my fix is effective or that my feature works