1.打開pythonanywhere建立一個mysite的Django專案，並在專案目錄下新增myapp，建立templates目錄。
2.修改mysite/settings.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 | """ Django settings for mysite project. Generated by 'django-admin startproject' using Django 5.0.6. For more information on this file, see https://docs.djangoproject.com/en/5.0/topics/settings/ For the full list of settings and their values, see https://docs.djangoproject.com/en/5.0/ref/settings/ """ from pathlib import Path # Build paths inside the project like this: BASE_DIR / 'subdir'. BASE_DIR = Path(__file__).resolve().parent.parent # Quick-start development settings - unsuitable for production # See https://docs.djangoproject.com/en/5.0/howto/deployment/checklist/ # SECURITY WARNING: keep the secret key used in production secret! SECRET_KEY = "django-insecure-9cul&t=+y&pax8q5=)95@403s!*d&a9bp@)iq1x%)%z6%!95x-" # SECURITY WARNING: don't run with debug turned on in production! DEBUG = True ALLOWED_HOSTS = ['cmlin.pythonanywhere.com'] # Application definition INSTALLED_APPS = [ "django.contrib.admin", "django.contrib.auth", "django.contrib.contenttypes", "django.contrib.sessions", "django.contrib.messages", "django.contrib.staticfiles", "myapp", ] MIDDLEWARE = [ "django.middleware.security.SecurityMiddleware", "django.contrib.sessions.middleware.SessionMiddleware", "django.middleware.common.CommonMiddleware", "django.middleware.csrf.CsrfViewMiddleware", "django.contrib.auth.middleware.AuthenticationMiddleware", "django.contrib.messages.middleware.MessageMiddleware", "django.middleware.clickjacking.XFrameOptionsMiddleware", ] ROOT_URLCONF = "mysite.urls" TEMPLATES = [ { "BACKEND": "django.template.backends.django.DjangoTemplates", "DIRS": [BASE_DIR / 'templates'], "APP_DIRS": True, "OPTIONS": { "context_processors": [ "django.template.context_processors.debug", "django.template.context_processors.request", "django.contrib.auth.context_processors.auth", "django.contrib.messages.context_processors.messages", ], }, }, ] WSGI_APPLICATION = "mysite.wsgi.application" # Database # https://docs.djangoproject.com/en/5.0/ref/settings/#databases DATABASES = { "default": { "ENGINE": "django.db.backends.sqlite3", "NAME": BASE_DIR / "db.sqlite3", } } # Password validation # https://docs.djangoproject.com/en/5.0/ref/settings/#auth-password-validators AUTH_PASSWORD_VALIDATORS = [ { "NAME": "django.contrib.auth.password_validation.UserAttributeSimilarityValidator", }, { "NAME": "django.contrib.auth.password_validation.MinimumLengthValidator", }, { "NAME": "django.contrib.auth.password_validation.CommonPasswordValidator", }, { "NAME": "django.contrib.auth.password_validation.NumericPasswordValidator", }, ] # Internationalization # https://docs.djangoproject.com/en/5.0/topics/i18n/ LANGUAGE_CODE = "en-us" TIME_ZONE = "UTC" USE_I18N = True USE_TZ = True # Static files (CSS, JavaScript, Images) # https://docs.djangoproject.com/en/5.0/howto/static-files/ STATIC_URL = "static/" # Default primary key field type # https://docs.djangoproject.com/en/5.0/ref/settings/#default-auto-field DEFAULT_AUTO_FIELD = "django.db.models.BigAutoField" # default static files settings for PythonAnywhere. # see https://help.pythonanywhere.com/pages/DjangoStaticFiles for more info MEDIA_ROOT = '/home/cmlin/mysite/media' MEDIA_URL = '/media/' STATIC_ROOT = '/home/cmlin/mysite/static' STATIC_URL = '/static/' STATICFILES_DIRS = [ BASE_DIR/'static', ] |
2.修改urls.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | """ URL configuration for mysite project. The `urlpatterns` list routes URLs to views. For more information please see: https://docs.djangoproject.com/en/5.0/topics/http/urls/ Examples: Function views 1. Add an import: from my_app import views 2. Add a URL to urlpatterns: path('', views.home, name='home') Class-based views 1. Add an import: from other_app.views import Home 2. Add a URL to urlpatterns: path('', Home.as_view(), name='home') Including another URLconf 1. Import the include() function: from django.urls import include, path 2. Add a URL to urlpatterns: path('blog/', include('blog.urls')) """ from django.contrib import admin from django.urls import path from myapp.views import index, peanut, tilapia urlpatterns = [ path("admin/", admin.site.urls), path('', index), path('peanut', peanut), path('tilapia', tilapia), ] |
3.修改myapp/views.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | from django.shortcuts import render import requests import json # Create your views here. def index(request): return render(request, "index.html", locals()) def peanut(request): r = requests.get('https://data.moa.gov.tw/Service/OpenData/FromM/FarmTransData.aspx') text = json.loads(r.text) rows = [] for row in text: if row['作物名稱'] is None: continue if '落花生' in row['作物名稱']: rows.append(row) return render(request, "peanut.html", locals()) def tilapia(request): r = requests.get('https://data.moa.gov.tw/Service/OpenData/FromM/AquaticTransData.aspx') text = json.loads(r.text) rows = [] for row in text: if row['魚貨名稱'] is None: continue if '吳郭魚' in row['魚貨名稱']: rows.append(row) return render(request, "tilapia.html", locals()) |
4.新增templates/index.html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | <!DOCTYPE html> <html lang="en"> <head> <title>水井井USR</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet"> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script> </head> <body> <nav class="navbar navbar-expand-sm bg-light"> <div class="container-fluid"> <ul class="navbar-nav"> <li class="nav-item"> <a class="nav-link" href="/peanut">落花生</a> </li> <li class="nav-item"> <a class="nav-link" href="tilapia">吳郭魚</a> </li> <li class="nav-item"> <a class="nav-link" href="#">Link 3</a> </li> </ul> </div> </nav> <center> <h1>113年USR Hub：雲林沿海偏鄉的社區共好實踐計畫－以水井村三生共好為例</h1> <iframe width="819" height="461" src="https://www.youtube.com/embed/86o-pZddrjM" title="113年USR Hub：雲林沿海偏鄉的社區共好實踐計畫－以水井村三生共好為例" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen> </iframe> </center> </body> </hrml> |
5.新增 templates/peanut.html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | <html> <head> <TITLE> 尚虎雲產銷平台 </TITLE> </head> <body> <center> <h1> 尚虎雲產銷平台 </h1> </center> {% for row in rows %} {% if forloop.first %} <table style='width:100%' border='1'> <caption><h2>落花生市場交易情形</h2></caption> <tr><th>交易日期</th><th>作物代號</th><th>作物名稱</th><th>市場代碼</th><th>市場名稱</th><th>上價</th><th>中價</th><th>下價</th><th>平均價</th><th>交易量</th></tr> {% endif %} <tr> <td><center>{{ row.交易日期 }}</center></td> <td><center>{{ row.作物代號 }}</center></td> <td><center>{{ row.作物名稱 }}</center></td> <td><center>{{ row.市場代號 }}</center></td> <td><center>{{ row.市場名稱 }}</center></td> <td><center>{{ row.上價 }}</center></td> <td><center>{{ row.中價 }}</center></td> <td><center>{{ row.下價 }}</center></td> <td><center>{{ row.平均價 }}</center></td> <td><center>{{ row.交易量 }}</center></td> </tr> {% if forloop.last %} </table> {% endif %} {% endfor %} </body> </html> |
6.新增templates/tilapia.html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | <html> <head> <TITLE> 尚虎雲產銷平台 </TITLE> </head> <body> <center> <h1> 尚虎雲產銷平台 </h1> </center> {% for row in rows %} {% if forloop.first %} <table style='width:100%' border='1'> <caption><h2>吳郭魚市場交易情形</h2></caption> <tr><th>交易日期</th><th>品種代碼</th><th>魚貨名稱</th><th>市場名稱</th><th>上價</th><th>中價</th><th>下價</th><th>平均價</th><th>交易量</th></tr> {% endif %} <tr> <td><center>{{ row.交易日期 }}</center></td> <td><center>{{ row.品種代碼 }}</center></td> <td><center>{{ row.魚貨名稱 }}</center></td> <td><center>{{ row.市場名稱 }}</center></td> <td><center>{{ row.上價 }}</center></td> <td><center>{{ row.中價 }}</center></td> <td><center>{{ row.下價 }}</center></td> <td><center>{{ row.平均價 }}</center></td> <td><center>{{ row.交易量 }}</center></td> </tr> {% if forloop.last %} </table> {% endif %} {% endfor %} </body> </html> |
.png)
.png)
.png)
.png)