CRUD APPLICATION

CRUD APPLICATION

1. Task

   • Self-Determined Criteria
     • Must be aesthetically well presented
   • Prescribed Criteria
     • You must be able to CREATE, READ, UPDATE and DELETE records from your database
     • Your results must be displayed in a Flask Web Application
     • You must have a minimum of 5 records in your CRUD application
     • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements E.g. A font or background colour
   • Make a CRUD Application

2. Testing Code Logic

   • Desk Checking
   • Algorithm
     • Psuedocode
       • START
       • END

3. User Requirements

   • Needs
     • Easy to navigate interface
     • Clear Display of Data
   • Frustrations
     • Complicated interfaces
     • Busy websites

4. Coding Options

   • Coding Language
     • Python
       • conn.commit()
     • HTML
       • <h1>....</h1>
     • CSS
       • font-family: "Times New Roman"
     • SQL
       • .mode table
       • SELECT * FROM records;

5. Coding Enviroment

   • Thonny
     • Python
     • Coding Area
     • Output area
   • SQLite
     • SQL
       • Tables displaying the records
   • Notepad++
     • HTML & CSS

6. Modifications (structure not design)

   • More SQL columns
     • Python needs to be changed to accomodate the new tables
       • The create and update functions will need to be edited

7. CREATE TABLE

   • CREATE TABLE records ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, email TEXT NOT NULL , hire_date DATE, telephone varchar);
     • id column
       • auto-increment
       • integer
     • name
       • text
     • email
       • text
     • hire_date
       • date
     • telephone
       • Varchar