CRUD APP

CRUD APP

1. CRUD

   • Create
   • Read
   • Update
   • Delete

2. Self-determined criteria

3. Prescribed criteria

   • You must be able to CREATE, READ, UPDATE and DELETE records from your database
     • Must be able to READ a record
     • Must be able to UPDATE a record
     • Must be able to CREATE a record
   • You must have a minimum of 5 records in your CRUD application
   • Your results must be displayed in a Flask Web Application
   • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements

4. Changes you will make

5. Sample data

   • Read python- # Read all records @app.route("/read") def read(): conn = sqlite3.connect("database.db
   • Create Pyton @app.route("/create", methods=["GET", "POST"]) def create():
   • Delete Python - # Delete record @app.route("/delete/<int:id>") def delete(id):
   • Update Python - @app.route("/update/<int:id>", methods=["GET", "POST"]) def update(id):
   • html
   • age
     • 23
   • name
     • Alan Wan
   • email
     • wanalan@outlook.com
   • occupation
     • buisness owner
   • dob
     • 2001-09-05

6. user personal

   • Name- Alan Wan
   • Education - A student at Mansfield State High School
   • Goals-To create a business like his mum
   • Needs & Expectations - Alans wants to sell products on his mum’s website allowing his buyers to write their information allowing him to store information about what they want to buy and information about them
   • Age-14
   • Occupation-Currently is a part time worker at new shanghai
   • Interests-He is interested in Drop shipping
   • Frustrations- He is struggling to advertise his company as not many customers are entering it could be because he just uses posters and does not have a website to support it
   • Location- In Brisbane
   • User Problem Summary He is struggling to advertise his mums business so he wants a website to help support their business