Bill’s Breakfast!
-
Bill’s Breakfast is a full stack web application that was created using the python programming language, SQL, and flask. The site allows the business owner, Bill, to track customers through adding new or editing current ones on top of creating and editing current items in his bakery.
Bill can also track orders when he places them for a new or current guest through the orders page.
-
In the following section, I will describe step by step, on how I was able to create the front and back end of the web application.
As mentioned, tools such as python, SQL, and flask were used to develop the site.
-
The goal of the site was to be able learn critical skills in information infrastructure with the creation of an entire web application. Hosted through Indiana University’s database, the site allows users to see current data, in full time.
Skills learned - Front and back end programming, proficiency in other skills such as SQL, flask, Jinja and working with virtual environments through the Linux operating system.
-
With the knowledge now on being able to develop a database on the back end as well as design the application for users on the front end, I have been able to learn the skills necessary to create more projects.
Home Page
Iteration 1
The home page showcases a listing of current items that Bill has at his bakery. Although the list of items may be small, if Bill decides to up his arsenal, he can add more items through the items page, located in the navigation bar.
This was the first iteration of the home page where users were able to see what items were available to purchase. In later revisions, users would be able to add these items to a cart and create an order
Items page
Similar to the customers page, users are able to view items in the Items page located in the navigation bar. The purpose was of this page was to first create a functioning page where users can add or edit items which was added in the next iteration.
Customers Page
Within the same iteration, users were able to se current customers. At the time of creating the site, mock data was used and loaded through CSV files before being refactored to store the data in a SQL database through MariaDB
Users can see the name, email, and phone number of the customer in this first iteration.
Orders page
The orders page allows for users to all orders that were placed. As mentioned earlier, this iteration used mock data in the form of CSV files to show the data that is seen in the images. However, this iteration for the orders page specifically, allows users to click on one individual order and if there are other items linked to the same order ID, all items will show under the order ID alongside the customer name at the time of creating the order.
Iteration 2
Adding and editing customers
In the second iteration, there were two buttons added to the customers page. If users were to click on either, they would be directed to a form page to add a new customer or edit a current one.
Adding and Editing Items
Similar to the customers page, the items page was updated in the second iteration with two buttons that allows the user click either button where they would be directed to a form page to add a new item or edit a current one.
Final Iteration
Cart page
In the final iteration, the overall task was to create a cart page where users could add items and check out. The cart page itself would show two pages - the first being an empty cart where users would be prompted to add items from the home page to their cart and two - their cart would have items and they would be prompted to selected a customer to checkout with where they would be redirected to the orders page with a new order created
