WoW AH Averages deployed app live on Heroku
"View only" link to the WoW AH Averages Google Sheet
WoW AH Averages is a python terminal app that calculates the average prices of 8 different items on the World of Warcraft Auction House based on a users input of the prices. This can aid the user in setting prices on the items that will sell well but make a tidy profit.
- User Experience (UX)
- Design
- Technologies Used
- Deployment & Local Development
- Testing - External document here
- Credits
- I want the user to be able to enter the price of 8 items that have a high demand on the World of Warcraft auction house. These items are:
- Titansteel Bar
- Savory Deviate Delight
- Pygmy Oil
- Frozen Orb
- Frost Lotus
- Illusion Dust
- Eternal Fire
- Frostweave Cloth
- I then want the app to calculate the average prices using the last 5 entries for each of the 8 items, and show these average prices to the user.
- Using these averages should aid the user in setting a good price for each item. the prices will allow it to sell well, but still make a tidy profit in game.
I made a flowchart using LucidChart to map out what I wanted to happen in the terminal.
- User data entry for 8 different items.
- Validation on each data entry to make sure it is a whole number above 0.
- Data written to a google sheet.
- Averages for each item based on the last 5 entries of the sheet is calculated and displayed to the user.
- Add some different colours to the text to make things stand out and feel a bit more separated.
- Implement World of Warcrafts API to allow data entry from inside the game or even grab the required data from the game itself.
- Calculate and show the changing average to the user.
Python, Markdown
- Git - For version control.
- Github - To save and store all the files of the site.
- Gitpod - To write all the python. Also used to write the README.
- Google Drive API
- Google Sheets API
- LucidChart - To create a flowchart.
- Code Institute Github template - Used to help create the terminal that displays for users on the live page.
The app is deployed using Heroku. Visit the deployed app here.
To do this I:
- Logged into Heroku
- This leads to the dashboard. I then clicked on "New" on the right hand side and clicked "Create New App".
- I set my app name to 'wow-ah-averages' and the region to Europe. Then I clicked "Create App"
- On the app page. I clicked onto the "Settings" tab, then "reveal config vars".
- I added 2 config Vars. First was called "CREDS" with the value being copied directly from my entire CREDS.json file. Second was called "PORT" with the value of "8000" to ensure deployment would work correctly.
- I then clicked "Add Buildpack" and added Python, saving the changes after. I then clicked it again and added nodejs, saving changes again.
- I then clicked onto the "Deploy" tab.
- On the "Deployment Method" section, I clicked to connect to github and searched for the "wow-ah-averages" repository and connected it.
- Further down the page, I enabled automatic deployments so that Heroku would rebuild and deploy the app whenever changes are pushed to the github repository. There is an option below to manually build the app if that is preferred.
- Log in (or sign up) to Github.
- Go to the repository for this project, wow-ah-averages.
- Click the Fork button in the top right corner.
- Log in (or sign up) to GitHub.
- Go to the repository for this project, wow-ah-averages.
- Click on the code button, select whether you would like to clone with HTTPS, SSH or GitHub CLI and copy the link shown.
- Open the terminal in your code editor and change the current working directory to the location you want to use for the cloned directory.
- Type 'git clone' into the terminal and then paste the link you copied in step 3. Press enter.
Click here to view details on testing and bugs
This is a solo project created by myself.
There are a few different sites that I used to learn the required skills to develop this website.
- Code Institute - Used for python essential learning resources. They also provided the template that contained the terminal used by the user.
- Stack Overflow - Used to check over some errors I had.
- Google Developers - Used to help look up some API interactions.
- w3schools - Used to check over some of the python syntax.
- Tutorial by EyeHunts - Used to check on the differences between global and local variables.
Lines 1-13 was taken directly from the Code Institute 'Love Sandwiches' mini-project and modified to link up to my own projects API + worksheet.