Skip to content

BMcKiernan/DjangoDBProject

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 

Repository files navigation

DjangoDBProject


This website nolonger exists because I exceeded my free tier limit for the Amazon EC2 Elastic Compute instance and the AWS RDS instance I was using for the MySQL database.


Instructions to Run Project.


This project needs to be run in linux.

After cloning the repo change directory to webprojectfolder within the DjangoDBProject project folder

Type: source venviv/bin/activate if you see (venviv) sh4-$ ./PWD/ then you can just cd to webproject and type: "python manage.py runserver" and the the website should work you just have to hit CTRL and click on the link that appears in the terminal.

If source venviv/bin/activate doesn't work or python manage.py runserver doesn't work Then you have to create the virtualenv yourself on your computer. Instructions to create virutalenv yourself:

First remove the exisiting venviv dir with "rm -rf venviv" To create the virtualenv type "virtualenv venviv -p python3"

To activate the virtualenv type "source venviv/bin/activate"

To add necessary requirments -type "pip3 install -r requirments.txt"

To run the project locally - FROM PWD as ./webprojectfolder sh$- cd webproject sh$- python manage.py runserver

Then hold CTRL and click the link that is generated in the terminal

For after you've seen the project and want to exit the virutalenv just type "deactivate" in the terminal.

Features -

  1. Products

    The products button will take you to a list of products where you can click the filter button and you can filter the products by price and by name.

    You can also add a purchase from the admin part of the site but the reason I wanted to add a user based purchase feature is because when you create a user account (which will naturally not have admin privleges) and login you will be shown a new button which says User Data.

  2. User Data

    If you create and login as a new user you will have no User Data so this will be blank. But notice the cool feature where the User Data button shows only when you've been verified

    If you want to create a user and and create purchase history through the site, Login as a new user and then after going to the Products sections of the website make some purchases.

    You can then click Purchase History and you will see all the products the current user has purchased as well as the "branch" where the products were purchased.

  3. Log-in Features There is restrictions on creating passwords so they are secure and passwords are hashed and stored in my RDS so no one ever sees the actual passwords except the user.

There is a forgot password feature (which may be a little hard to see under the log in screen) and if you enter your email you will be emailed a link to reset your password. Because I couldn't set everything up on a ec2 server the email will just appear in the terminal where the website is running and you can click the link from there with CTRL.

This will redirect you to the reset password screen and you should just exit out of the tab you just left and after resetting your password you can log in from the new tab.

About

This is a dynamic website using the django web framework and connected to a MySQL database on an aws rds instance. The site was modeled after a bubbletea store where users could make user accounts, make purchases, and see their data appear on the website in real time. This project was for Rutgers 198:336 the Computer Science Database Course.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors