Django入門教程（做個(gè)疫情數(shù)據(jù)報(bào)告）

pip install?Django

django-admin startproject duma

duma/
????manage.py
????duma/
????????__init__.py
????????settings.py
????????urls.py
????????asgi.py
????????wsgi.py

python?manage.py?runserver

Starting development server at http://127.0.0.1:8000/

python?manage.py?startapp ncov

ncov/
????__init__.py
????admin.py
????apps.py
????migrations/
????????__init__.py
????models.py
????tests.py
????views.py

from?django.http import?HttpResponse


def?index(request):
????return?HttpResponse('Hello, World!')

from?django.urls import?path

from?. import?views

urlpatterns = [
????path('', views.index, name='index'),
]

from?django.contrib import?admin
from?django.urls import?path, include

urlpatterns = [
????path('admin/', admin.site.urls),
????path('ncov/', include('ncov.urls')),

]

DATABASES = {
????'default': {
????????'ENGINE': 'django.db.backends.sqlite3',
????????'NAME': BASE_DIR / 'db.sqlite3',
????}
}

from?django.db import?models


class?CyStat(models.Model):
????stat_dt = models.CharField(max_length=10) # 日期
????cy_name = models.CharField(max_length=50) # 國家名稱
????confirm = models.IntegerField() # 累計(jì)確診
????dead = models.IntegerField() # 累計(jì)死亡
????heal = models.IntegerField() # 累計(jì)治愈
????today_confirm = models.IntegerField() # 現(xiàn)有確診
????today_new_confirm = models.IntegerField() # 新增確診

INSTALLED_APPS?= [
????'django.contrib.admin',
????'django.contrib.auth',
????'django.contrib.contenttypes',
????'django.contrib.sessions',
????'django.contrib.messages',
????'django.contrib.staticfiles',
????'ncov.apps.NcovConfig'??# 注冊(cè) ncov 應(yīng)用
]

python?manage.py?makemigrations ncov

Migrations 
for?'ncov':
??ncov/migrations/0001_initial.py
????- Create model CyStat

python?manage.py?sqlmigrate ncov 0001

BEGIN;
--
-- Create model CyStat
--
CREATE?TABLE?"ncov_cystat"?("id"?integer?NOT?NULL?PRIMARY KEY?AUTOINCREMENT, "stat_dt"?varchar(10) NOT?NULL, "cy_name"?varchar(50) NOT?NULL, "confirm"?integer?NOT?NULL, "dead"?integer?NOT?NULL, "heal"?integer?NOT?NULL, "today_confirm"?integer?NOT?NULL, "today_new_confirm"?integer?NOT?NULL);
COMMIT;

python?manage.py?migrate

sqlite3?db.sqlite3

sqlite>?.tables
auth_group django_admin_log 
auth_group_permissions django_content_type 
auth_permission django_migrations 
auth_user django_session 
auth_user_groups ncov_cystat 
auth_user_user_permissions

sqlite> insert into?ncov_cystat(stat_dt, cy_name, confirm, dead, heal, today_confirm, today_new_confirm) VALUES?("2021-09-03", "cn", 123169, 5685, 115024, 2460, 33);
sqlite> insert into?ncov_cystat(stat_dt, cy_name, confirm, dead, heal, today_confirm, today_new_confirm) VALUES?("2021-09-04", "cn", 123199, 5685, 115105, 2409, 30);
...

from?django.shortcuts import?render

from?.models import?CyStat


def?index(request):
????cy_stats = CyStat.objects.filter(cy_name='cn').order_by('-stat_dt')[:7]
????context = {
????????'cy_stats': cy_stats
????}

????return?render(request, 'ncov/index.html', context)

<h3>國內(nèi)疫情數(shù)據(jù)h3>

<table?border="1">
????<tr>
????????<td>日期td>
????????<td>現(xiàn)有確診td>
????????<td>新增確診td>
????tr>
????{% for stat in cy_stats %}
????<tr>
????????<td>?{{ stat.stat_dt }} td>
????????<td>?{{ stat.today_confirm }} td>
????????<td>?{{ stat.today_new_confirm }} td>
????tr>
????{% endfor %}
table>

from?django.http import?HttpResponse
from?django.shortcuts import?render
from?pyecharts.charts import?Line, Map
from?pyecharts import?options as?opts

from?.models import?CyStat


def?index(request):
????cy_stat = CyStat.objects.filter(cy_name='cn').order_by('-stat_dt')[:14]

????stat_list = [x.stat_dt for?x in?cy_stat]
????stat_list.reverse()

????today_confirm_list = [x.today_confirm for?x in?cy_stat]
????today_confirm_list.reverse()

????today_new_confirm_list = [x.today_new_confirm for?x in?cy_stat]
????today_new_confirm_list.reverse()

????c = (
????????Line()
????????.add_xaxis(stat_list)
????????.add_yaxis("現(xiàn)有確診", today_confirm_list)
????????.add_yaxis("新增確診", today_new_confirm_list)
????????.set_global_opts(title_opts=opts.TitleOpts(title="國內(nèi)疫情數(shù)據(jù)"))
????)
????return?HttpResponse(c.render_embed())

1、別再問我exe反編譯成Python腳本了！

2、再見Tkinter，這款GUI神器值得擁有！

3、爆強(qiáng)！直接把 Python 編寫的圖形程序打包為安卓 APP

4、為什么阿里巴巴/騰訊不去開發(fā)被卡脖子的工業(yè)軟件？

5、Windows重要功能被閹割，全球用戶怒噴數(shù)月后微軟終于悔改