[TOC] ## 定義模型(并新增一張表) ### 創建 APP `django-admin startapp TestModel ` 輸出的目錄結構 ``` HelloWorld |-- TestModel | |-- __init__.py | |-- admin.py | |-- models.py | |-- tests.py | `-- views.py ``` TestModel/models.py ```python from django.db import models # 類名代表了數據庫表名 class Test(models.Model): # 代表數據表中的字段(name) name = models.CharField(max_length=20) ``` > 注意:若沒有在主鍵,那么在生成文件中會自動創建主鍵 `settings.py`中找到`INSTALLED_APPS`這一項 ``` INSTALLED_APPS = ( 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'TestModel', # 添加此項 ) ``` ### 生成數據庫 ``` python manage.py makemigrations [TestModel] python manage.py migrate [TestModel] ``` ### 測試寫入數據庫 `urls.py`: ``` from django.conf.urls import * from . import testdb urlpatterns = [ url(r'^testdb$', testdb.testdb), ] ``` HelloWorld/HelloWorld/testdb.py ``` from django.http import HttpResponse from TestModel.models import Test # 數據庫操作 def testdb(request): test1 = Test(name='runoob') test1.save() return HttpResponse("<p>數據添加成功！</p>") ``` 訪問 : `http://127.0.0.1:8000/testdb` 生成數據庫 ### 打印sql ``` python manage.py sqlmigrate blog 0001 -0001即migrations目錄生成的id #輸出 CREATE TABLE "blog_article" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "title" varchar(32) NOT NULL, "content" text NULL); ``` ### 更新字段并同步數據庫 TestModel/models.py ``` from django.db import models #類名代表了數據庫表名 class Test(models.Model): # 代表數據表中的字段(name) name = models.CharField(max_length=20) age = models.IntegerField(default=0) # 新增 ``` 執行 ``` python manage.py makemigrations [TestModel] python manage.py migrate [TestModel] ```