search

jpriggs / Stockgenie

GNU General Public License v3.0
0 stars 0 forks source link

Create test web page #2

Closed psyrus closed 7 years ago

psyrus commented 7 years ago

To make sure that the website is functional, please create a hello world page that is accessible from the public internet

psyrus commented 7 years ago

@jpriggs Because in #5 you'll actually be setting up the tables you need and designing the database, for now just create a dummy table and pull some junk data from it for the test page. If you decide to use a framework other than Django in #3 then it all has to change anyway, so just use this task to get comfortable with setting up a table and grabbing data in python from it.

psyrus commented 7 years ago

Proposed Test Table Structure

Issue # Name Due date
1 Set up Heroku Account 2017/10/24
2 Create Test Web Page 2017/10/30
3 Research Python Frameworks 2017/11/4

And so on

jpriggs commented 7 years ago

Hello World! displays fine. As far as displaying database junk data, I don't really know how to do that. I attepmted to create a table and enter values into the database, but I'm not sure how to connect to the database locally or remotely.

https://boiling-savannah-56533.herokuapp.com/

psyrus commented 7 years ago

@jpriggs https://devcenter.heroku.com/articles/heroku-postgresql#pg-push-and-pg-pull Try syncing the remote db to your local one, then use psql in a pipenv shell, at which point you should be able to use regular sql syntax to create tables and add data

This one seems to have potential as well https://stackoverflow.com/a/23333798/5262905

Edit: Since Hello world works, you can feel free to delay the database work and close this issue, but I would recommend trying to get comfortable with the postgresql asap, so this is a good opportunity IMO

psyrus commented 7 years ago

The hello world does work (I checked) and you were able to set up a dummy table and insert data. This can be closed.