Connecting your machine to the SnPip database stored on in a google cloud instance.
-
log into https://console.cloud.google.com/ using the provided email bellow.
Email: snpip332022@gmail.com Password: my-secret-password -
In the navigation menu (the three bars located on the top left of the website) select SQL, this will bring up the snpip database.
- Select the snpip database (directly bellow the instance ID) This will bring you to the snpip db overview page.
- From the overview page select the connections tab
- Once on the connection page scroll down untill you reach ADD NETWORK (Nothing else needs to be interacted with)
-
Click on the ADD NETWORK button and input:
The network name in the name box Your machines ip address (IPV4) (which can be found here: https://whatismyipaddress.com/) in the ip box
-
Click the DONE button
-
Scroll down till you reach the blue SAVE button and save your newly created network. In the bottom left hand corner of the screen you will notice a window showing the time taken for the current operation to execute (in this case it will be saving you newtork), once a green check mark has appaared then the your network is saved.
Congratulations! You are now authorised to connect to the SnPip database.
Running the Web application!
- Open your command line or terminal
- Check the requirments.txt table for all the dependencies
- On command line/terminal install all the dependencies using the pip install command
- Once all the dependencies have been installed, cd into the web application folder
- Then run command > python main.py to host the Web application locally
- Search or click on http://127.0.0.1:5000/ to view web application