UPC filler readme

Required Software, Libraries, and API:

-- Python 3.7: https://www.python.org/downloads/
-- MySQL Connector/Python : https://dev.mysql.com/downloads/connector/python/
-- httplib2: https://github.com/httplib2/httplib2
-- UPCitemDB: https://devs.upcitemdb.com/



To run this script do the follow:

1) Go into config.ini and set the proper database credentails.  If you are running a DB locally then enter the credentials you created for your local db.  Otherwise, obtain the proper credentials for clearDB within heroku.

2) As a suggestion, log into mysql workbench to view the last UPC value that was filled.

3) go inside upc_fill.py and edit the update query id value.  This will avoid making API calls for snacks that already have a UPC code.

4) Run upc_fill.py by typing "python upc_fill.py".  The program will start making API calls for snacks starting from the id that was entered.  If a 200 code is returned then the snack was found and will get updated , otherwise you will see a 404 code returned and the next snack's upc code will be searched for.

5) If you get 429 code that means you've exceeded the amount of calls allowed by upcitemdb API.  Keep track of the ID of the last snack that was filled and edit the ID in the search query (inside upc_fill.py ) again tomorrow to start from there.

*Note: you can ignore the python_mysql_config.py file as it simply reads and creates an object from the values of config.ini which then gets passed to mysql connector *

