CRUD flask App

CRUD flask App

1. Terms

   • crud
     • Delete
     • Read
     • Update
     • Create
   • SQL
     • INSERT
     • SELECT
     • INSERT
     • UPDATE
   • Other variations include:
     • ABCD
     • CRUDL
     • BREAD
     • DAVE
     • CRAP

2. About

   • 1983
   • James Martin

3. Flask

   • About
     • Armin Ronacher
     • 2010
     • the idea was originally a April Fools Joke
   • A tool commonly used to provide tools, libraries, and technologies
   • Links python and html to make a website

4. Python

   • A general purpose coding language
   • 1991
   • Guido Van Rossum

5. Html

   • A standard markup language
   • W3C
   • 1993

6. css

   • A style sheet language
   • W3C
   • 1996

7. Task

   • criteria
     • prescribed
       • You must be able to CREATE, READ, UPDATE and DELETE records from your database
         • Develop a working CREATE button in the CRUD flask app
         • Develop a working READ button in the CRUD flask app
         • Develop a working UPDATE button in the CRUD flask app
         • Develop a working DELETE button in the CRUD flask app
       • Your results must be displayed in a Flask Web Application
         • Utilise sqlite3, python and html
         • Produce 5 or more record ideas
         • Create html interface to display data
         • Add the records into the database through the python and html
       • You must have a minimum of 5 records in your CRUD application
         • Utilise html, sqlite3 and python
         • Link the sqlite3 database with python thonny code to the html website interface
         • Create an html interface to display the data from the database
         • Add records into the database
       • You must apply CSS styling to your CRUD application that aligns with your user persona’s requirements
         • Utilise CSS and html
         • Create a design that aligns with user persona
         • Implement design with html elements
         • Implement design with CSS styling
     • self prescribed
       • Develop a cancel and confirm system for the delete function of the CRUD flask app
         • Utilise python and html
         • change buttons from “edit” and “delete” to “confirm” and “cancel”
         • Use python make the buttons work
   • You are to modify a data driven CRUD Web Application. Use HTML, Python, SQL in a Flask framework to modify the stimulus Web Application and meets your users needs.