This repo includes final project based on MySQL in Database and Implementation course (DATA130039.01) in School of Data Science @Fudan University.
- Python version: 3.8
- Django version: 3.2.1
- pymysql library version: 1.0.2
- pyecharts library version: 1.9.0
Install requirements with:
pip install -r requirements.txt-
Set up
DMS/settings.py:DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': '', # e.g. DMS 'USER': '', # e.g. root 'PASSWORD': '', # Your MySQL server password 'HOST': '127.0.0.1', 'PORT': '3306', } } ... EMAIL_HOST = 'smtp.xxx.com' # e.g. 'smtp.163.com' EMAIL_PORT = '25' EMAIL_HOST_USER = '' # e.g. 'xxxxxx@163.com' EMAIL_HOST_PASSWORD = '' # Password for the SMTP server, not your e-mail password
-
Apply migrations to your database (in command window) :
python manage.py makemigrations python manage.py migrate
-
Create super user :
python manage.py createsuperuser
-
Run scripts in
/utils/to get required data, and connect with your database./spider/cvpr2csv_withoutdate.py: CVPR data, and you can get ICCV / WACV in the same way/fake-users/fake-users.py: generate some lorem ipsum users/wordcloud/wc_for_year.py: generate word cloud images
You can skip this step and use the backup data we provided in
./static/data/(may be out of date)And don't forget to import data to the corresponding database, you can easily identify them by databases' names
-
Run server :
python manage.py runserver
-
Get started
-
Login
-
Register
-
E-mail check
-
Homepage, scroll down to get introductions
-
Library & Pagination
-
Search bar
-
Abstract & Download
-
Sidebar
-
Statistics - Author Ranking
-
Statistics - Paper Statistics
-
Statistics - Word Cloud
-
Collection
-
Admin
- Django documents Everything you need to know about Django
- W3schools Learn HTML / CSS / JS / Bootstrap
- Django ORM Query / CN Django making queries to MySQL
- Looka Logo maker
- Color Space Fancy color palettes generator
- Font Awesome Frequently used icons
- Django用户登录与注册系统-CSDN Start your first attempt














