CRUD

CRUD

1. Create

   • Creating records
     • at least 5 on website
     • connected to SQL
       • records pulled from SQL
       • SQL connected to webpages through Thonny
         • Thonny
           • Python code IDE
           • Backbone of webpages
           • Python
   • Gamertag column
   • Username column
   • Email column
   • Submit Button
     • follow criteria
       • Self-determined criteria
       • Prescribed Criteria
     • Username Column

2. Read

   • 5 records inputted
     • read webpage
       • connected to update and homepages
         • Connected through thonny
           • Python IDE
     • all 5 records can be read
   • User must be able to read all records on webpage
     • User can scroll on page to see all records
       • all 3 columns on each record
         • Gamertag Column
         • Username Column
         • Email Column

3. Update

   • All 3 columns can be updated
     • Gamertag Column
     • Email Column
   • Records updated in SQL and webpage
     • SQL connected to webpages and automatically updated
   • Update option must be confirmed
     • Confirmation button

4. Delete

   • Soft vs Hard Deleting
     • Soft Deletes (Flagging)
     • Hard Deletes (Permanent Removal)
     • Archiving Data
     • Legal Compliance
       • GDPR
         • General Data Protection Regulation
       • CCPA
         • California Consumer Privacy Act
   • Recovery Mechanisms
     • Undo/Redo Operations
     • Database Snapshots
     • Restore from Backups
     • Disaster Recovery Plans

5. Criteria

   • Prescribed Criteria
     • You must be able to CREATE, READ, UPDATE and DELETE records from your database
       • The webpage must have an option to create records
       • The webpage must have an option to read records
       • The webpage must have an update function
       • The webpage must have an option to delete records
     • Your results must be displayed in a Flask Web Application
       • Thonny must be utilised to code the website
       • Records must be pulled from an SQL database
       • CSS features must be used to make the Flask Web Application look visually appealing
       • User must have options to edit and delete the records
     • You must have a minimum of 5 records in your CRUD application
       • SQL database must have 5 records
       • Webpage must display all 5 records
       • User must be able to read all 5 records
       • User must be able to update all 5 records
       • User must be able to delete 5 records
     • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements E.g. A font or background colour
       • CSS will be used to change the background colour of webpage
       • CSS will be utilised to change the size of text
       • CSS will be utilised to change font
       • CSS will be utilised to change the colour of text
       • CSS will be utilised to create buttons
   • Self-Determined Criteria
     • You must have buttons on your webpage
       • Buttons must be clickable and functional
       • Clickable buttons must be coloured
       • Clickable buttons must change size when hovering over them