- Install Python
- Install Django, MySQL, MySQLClient
- Django
- You can use Anaconda for that
pip install django
- Mysql
- Linux
sudo apt-get install mysql-server
- Linux
- MySql Client
pip install mysqlclient
- Look at this tutorial to see how to run the project
python manage.py runserver
- Django
- Two options (create the database from Scratch
- Create the MySQL Database
mysql -u root -p < init_mysql.sql- OR
sudo mysql < init_mysql.sql
- Import Database
- TBD
- Create the MySQL Database
- Database login:
- user: lal
- password: ALLCSE305<3
- Create a django superuser
- python manage.py createsuperuser
- (Note that you have to use a good password for this)
- Messed up or did the setting up not work?
- Delete database and default mysql user:
mysql -u root -p < reset_mysql.sql- OR
sudo mysql < reset_mysql.sql
- Delete database and default mysql user:
- Convert database in MySQL to django models
python manage.py inspectdb
- Accessing the Admin Page
- Create a super user
python manage.py createsuperuser
- Visit http://127.0.0.1:8000/admin/
- Create a super user
- Adding an Item
- Visit http://127.0.0.1:8000/admin/
- Login
- Represents the interface for a customer to shop for items to add to the cart
- Item
- Review
- New Key: ReviewId
- Django does not support composite keys
- A rating can be an int from 0 to 5
- Customer
- We keep track of a customer's login session
- Dev Notes, you can find if a customer has been logged in by calling the loggedin() function <- right now returns a boolean if loggedin or not
- OR you can manually check the sessions attribute of each request
- Dev Notes, you can find if a customer has been logged in by calling the loggedin() function <- right now returns a boolean if loggedin or not
- Login Page with Cookies
- Register Page
- Items
- Reviews with login
- Login makes shopping cart
- Make sure you can't login twice
- update item quantities upon enacting a transaction
- Check for duplicate items in shopping cart
- Checkout flow -> Transaction
- edit quantity
- finish checkout/transaction/transactioncontents flow
- transaction/order history page
- testing!
- documentation
- presentation
- remove the shopping cart row in SQL created when you log in (no need for it, just display an empty shopping cart [logged in] or error [logged out]) - done (arjun)
- Shopping Cart Profile - almost done
- Edit quantity
- Added Delivery and Payments form - lise (need to do more checks for cookies)
- Create a detailed confirm order page w/ shopping cart - lise
- Customer Profile
- data stats maybe if we have time in this hacky project
- Revamp adminstration pages
- add images urls
- Add item description
- Notification bubbles when a form is submitted
- Add shopping cart icon to navbar