{"id":49752,"date":"2023-01-29T23:13:05","date_gmt":"2023-10-01T01:31:23","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/"},"modified":"2024-04-29T12:08:39","modified_gmt":"2024-04-29T04:08:39","slug":"django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/","title":{"rendered":"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09"},"content":{"rendered":"

Django\u8fd9\u5c06\u662f\u6211\u4e2a\u4eba\u7684\u5907\u5fd8\u5f55\u3002<\/h2>\n

\u672c\u6b21\u6211\u4eec\u5c06\u603b\u7ed3\u4e00\u4e0b\u5173\u4e8eModel\u7684\u64cd\u4f5c\u3002<\/p>\n

\u5f00\u53d1\u73af\u5883<\/h2>\n

\u64cd\u4f5c\u7cfb\u7edf\uff1amac
\n\u7f16\u8f91\u5668\uff1avscode
\nPython\u7248\u672c\uff1a3.10.9
\nDjango\u7248\u672c\uff1a4.1.0<\/p>\n

\u521b\u5efa\u6a21\u578b\u7684\u57fa\u672c\u8bed\u6cd5<\/h3>\n
from<\/span> django.db<\/span> import<\/span> models<\/span>\r\n\r\nclass<\/span> Person<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    first_name<\/span>=<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>30<\/span>)<\/span>\r\n    last_name<\/span>=<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>30<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u521b\u5efa\u8fc1\u79fb\u6587\u4ef6<\/h3>\n
\u5728\u6267\u884c\u8fc1\u79fb\u64cd\u4f5c\u4e4b\u524d\uff0c\u9700\u8981\u521b\u5efa\u8fc1\u79fb\u6587\u4ef6\u3002\u8fc1\u79fb\u6587\u4ef6\u662f\u6307\u5c06model.py\u4e2d\u7684\u5185\u5bb9\u5904\u7406\u4e3a\u53ef\u4ee5\u5728\u6570\u636e\u5e93\u4e2d\u4fdd\u5b58\u7684\u5f62\u5f0f\u7684\u6587\u4ef6\u3002<\/p>\n
$ python manage.py makemigrations <\u30a2\u30d7\u30ea\u540d> --name <\u3064\u3051\u305f\u3044\u540d\u524d>\r\n<\/code><\/pre>\n
\u53ea\u9700\u8981\u8fd0\u884c python manage.py makemigrations \u5c31\u53ef\u4ee5\u4e86\u3002
\n\u5982\u679c\u60f3\u8981\u5728\u8fc1\u79fb\u6587\u4ef6\u5939\u4e2d\u521b\u5efa\u4e00\u4e2a\u6709\u610f\u4e49\u7684\u6587\u4ef6\u5939\u800c\u4e0d\u662f\u81ea\u52a8\u751f\u6210\u7684\u540d\u79f0\uff0c
\n\u53ef\u4ee5\u5728\u8fd0\u884c makemigrations \u540e\u52a0\u4e0a –name \u53c2\u6570\u3002<\/p>\n
\u6211\u642c\u5230\u6d77\u5916<\/h3>\n
$ python manage.py migrate <\u30a2\u30d7\u30ea\u540d>\r\n<\/code><\/pre>\n
\u5728VScode\u4e2d\u5982\u4f55\u67e5\u770b\u8868\u683c\u7684\u5185\u5bb9<\/h3>\n
\u6309\u4f4f\u201cCommand+Shift+P\u201d\uff0c \u7136\u540e\u8f93\u5165\u201csqlite open Datebase\u201d\uff0c\u7136\u540e\u9009\u62e9\u201csqlite\u201d\u9009\u9879\uff0c\u8fd9\u6837\u5c31\u4f1a\u5728vscode\u7684\u5de6\u4e0b\u89d2\u51fa\u73b0\u4e00\u4e2a\u540d\u4e3a\u201cSQLITE EXPLORER\u201d\u7684\u6807\u7b7e\u9875\u3002\u5728\u90a3\u91cc\uff0c\u53f3\u952e\u70b9\u51fb\u540e\u9009\u62e9\u201cShow Table ‘sqlite_master’\u201d\uff0c\u5c31\u53ef\u4ee5\u67e5\u770b\u5176\u4e2d\u7684\u5185\u5bb9\u3002<\/p>\n
\u5176\u4ed6\u64cd\u4f5c<\/h3>\n
$ python manage.py showmigrations <\u30a2\u30d7\u30ea\u540d>\r\n    #\u9069\u5fdc\u3055\u308c\u3066\u3044\u308b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3092\u898b\u308b\r\n$ python manage.py migrate <\u30a2\u30d7\u30ea\u540d> <\u623b\u308a\u305f\u3044\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u540d>\r\n    #\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u307e\u3067\u9069\u5fdc\u3055\u308c\u3066\u3044\u306a\u3044\u72b6\u614b\u306b\u3059\u308b\r\n$ python manage.py migrate <\u30a2\u30d7\u30ea\u540d> zero\r\n    #\u5168\u3066\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30d5\u30a1\u30a4\u30eb\u306e\u9069\u5fdc\u3092\u5916\u3059\r\n<\/code><\/pre>\n
\u5982\u679c\u5c06\u6587\u4ef6\u6062\u590d\u5230\u672a\u5e94\u7528\u72b6\u6001\uff0c\u8bf7\u786e\u4fdd\u8fd8\u5220\u9664\u4e86\u4f4d\u4e8emigrations\u6587\u4ef6\u5939\u4e2d\u672a\u5e94\u7528\u7684\u6587\u4ef6\u3002<\/p>\n
\u4e3b\u8981\u9886\u57df\u6e05\u5355<\/h3>\n
\n
field\u540d\u6982\u8981BooleanField\u8ad6\u7406\u578b\u3001True\u3068False\u3092\u5165\u308c\u3089\u308c\u308bCharField\u6587\u5b57\u5217\u578b\u3002VARCHAR\u3068\u3057\u3066\u30ab\u30e9\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b\u3002max_length\u3067\u9577\u3055\u3092\u6307\u5b9a\u3059\u308bDateField,DatetimeField\u65e5\u4ed8\u578b\u3001\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u578bEmailField\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3092\u683c\u7d0d\u3059\u308b\u3002\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3042\u308a\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067VARCHAR\uff08254\uff09FileField\u30d5\u30a1\u30a4\u30eb\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u306e\u969b\u306e\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u683c\u7d0d\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067VARCHAR(100)DecimalField\u6b63\u78ba\u306a\u6570\u5024\u3092\u683c\u7d0d\u3055\u308c\u308bIntegerField,FloatField\u6574\u6570\u578b(INTEGER)\u3001\u6d6e\u52d5\u5c0f\u6570\u70b9(FLOAT)\u3092\u683c\u7d0d\u3055\u308c\u308bTextField\u9577\u3044\u6587\u5b57\u5217\u3092\u5165\u308c\u308b\u3002TEXT\u578b\u3068\u3057\u3066\u30ab\u30e9\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308bURLFieldURL\u3092\u5165\u308c\u308b\u3002VARCHAR(200)\u3068\u3057\u3066\u30ab\u30e9\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b<\/div>\n<\/div>\n
\u5728\u5236\u4f5c\u6a21\u578b\u65f6\u5b66\u5230\u7684\u65b0\u4e1c\u897f<\/h3>\n
from<\/span> django.db<\/span> import<\/span> models<\/span>\r\nfrom<\/span> django.utils<\/span> import<\/span> timezone<\/span>\r\n\r\nclass<\/span> Person<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    email<\/span> =<\/span> models<\/span>.<\/span>EmailField<\/span>(<\/span>db_index<\/span>=<\/span>True<\/span>)<\/span>#index\u3092\u306f\u308b\u3000\u3068\u3044\u3046\u9ad8\u901f\u5316\u306e\u51e6\u7406\r\n#\u5168\u3066\u306bdb_index=True\u3068\u3059\u308b\u3068\u30e1\u30e2\u30ea\u3092\u55b0\u3046\u306e\u3067\u691c\u7d22\u3057\u305f\u3044\u9805\u76ee\u306b\u3060\u3051\u8a2d\u5b9a\u3059\u308b\u3068\u26aa\ufe0e\r\n<\/span>    create_at<\/span> =<\/span>models<\/span>.<\/span>DateTimeField<\/span>(<\/span>default<\/span> =<\/span>timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>)<\/span>\r\n#\u30c7\u30d5\u30a9\u30eb\u30c8\u8a2d\u5b9a\u3092\u3059\u308b\u3068\u767b\u9332\u6642\u306e\u6642\u9593\u3092\u5165\u308c\u3089\u308c\u308b\r\n<\/span><\/code><\/pre>\n
\u4f7f\u5f97\u53ef\u4ee5\u5728\u7ba1\u7406\u754c\u9762\u4e0a\u67e5\u770b\u5df2\u521b\u5efa\u7684\u6a21\u578b\u3002<\/h3>\n
from<\/span> django.contrib<\/span> import<\/span> admin<\/span>\r\nfrom<\/span> .models<\/span> import<\/span> Person<\/span>\r\n\r\nadmin<\/span>.<\/span>site<\/span>.<\/span>register<\/span>(<\/span>Person<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u5143\u4fe1\u606f\u9009\u9879<\/h3>\n
Meta\u6307\u7684\u662f\u5143\u7c7b\uff0c\u7528\u4e8e\u5b9a\u4e49\u7c7b\u7684\u884c\u4e3a\u3002<\/p>\n
from<\/span> django.db<\/span> import<\/span> models<\/span>\r\nfrom<\/span> django.utils<\/span> import<\/span> timezone<\/span>\r\nimport<\/span> pytz<\/span> #timezone\u3092\u8a2d\u5b9a\u3059\u308b\u30e2\u30b8\u30e5\u30fc\u30eb\r\n<\/span>\r\nclass<\/span> BaseMeta<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span> #\u62bd\u8c61\u30af\u30e9\u30b9\r\n<\/span>    create_at<\/span> =<\/span> models<\/span>.<\/span>DateTimeField<\/span>(<\/span>default<\/span>=<\/span>timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>(<\/span>pytz<\/span>.<\/span>timezone<\/span>(<\/span>'<\/span>Asia\/Tokyo<\/span>'<\/span>)))<\/span>\r\n    update_at<\/span> =<\/span> models<\/span>.<\/span>DateTimeField<\/span>(<\/span>default<\/span>=<\/span>timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>(<\/span>pytz<\/span>.<\/span>timezone<\/span>(<\/span>'<\/span>Asia\/Tokyo<\/span>'<\/span>)))<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        abstract<\/span> =<\/span> True<\/span> #! 1.\u62bd\u8c61\u30af\u30e9\u30b9(abstract)\u3068\u3057\u3066\u5b9a\u7fa9\u3059\u308b\u305f\u3081\u30e1\u30bf\u30af\u30e9\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\r\n<\/span>\r\n\r\nclass<\/span> Person<\/span>(<\/span>BaseMeta<\/span>):<\/span>#! 2.\u5171\u901a\u306e\u30ab\u30e9\u30e0\u3092\u6301\u3061\u305f\u3044\u3068\u304d\u62bd\u8c61\u30af\u30e9\u30b9\u3092\u7d99\u627f\u3059\u308b\r\n<\/span>    first_name<\/span>=<\/span>models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>30<\/span>)<\/span>\r\n    last_name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>30<\/span>)<\/span>\r\n    birthday<\/span> =<\/span> models<\/span>.<\/span>DateField<\/span>(<\/span>default<\/span>=<\/span>'<\/span>1900-01-01<\/span>'<\/span>)<\/span>\r\n    email<\/span> =<\/span> models<\/span>.<\/span>EmailField<\/span>(<\/span>db_index<\/span>=<\/span>True<\/span>)<\/span>#!index\u3092\u306f\u308b\u3000\u3068\u3044\u3046\u9ad8\u901f\u5316\u306e\u51e6\u7406\r\n<\/span>    salary<\/span> =<\/span> models<\/span>.<\/span>FloatField<\/span>(<\/span>null<\/span>=<\/span>True<\/span>)<\/span>\r\n    memo<\/span> =<\/span> models<\/span>.<\/span>TextField<\/span>()<\/span>\r\n    web_site<\/span> =<\/span> models<\/span>.<\/span>URLField<\/span>(<\/span>null<\/span>=<\/span>True<\/span>,<\/span>blank<\/span> =<\/span> True<\/span>)<\/span>\r\n    # create_at =models.DateTimeField(default =timezone.now) #! \u7d99\u627f\u3057\u305f\u30ab\u30e9\u30e0\u3092\u4f7f\u3046\u305f\u3081\u3053\u3061\u3089\u306f\u524a\u9664\r\n<\/span>    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>person<\/span>'<\/span> #!\u30c6\u30fc\u30d6\u30eb\u540d\u3092person\u306b\u8a2d\u5b9a\r\n<\/span>        index_together<\/span> =<\/span> [[<\/span>'<\/span>first_name<\/span>'<\/span>,<\/span>'<\/span>last_name<\/span>'<\/span>]]<\/span> #!\u4e8c\u3064\u30bb\u30c3\u30c8\u3067\u691c\u7d22\u3059\u308b\u969b\u306b\u9ad8\u901f\u5316\u3067\u304d\u3066\u4fbf\u5229\r\n<\/span>        ordering<\/span> =<\/span> [<\/span>'<\/span>salary<\/span>'<\/span>]<\/span> #DB\u304b\u3089\u53d6\u308a\u51fa\u3059\u969b\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306eorder\u300c\u9806\u756a\u300d\u3092\u8a2d\u5b9a\r\n<\/span>        #\u964d\u9806\u306b\u3059\u308b\u3068\u304d\u306f['-salary']\u3068\u3059\u308b\r\n<\/span>\r\n    def<\/span> __str__<\/span>(<\/span>self<\/span>):<\/span>\r\n        return<\/span> f<\/span>'<\/span>{<\/span>self<\/span>.<\/span>first_name<\/span>}<\/span> {<\/span>self<\/span>.<\/span>last_name<\/span>}<\/span>'<\/span> #!\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u305f\u969b\u306b\u308f\u304b\u308a\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u540d\u524d\u3092\u8a2d\u5b9a\r\n<\/span><\/code><\/pre>\n
\u4f5c\u4e3a\u53e6\u4e00\u4e2aMeta\u9009\u9879\uff0c
\n\u5982\u679c\u5c06unique_together=[[‘first_name’,’last_name’]]\u8bbe\u7f6e\u4e3a\u4e00\u7ec4\uff0c
\n\u8fd8\u53ef\u4ee5\u914d\u7f6e\u5b57\u6bb5\u4e3aUNIQUE\u3002<\/p>\n
\u8bf7\u53c2\u8003Django\u5b98\u65b9\u7f51\u7ad9\u83b7\u53d6\u66f4\u8be6\u7ec6\u7684\u4fe1\u606f\u3002<\/p>\n
\u53ef\u4ee5\u4f7f\u7528\u4e09\u79cd\u65b9\u6cd5\u5c06\u6570\u636e\u63d2\u5165\u5230\u6570\u636e\u5e93\u4e2d\u3002<\/h3>\n
#1. \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306esave\u30e1\u30be\u30c3\u30c8\uff08DB\u306b\u540c\u3058\u3082\u306e\u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u304dDB\u306b\u633f\u5165\u3001\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u66f4\u65b0\r\n<\/span>web_site<\/span>=<\/span>Website<\/span>(<\/span>url<\/span>=<\/span>'<\/span>www.sample.com<\/span>'<\/span>,<\/span>name<\/span>=<\/span>'<\/span>sample<\/span>'<\/span>)<\/span>\r\nweb_site<\/span>.<\/span>save<\/span>()<\/span> #Website\u3068\u3044\u3046\u30af\u30e9\u30b9\u3067\u4f5c\u3089\u308c\u305fweb_site\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092save\u3059\u308b\r\n<\/span>\r\n#2. \u30af\u30e9\u30b9\u30e1\u30be\u30c3\u30c8\u306ecreate\u30e1\u30be\u30c3\u30c8(DB\u306b\u540c\u3058\u3082\u306e\u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u304dDB\u306b\u633f\u5165\u3001\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u30a8\u30e9\u30fc\r\n<\/span>Website<\/span>.<\/span>objects<\/span>.<\/span>create<\/span>(<\/span>\r\n    url<\/span> =<\/span> '<\/span>www.sample.com<\/span>'<\/span>,<\/span> name<\/span> =<\/span> '<\/span>sample<\/span>'<\/span>\r\n)<\/span> #\u5b58\u5728\u3057\u305f\u5834\u5408IntegrityError\u767a\u751f\r\n<\/span>\r\n#3. get_or_create\u30e1\u30be\u30c3\u30c8(DB\u306b\u540c\u3058\u3082\u306e\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u4f5c\u6210\u3057\u3066\u8fd4\u3059\u3002\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u305d\u306e\u3082\u306e\u3092\u8fd4\u3059\r\n<\/span>obj<\/span>,<\/span>created<\/span> =<\/span> Website<\/span>.<\/span>objects<\/span>.<\/span>get_or_create<\/span>(<\/span>url<\/span>=<\/span>'<\/span>www.sample.com<\/span>'<\/span>,<\/span>name<\/span>=<\/span>'<\/span>sample<\/span>'<\/span>)<\/span>\r\n#2\u3064\u5909\u6570\u304c\u8fd4\u3063\u3066\u304f\u308b\u3002obj\u306b\u306f\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u3092\u3002created\u306b\u306f\u5b58\u5728\u3057\u306a\u304f\u3066\u4f5c\u3089\u308c\u305f\u5834\u5408\u306fTrue\u304c\u306f\u3044\u308a\u3001\r\n#\u4f5c\u6210\u3057\u306a\u304b\u3063\u305f\u3068\u304d\u306fFalse\u304c\u306f\u3044\u308b\r\n<\/span><\/code><\/pre>\n
\u8bf7\u5c1d\u8bd5\u5c06\u6570\u636e\u5b9e\u9645\u63d2\u5165\u5230\u6570\u636e\u5e93\u4e2d\u3002<\/h3>\n
\u5728\u4e0emanage.py\u76f8\u540c\u7684\u76ee\u5f55\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3amain.py\u7684\u6587\u4ef6\u3002<\/p>\n
#! django\u306e\u8a2d\u5b9a\u3092\u8aad\u307f\u8fbc\u3093\u3067DB\u306b\u4fdd\u5b58\u3059\u308b\r\n<\/span>import<\/span> os<\/span>\r\n\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Person<\/span>\r\n\r\n#\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\r\n<\/span>p<\/span> =<\/span> Person<\/span>(<\/span>\r\n    first_name<\/span> =<\/span> '<\/span>Taro<\/span>'<\/span>,<\/span>\r\n    last_name<\/span> =<\/span> '<\/span>Sato<\/span>'<\/span>,<\/span>\r\n    birthday<\/span> =<\/span> '<\/span>2000-01-01<\/span>'<\/span>,<\/span>\r\n    email<\/span> =<\/span> '<\/span>aa@example.com<\/span>'<\/span>,<\/span>\r\n    salary<\/span>=<\/span>None<\/span>,<\/span>\r\n    memo<\/span>=<\/span>'<\/span>memo taro<\/span>'<\/span>,<\/span>\r\n    web_site<\/span> =<\/span> '<\/span>https:\/\/www.com<\/span>'<\/span>,<\/span>\r\n)<\/span>\r\n#\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092save\r\n<\/span>p<\/span>.<\/span>save<\/span>()<\/span>\r\n\r\n#classmethod create\r\n<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>create<\/span>(<\/span>\r\n    first_name<\/span> =<\/span> '<\/span>Jiro<\/span>'<\/span>,<\/span>\r\n    last_name<\/span> =<\/span> '<\/span>Ito<\/span>'<\/span>,<\/span>\r\n    email<\/span> =<\/span> '<\/span>bb@example.com<\/span>'<\/span>,<\/span>\r\n    salary<\/span> =<\/span> 2000<\/span>,<\/span>\r\n    memo<\/span>=<\/span>'<\/span>class method\u5b9f\u884c<\/span>'<\/span>,<\/span>\r\n    web_site<\/span>=<\/span>None<\/span>,<\/span>\r\n)<\/span>\r\n\r\n#get_or_create(\u53d6\u5f97or\u4f5c\u6210)\r\n<\/span>obj<\/span>,<\/span>created<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>get_or_create<\/span>(<\/span>\r\n    first_name<\/span> =<\/span> '<\/span>Saburo<\/span>'<\/span>,<\/span>\r\n    last_name<\/span> =<\/span> '<\/span>Ito<\/span>'<\/span>,<\/span>\r\n    #birthday\u306fdefault\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u305f\u3081\u8a18\u8ff0\u3057\u306a\u3044\u5834\u5408\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u304c\u306f\u3044\u308b\r\n<\/span>    email<\/span> =<\/span> '<\/span>bb@example.com<\/span>'<\/span>,<\/span>\r\n    salary<\/span> =<\/span> 2000<\/span>,<\/span>\r\n    memo<\/span>=<\/span>'<\/span>class method\u5b9f\u884c<\/span>'<\/span>,<\/span>\r\n    web_site<\/span>=<\/span>None<\/span>,<\/span>\r\n)<\/span>\r\n\r\nprint<\/span>(<\/span>obj<\/span>)<\/span> #models.py\u3067\u8a2d\u5b9a\u3057\u305fdef __str__(self)\u306e\u540d\u524d\u3067\u8fd4\u308b\r\n<\/span>print<\/span>(<\/span>created<\/span>)<\/span> #\u4f5c\u3089\u308c\u305f\u5834\u5408\u306fTrue\u3001\u3059\u3067\u306b\u5b58\u5728\u3057\u3066\u3044\u308b\u5834\u5408\u306fFalse\r\n<\/span><\/code><\/pre>\n
\u5728\u521b\u5efa\u6587\u4ef6\u540e\uff0c\u53f3\u952e\u5355\u51fbmain.py\u6587\u4ef6\u2192\u9009\u62e9\u5728\u7ec8\u7aef\u4e2d\u8fd0\u884c\uff0c\u6570\u636e\u5c06\u4fdd\u5b58\u5728\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n
\u8bf7\u8bb0\u4f4f\uff0c\u5728\u6570\u636e\u5e93\u4e2d\uff0cNull\u548c\u7a7a\u767d\u662f\u4e0d\u540c\u7684\u3002<\/p>\n
\u4ece\u6570\u636e\u5e93\u4e2d\u8fdb\u884cSELECT\u7684\u4e09\u79cd\u65b9\u6cd5\uff08\u83b7\u53d6\uff09<\/h3>\n
\u5728\u4e0emanage.py\u76f8\u540c\u7684\u76ee\u5f55\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aselect_sample.py\u7684\u6587\u4ef6\uff0c\u7528\u4e8e\u83b7\u53d6\u6570\u636e\u3002<\/p>\n
#\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\r\n#Django\u306e\u8a2d\u5b9a\u3092\u8aad\u307f\u8fbc\u3080\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Person<\/span>\r\n\r\n#\u5168\u3066\u53d6\u5f97\r\n<\/span>persons<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()<\/span>\r\nfor<\/span> person<\/span> in<\/span> persons<\/span>:<\/span>\r\n    print<\/span>(<\/span>person<\/span>.<\/span>id<\/span>,<\/span>person<\/span>,<\/span>person<\/span>.<\/span>salary<\/span>)<\/span>\r\n    \r\n#\uff11\u4ef6\u3060\u3051\u53d6\u5f97\r\n# person = Person.objects.get(first_name='Taro') #\u8907\u6570\u53d6\u5f97\u3067\u304d\u308b\u304b\u3089\u30a8\u30e9\u30fc\u306b\r\n# person = Person.objects.get(first_name='taro') #\uff11\u4ef6\u3082\u7372\u5f97\u3067\u304d\u306a\u3044\u6642\u3082\u30a8\u30e9\u30fc\u306b\r\n<\/span>person<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>1<\/span>)<\/span> #\u4e3b\u30ad\u30fc\u306f\u5fc5\u305a\uff11\u4ef6\u306a\u306e\u3067\u53d6\u5f97\u3067\u304d\u308b\r\n<\/span>print<\/span>(<\/span>person<\/span>.<\/span>id<\/span>,<\/span>person<\/span>)<\/span>\r\n\r\n#filter(\u7d5e\u308a\u8fbc\u307f\u3001\u30a8\u30e9\u30fc\u306b\u306a\u3089\u306a\u3044\u3001\u8907\u6570\u53d6\u5f97\u53ef)\r\n<\/span>persons<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>first_name<\/span>=<\/span>'<\/span>Taro<\/span>'<\/span>).<\/span>all<\/span>()<\/span>\r\n\r\nprint<\/span>(<\/span>persons<\/span>[<\/span>0<\/span>].<\/span>email<\/span>)<\/span> #\u914d\u5217\u306a\u306e\u3067\u3053\u306e\u5f62\u3067\u53d6\u308a\u51fa\u305b\u308b\r\n<\/span>for<\/span> person<\/span> in<\/span> persons<\/span>:<\/span>\r\n    print<\/span>(<\/span>person<\/span>.<\/span>id<\/span> ,<\/span> person<\/span>)<\/span> #for\u6587\u3067\u3082\u53d6\u308a\u51fa\u305b\u308b\r\n<\/span><\/code><\/pre>\n
\u8bf7\u53c2\u8003\u4e00\u4e0bQiita\uff08\u67e5\u8be2\u96c6\uff09\u3002<\/h3>\n
Django\u9006\u5f15\u304d\u5c0f\u6284\uff08QuerySet\u90e8\u5206\uff09<\/p>\n
\u4f60\u77e5\u9053objects\u672c\u8d28\u4e0a\u662f\u6a21\u578b\u7ba1\u7406\u5668\u5417\uff1f.all()\u548c.first()\u662f\u65b9\u6cd5\u54e6\uff01\u4e0b\u9762\u7b80\u5355\u89e3\u91ca\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528Django objects\uff0c\u53ef\u4ee5\u4f5c\u4e3a\u53c2\u8003\u3002<\/p>\n
\u4ece\u6570\u636e\u5e93\u4e2d\u63d0\u53d6\uff08get_object_or_404 get_list_or_404\uff09<\/h3>\n
from<\/span> django.shortcuts<\/span> import<\/span> get_object_or_404<\/span>\r\nget_object_or_404<\/span>\r\n#\u6307\u5b9a\u3057\u305f\u30e2\u30c7\u30eb\u3092\u547c\u3073\u51fa\u3057\u3001get\u3092\u884c\u3046\u3002\u5024\u3092\u53d6\u5f97\u3067\u304d\u306a\u304b\u3063\u305f\u5834\u5408raise Http404\u3092\u9001\u51fa\u3059\u308b\r\n#\u4f8b)item = get_object_or_404(Items,pk=id)\r\n<\/span>\r\nget_list_or_404<\/span>\r\n#\u6307\u5b9a\u3057\u305f\u30e2\u30c7\u30eb\u3092\u547c\u3073\u51fa\u3057\u3001filter\u3092\u884c\u3046\u3002\u540c\u4e0a\r\n#\u30ea\u30b9\u30c8\u3067\u53d6\u308a\u51fa\u3059\u305f\u3081\u30ea\u30b9\u30c8\u306e\u4e2d\u8eab\u304c\u306a\u3044\u72b6\u614b\u3067\u53d6\u308a\u51fa\u3059\u3068\uff14\uff10\uff14\u3092\u8fd4\u3059\r\n#\u4f8b)items = get_list_or_404(Items,id__gt=2) id\u304c\uff12\u3088\u308a\u5927\u304d\u3044\u3082\u306e\u3092\u53d6\u308a\u51fa\u3059\r\n<\/span><\/code><\/pre>\n
Django View\u7684\u5e94\u7528
\n\u5728\u8fd9\u91cc\u6982\u62ec\u4e86\u6709\u5173\u9519\u8bef\u5904\u7406\u7684\u5185\u5bb9<\/p>\n
\u6570\u636e\u7684\u66f4\u65b0<\/h3>\n
\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a update_sample.py \u7684\u6587\u4ef6\uff0c\u7528\u4e8e\u5728\u4e0e manage.py \u76f8\u540c\u7684\u76ee\u5f55\u4e2d\u66f4\u65b0\u6570\u636e\u3002<\/p>\n
#\u30c7\u30fc\u30bf\u306e\u66f4\u65b0(update)\r\n<\/span>import<\/span> os<\/span>\r\n\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Person<\/span>\r\nfrom<\/span> django.utils<\/span> import<\/span> timezone<\/span>\r\nimport<\/span> pytz<\/span>\r\n\r\n#1\u4ef6\u3060\u3051\u53d6\u5f97\u3057\u3066birthday\u3068update_at\u3092\u66f4\u65b0\u3059\u308b\r\n<\/span>person<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>id<\/span>=<\/span>1<\/span>)<\/span>\r\nperson<\/span>.<\/span>birthday<\/span>=<\/span>'<\/span>2001-09-01<\/span>'<\/span>\r\nperson<\/span>.<\/span>update_at<\/span>=<\/span>timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>(<\/span>pytz<\/span>.<\/span>timezone<\/span>(<\/span>'<\/span>Asia\/Tokyo<\/span>'<\/span>))<\/span>\r\nperson<\/span>.<\/span>save<\/span>()<\/span> #save\u3067\u66f4\u65b0\u5b8c\u4e86\r\n<\/span>\r\n#first_name\u304c'Taro'\u3067\u3042\u308b\u30c7\u30fc\u30bf\u3092\u5168\u3066\u66f4\u65b0\u3059\u308b\r\n<\/span>persons<\/span> =<\/span> Person<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>first_name<\/span>=<\/span>'<\/span>Taro<\/span>'<\/span>).<\/span>all<\/span>()<\/span>\r\nfor<\/span> person<\/span> in<\/span> persons<\/span>:<\/span>\r\n    person<\/span>.<\/span>first_name<\/span> =<\/span> person<\/span>.<\/span>first_name<\/span>.<\/span>lower<\/span>()<\/span>\r\n    person<\/span>.<\/span>update_at<\/span> =<\/span> timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>(<\/span>pytz<\/span>.<\/span>timezone<\/span>(<\/span>'<\/span>Asia\/Tokyo<\/span>'<\/span>))<\/span>\r\n    person<\/span>.<\/span>save<\/span>()<\/span>\r\n#\u4e0a\u8a18\u306e\u3084\u308a\u65b9\u306f\u4e00\u3064\u4e00\u3064\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u3001\u4f55\u4e07\u4ef6\u3068\u3082\u306a\u308b\u3068\u51e6\u7406\u304c\u9045\u304f\u306a\u3063\u3066\u3057\u307e\u3046\r\n<\/span>\r\n#\u4e0b\u8a18\u306fupdate\u3067\u4e00\u6c17\u306b\u5b9f\u884c\u3059\u308b\u305f\u3081\u3053\u3061\u3089\u306e\u307b\u3046\u304c\u51e6\u7406\u304c\u8efd\u304f\u306a\u308a\u304a\u3059\u3059\u3081\r\n<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>first_name<\/span>=<\/span>'<\/span>Saburo<\/span>'<\/span>).<\/span>update<\/span>(<\/span>\r\n    web_site<\/span>=<\/span>'<\/span>http:\/\/sample.jp<\/span>'<\/span>,<\/span>\r\n    update_at<\/span> =<\/span> timezone<\/span>.<\/span>datetime<\/span>.<\/span>now<\/span>(<\/span>pytz<\/span>.<\/span>timezone<\/span>(<\/span>'<\/span>Asia\/Tokyo<\/span>'<\/span>))<\/span>\r\n)<\/span>\r\n<\/code><\/pre>\n
\u5220\u9664\u6570\u636e<\/h3>\n
\u521b\u5efa\u4e00\u4e2a\u540d\u4e3adelete_sample.py\u7684\u6587\u4ef6\uff0c\u7528\u4e8e\u5728\u4e0emanage.py\u76f8\u540c\u7684\u76ee\u5f55\u4e2d\u5220\u9664\u6570\u636e\u3002<\/p>\n
#\u30c7\u30fc\u30bf\u306e\u524a\u9664(delete)\r\n<\/span>import<\/span> os<\/span>\r\n\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Person<\/span>\r\n\r\n#filter\u3092\u4f7f\u3063\u3066\u6761\u4ef6\u306b\u3042\u3063\u305f\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\r\n<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>first_name<\/span>=<\/span>'<\/span>Saburo<\/span>'<\/span>).<\/span>delete<\/span>()<\/span>\r\nPerson<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>first_name<\/span> =<\/span> '<\/span>taro<\/span>'<\/span>,<\/span>birthday<\/span>=<\/span>'<\/span>2001-09-01<\/span>'<\/span>).<\/span>delete<\/span>()<\/span>\r\n\r\n#\u5168\u4ef6\u524a\u9664\r\n<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>().<\/span>delete<\/span>()<\/span>\r\n<\/code><\/pre>\n
\u8ba9\u6a21\u578b\u62e5\u6709\u5916\u952e<\/h3>\n
\u901a\u8fc7\u5728\u8868\u4e2d\u6dfb\u52a0\u5916\u952e\uff08ForeignField\uff09\uff0c\u5b9e\u73b0\u8868\u4e4b\u95f4\u7684\u5173\u8054\u3002<\/p>\n
#\u5916\u90e8\u30ad\u30fc\u7df4\u7fd2\r\n<\/span>class<\/span> Students<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    age<\/span> =<\/span> models<\/span>.<\/span>IntegerField<\/span>()<\/span>\r\n    major<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    school<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Schools<\/span>'<\/span>,<\/span> on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>\r\n    )<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>students<\/span>'<\/span>\r\n        \r\nclass<\/span> Schools<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    prefecture<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Prefectures<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>\r\n    )<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>schools<\/span>'<\/span>\r\n        \r\nclass<\/span> Prefectures<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span>=<\/span>models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span>=<\/span>'<\/span>prefectures<\/span>'<\/span>\r\n<\/code><\/pre>\n
\u5b66\u751f\u8868\u4e0e\u5b66\u6821\u8868\u4e4b\u95f4\u5b58\u5728\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\uff0c
\n\u5b66\u6821\u8868\u4e0e\u53bf\u8868\u4e5f\u662f\u4e00\u5bf9\u591a\u7684\u5173\u7cfb\u3002<\/p>\n
\u4f53\u9a8c\u5bf9\u4e8eon_delete=models.CASCADE\u7684\u6548\u679c<\/h3>\n
\u5728\u4e0emanage.py\u76f8\u540c\u7684\u5c42\u7ea7\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aforeignkey_sample.py\u7684\u6587\u4ef6\u3002<\/p>\n
#\u5916\u90e8\u30ad\u30fc\u306e\u7df4\u7fd2\r\n<\/span>import<\/span> os<\/span>\r\n\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>,<\/span>Schools<\/span>,<\/span>Prefectures<\/span>\r\n\r\nprefectures<\/span> =<\/span> [<\/span>'<\/span>\u6771\u4eac<\/span>'<\/span>,<\/span>'<\/span>\u5927\u962a<\/span>'<\/span>]<\/span>\r\nschools<\/span> =<\/span> [<\/span>'<\/span>\u6771\u9ad8\u6821<\/span>'<\/span>,<\/span>'<\/span>\u897f\u9ad8\u6821<\/span>'<\/span>,<\/span>'<\/span>\u5317\u9ad8\u6821<\/span>'<\/span>,<\/span>'<\/span>\u5357\u9ad8\u6821<\/span>'<\/span>]<\/span>\r\nstudents<\/span> =<\/span> [<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>,<\/span>'<\/span>\u4e8c\u90ce<\/span>'<\/span>,<\/span>'<\/span>\u4e09\u90ce<\/span>'<\/span>]<\/span>\r\n\r\n#\u30c7\u30fc\u30bf\u306e\u7528\u610f\r\n<\/span>def<\/span> insert_records<\/span>():<\/span>\r\n    for<\/span> prefecture_name<\/span> in<\/span> prefectures<\/span>:<\/span>\r\n        prefecture<\/span> =<\/span> Prefectures<\/span>(<\/span>\r\n            name<\/span> =<\/span> prefecture_name<\/span>\r\n        )<\/span>\r\n        prefecture<\/span>.<\/span>save<\/span>()<\/span>\r\n        for<\/span> school_name<\/span> in<\/span> schools<\/span>:<\/span>\r\n            school<\/span> =<\/span> Schools<\/span>(<\/span>\r\n                name<\/span> =<\/span> school_name<\/span>,<\/span>\r\n                prefecture<\/span> =<\/span> prefecture<\/span>\r\n                #\u5de6\u306eprefecture\u306fmodels.py\u3067\u5b9a\u7fa9\u3057\u305f\u5916\u90e8\u30ad\u30fc\u306eprefecture\r\n<\/span>                #\u53f3\u306eprefecture\u306ffor\u5185\u3067\u4f5c\u6210\u3057\u305f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306eprefecture\r\n<\/span>                #\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u7d10\u4ed8\u3051\u3055\u308c\u308b\r\n<\/span>            )<\/span>\r\n            school<\/span>.<\/span>save<\/span>()<\/span>\r\n            for<\/span> student_name<\/span> in<\/span> students<\/span>:<\/span>\r\n                student<\/span> =<\/span> Students<\/span>(<\/span>\r\n                    name<\/span> =<\/span> student_name<\/span>,<\/span>age<\/span>=<\/span>17<\/span>,<\/span>\r\n                    major<\/span> =<\/span> '<\/span>\u7269\u7406<\/span>'<\/span>,<\/span>school<\/span> =<\/span> school<\/span>\r\n                )<\/span>\r\n                student<\/span>.<\/span>save<\/span>()<\/span>\r\n#\u30c7\u30fc\u30bf\u3092\u4e00\u65e6\u4fdd\u5b58\u3055\u305b\u3066\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8              \r\n# insert_records()\r\n<\/span>\r\n#\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3059\u308b\u305f\u3081\u306e\u95a2\u6570\r\n<\/span>def<\/span> select_students<\/span>():<\/span>\r\n    students<\/span> =<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()<\/span>\r\n    for<\/span> student<\/span> in<\/span> students<\/span>:<\/span>\r\n        print<\/span>(<\/span>student<\/span>.<\/span>id<\/span>,<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>age<\/span>,<\/span>student<\/span>.<\/span>major<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>id<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>id<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span>\r\n#student.school.name\u3084student.school.prefeture.name\u306e\u3088\u3046\u306b\u5916\u90e8\u30ad\u30fc\u3092\u4f1d\u3063\u3066\u7d10\u4ed8\u3051\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u306b\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\r\n<\/span>        \r\n# select_students()\r\n<\/span>\r\n#\u6771\u9ad8\u6821\u3092\u524a\u9664\u3059\u308b\u3068\u540c\u6642\u306bstudent\u304c3\u4eba\u524a\u9664\u3055\u308c\u308b\r\n<\/span>Schools<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>id<\/span>=<\/span>1<\/span>).<\/span>delete<\/span>()<\/span>\r\n# select_students()\r\n#prefecture\u306e'\u6771\u4eac'\u3092\u524a\u9664\u3059\u308b\u3068\u6771\u4eac\u3092\u6301\u3064\u30c7\u30fc\u30bf\u304c\u3059\u3079\u3066\u524a\u9664\u3055\u308c\u308b\r\n<\/span>Prefectures<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u6771\u4eac<\/span>'<\/span>).<\/span>delete<\/span>()<\/span>\r\nselect_students<\/span>()<\/span>\r\n<\/code><\/pre>\n
\u9664\u4e86on_delete=models.CASCADE\u4e4b\u5916\u7684\u9009\u9879<\/h3>\n
school<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        #\u89aa\u3092\u524a\u9664\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30a8\u30e9\u30fc\u304c\u3067\u308b\r\n<\/span>        '<\/span>Schools<\/span>'<\/span>,<\/span> on_delete<\/span>=<\/span>models<\/span>.<\/span>PROTECT<\/span>\r\n        #\u89aa\u3092\u53c2\u7167\u3057\u3066\u3044\u308b\u9805\u76ee\u306f\u3059\u3079\u3066Null\u3092\u3044\u308c\u308b\r\n<\/span>        '<\/span>Schools<\/span>'<\/span>,<\/span> on_delete<\/span>=<\/span>models<\/span>.<\/span>SET_NULL<\/span>,<\/span>null<\/span>=<\/span>True<\/span>\r\n)<\/span>\r\n<\/code><\/pre>\n
\u9664\u4e86on_delete=models.CASCADE\u4ee5\u5916\u7684\u9009\u98792\uff0cRESTRICT\u3002<\/h3>\n
\u5f53\u5220\u9664 Schools \u65f6\uff0c\u4f1a\u53d7\u5230 Students \u7684 RESTRICT \u4fdd\u62a4\uff0c
\n\u800c\u5f53\u5220\u9664 Prefecture \u65f6\uff0c\u7531\u4e8e\u4f7f\u7528\u4e86 CASCADE \u8fdb\u884c\u5173\u8054\uff0c\u6240\u6709\u4e0b\u5c5e\u90fd\u5c06\u88ab\u540c\u65f6\u5220\u9664\u3002<\/p>\n
\u5982\u679c\u53c2\u7167\u5bf9\u8c61(\u7236\u6bcd)\u4e0e\u53c2\u7167\u5bf9\u8c61(\u7956\u7236\u6bcd)\u4e4b\u95f4\u4f7f\u7528CASCADE\u8fdb\u884c\u5173\u8054\uff0c\u90a3\u4e48\u5f53\u5220\u9664\u7956\u7236\u6bcd\u65f6\uff0c\u7236\u6bcd\u4e0e\u5b50\u5973\u4e5f\u4f1a\u4e00\u8d77\u88ab\u5220\u9664\u3002<\/p>\n
#\u5916\u90e8\u30ad\u30fc\u7df4\u7fd2\r\n<\/span>class<\/span> Students<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    age<\/span> =<\/span> models<\/span>.<\/span>IntegerField<\/span>()<\/span>\r\n    major<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    #\u3053\u3053\u304b\u3089\u30dd\u30a4\u30f3\u30c8\r\n<\/span>    school<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Schools<\/span>'<\/span>,<\/span> on_delete<\/span>=<\/span>models<\/span>.<\/span>RESTRICT<\/span> #\r\n<\/span>    )<\/span>\r\n    prefecture<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Prefectures<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span> #\r\n<\/span>    )<\/span>\r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>students<\/span>'<\/span>\r\n        \r\nclass<\/span> Schools<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    prefecture<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Prefectures<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span> #\r\n<\/span>    )<\/span>\r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>schools<\/span>'<\/span>\r\n        \r\nclass<\/span> Prefectures<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span>=<\/span>models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>20<\/span>)<\/span>\r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span>=<\/span>'<\/span>prefectures<\/span>'<\/span>\r\n<\/code><\/pre>\n
def<\/span> insert_records<\/span>():<\/span>\r\n    for<\/span> prefecture_name<\/span> in<\/span> prefectures<\/span>:<\/span>\r\n        prefecture<\/span> =<\/span> Prefectures<\/span>(<\/span>\r\n            name<\/span> =<\/span> prefecture_name<\/span>\r\n        )<\/span>\r\n        prefecture<\/span>.<\/span>save<\/span>()<\/span>\r\n        for<\/span> school_name<\/span> in<\/span> schools<\/span>:<\/span>\r\n            school<\/span> =<\/span> Schools<\/span>(<\/span>\r\n                name<\/span> =<\/span> school_name<\/span>,<\/span>\r\n                prefecture<\/span> =<\/span> prefecture<\/span>\r\n                #\u5de6\u306eprefecture\u306fmodels.py\u3067\u5b9a\u7fa9\u3057\u305f\u5916\u90e8\u30ad\u30fc\u306eprefecture\r\n<\/span>                #\u53f3\u306eprefecture\u306ffor\u5185\u3067\u4f5c\u6210\u3057\u305f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306eprefecture\r\n<\/span>                #\u3053\u3046\u3059\u308b\u3053\u3068\u3067\u7d10\u4ed8\u3051\u3055\u308c\u308b\r\n<\/span>            )<\/span>\r\n            school<\/span>.<\/span>save<\/span>()<\/span>\r\n            for<\/span> student_name<\/span> in<\/span> students<\/span>:<\/span>\r\n                student<\/span> =<\/span> Students<\/span>(<\/span>\r\n                    name<\/span> =<\/span> student_name<\/span>,<\/span>age<\/span>=<\/span>17<\/span>,<\/span>\r\n                    major<\/span> =<\/span> '<\/span>\u7269\u7406<\/span>'<\/span>,<\/span>school<\/span> =<\/span> school<\/span>,<\/span>\r\n                    #RESTRICT\u306e\u5834\u5408\u306e\u307f\u8ffd\u52a0 \r\n<\/span>                    prefecture<\/span> =<\/span> prefecture<\/span>,<\/span> #id\u3092\u6301\u305f\u305b\u308b\u305f\u3081\u3053\u3061\u3089\u3092\u8ffd\u52a0\r\n<\/span>                )<\/span>\r\n                student<\/span>.<\/span>save<\/span>()<\/span>\r\n\r\n\r\n\r\n<\/code><\/pre>\n
OneToOneField\u7528\u4e8e\u5c06\u8868\u683c\u4e4b\u95f4\u8fdb\u884c\u4e00\u5bf9\u4e00\u7684\u5173\u8054<\/h3>\n
#OneToOne\r\n<\/span>class<\/span> Places<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    address<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>80<\/span>)<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>places<\/span>'<\/span>\r\n        \r\nclass<\/span> Restaurant<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    place<\/span> =<\/span> models<\/span>.<\/span>OneToOneField<\/span>(<\/span> #\r\n<\/span>        Places<\/span>,<\/span>\r\n        on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>,<\/span>\r\n        primary_key<\/span>=<\/span>True<\/span> #\r\n<\/span>    )<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>restaurants<\/span>'<\/span>\r\n<\/code><\/pre>\n
\u5728\u4e0emanage.py\u76f8\u540c\u7684\u5c42\u7ea7\u4e0b\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aonetoone_sample.py\u7684\u6587\u4ef6\u3002<\/p>\n
#OneToOne\r\n#import\u7b49\u7701\u7565\u3002\u4e0a\u8a18\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u540c\u3058\r\n<\/span>\r\nplaces<\/span> =<\/span> [<\/span>\r\n    (<\/span>'<\/span>Motomachi<\/span>'<\/span>,<\/span>'<\/span>Yokohama<\/span>'<\/span>),(<\/span>'<\/span>Tsukiji<\/span>'<\/span>,<\/span>'<\/span>Tokyo<\/span>'<\/span>)<\/span>\r\n]<\/span>\r\nrestaurants<\/span>=<\/span>[<\/span>'<\/span>restaurantA<\/span>'<\/span>,<\/span>'<\/span>restaurantB<\/span>'<\/span>]<\/span>\r\n\r\nfor<\/span> place_name<\/span>,<\/span>place_address<\/span> in<\/span> places<\/span>:<\/span>\r\n    p<\/span> =<\/span> Places<\/span>(<\/span>name<\/span>=<\/span>place_name<\/span>,<\/span> address<\/span>=<\/span>place_address<\/span>)<\/span>\r\n    p<\/span>.<\/span>save<\/span>()<\/span>\r\n    for<\/span> restaurant_name<\/span> in<\/span> restaurants<\/span>:<\/span>\r\n        r<\/span> =<\/span> Restaurant<\/span>(<\/span>place<\/span>=<\/span>p<\/span>,<\/span> name<\/span>=<\/span>restaurant_name<\/span>)<\/span>\r\n        r<\/span>.<\/span>save<\/span>()<\/span>\r\n        #>>> \u7d50\u679c\u306frestaurants\u30c6\u30fc\u30d6\u30eb\u306b\u306fplace_id1,2\u3068restaurantB\u306e\uff12\u3064\u306e\u30c7\u30fc\u30bf\u3057\u304b\u5165\u3089\u306a\u3044\r\n<\/span>        #\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306esave\u30e1\u30be\u30c3\u30c8\u306f\r\n<\/span>        #DB\u306b\u540c\u3058\u3082\u306e\u304c\u5b58\u5728\u3057\u306a\u3044\u3068\u304d\u306fDB\u306b\u4fdd\u5b58\u3001\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u66f4\u65b0\u306a\u306e\u3067\u4eca\u56de\u306fplace\u304c\r\n<\/span>        #primarykey\u3067\u540c\u3058\u3082\u306e\u306a\u306e\u3067name\u304crestaurantB\u306b\u66f4\u65b0\u3055\u308c\u308b\r\n<\/span>    \r\n        Restaurant<\/span>.<\/span>objects<\/span>.<\/span>create<\/span>(<\/span>\r\n            place<\/span> =<\/span>p<\/span>,<\/span>name<\/span>=<\/span>restaurant_name<\/span>\r\n        )<\/span>\r\n        #\u30af\u30e9\u30b9\u30e1\u30be\u30c3\u30c8\u306ecreate\u30e1\u30be\u30c3\u30c8\u3092\u4f7f\u3046\u5834\u5408\r\n<\/span>        #\u3053\u3061\u3089\u3082DB\u306b\u3059\u3067\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3092\u8fd4\u3059\u306e\u3067\u4fdd\u5b58\u306f\u3067\u304d\u306a\u3044\r\n<\/span><\/code><\/pre>\n
OneToOne\u662f\u4e00\u79cd\u7528\u4e8e\u5c06\u8868\u4e4b\u95f4\u5173\u8054\u7684\u5b57\u6bb5\uff0c\u56e0\u6b64\u5bf9\u4e8e\u4e00\u4e2a\u5176\u4ed6\u8868\u7684id\uff0c\u5b83\u53ea\u80fd\u6301\u6709\u4e00\u4e2a\u6570\u636e\u3002<\/p>\n
\u591a\u5bf9\u591a<\/h3>\n
\u7528\u4e8e\u5173\u8054\u591a\u5bf9\u591a\u5173\u7cfb\u8868\u7684\u5b57\u6bb5
\n\u5728\u5185\u90e8\uff0c\u521b\u5efa\u4e86\u53e6\u4e00\u4e2a\u65b0\u8868\u4ee5\u5728\u4e24\u4e2a\u8868\u4e4b\u95f4\u8fdb\u884c\u5173\u8054\u3002\u901a\u8fc7\u4f7f\u7528\u8be5\u8868\u8fdb\u884c\u5173\u8054\u3002<\/p>\n
#ManyToMany\r\n<\/span>class<\/span> Authors<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    \r\n    def<\/span> __str__<\/span>(<\/span>self<\/span>):<\/span>\r\n        return<\/span> self<\/span>.<\/span>name<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>authors<\/span>'<\/span>\r\n        \r\nclass<\/span> Books<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    authors<\/span> =<\/span> models<\/span>.<\/span>ManyToManyField<\/span>(<\/span>Authors<\/span>)<\/span> #\r\n<\/span>    \r\n    def<\/span> __str__<\/span>(<\/span>self<\/span>):<\/span>\r\n        return<\/span> self<\/span>.<\/span>name<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>books<\/span>'<\/span>\r\n<\/code><\/pre>\n
\u5728manage.py\u7684\u540c\u4e00\u5c64\u76ee\u5f55\u4e2d\u521b\u5efa\u4e00\u4e2a\u540d\u4e3amanytomany_sample.py\u7684\u6587\u4ef6\u3002<\/p>\n
#manytomany\r\n#import\u7b49\u7701\u7565\r\n<\/span>\r\n#\u30c7\u30fc\u30bf\u306e\u633f\u5165\r\n<\/span>def<\/span> insert_books<\/span>():<\/span>\r\n    book1<\/span> =<\/span> Books<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Book1<\/span>'<\/span>)<\/span>\r\n    book2<\/span> =<\/span> Books<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Book2<\/span>'<\/span>)<\/span>\r\n    book3<\/span> =<\/span> Books<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Book3<\/span>'<\/span>)<\/span>\r\n    book1<\/span>.<\/span>save<\/span>()<\/span>\r\n    book2<\/span>.<\/span>save<\/span>()<\/span>\r\n    book3<\/span>.<\/span>save<\/span>()<\/span>\r\n    \r\ndef<\/span> insert_authors<\/span>():<\/span>\r\n    author1<\/span> =<\/span> Authors<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Author1<\/span>'<\/span>)<\/span>\r\n    author2<\/span> =<\/span> Authors<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Author2<\/span>'<\/span>)<\/span>\r\n    author3<\/span> =<\/span> Authors<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Author3<\/span>'<\/span>)<\/span>\r\n    author1<\/span>.<\/span>save<\/span>()<\/span>\r\n    author2<\/span>.<\/span>save<\/span>()<\/span>\r\n    author3<\/span>.<\/span>save<\/span>()<\/span>\r\n\r\n#\u95a2\u6570\u306e\u5b9f\u884c\r\n<\/span>insert_books<\/span>()<\/span>\r\ninsert_authors<\/span>()<\/span>\r\n\r\n# \u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3057\u3066\r\n<\/span>book1<\/span> =<\/span> Books<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>1<\/span>)<\/span>\r\nbook3<\/span> =<\/span> Books<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>3<\/span>)<\/span>\r\nauthor1<\/span> =<\/span> Authors<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>1<\/span>)<\/span>\r\nauthor2<\/span> =<\/span> Authors<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>2<\/span>)<\/span>\r\nauthor3<\/span> =<\/span> Authors<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>pk<\/span>=<\/span>3<\/span>)<\/span>\r\n\r\n#book1\u306badd\u3067\u8ffd\u52a0\u3059\u308b\r\n<\/span>book1<\/span>.<\/span>authors<\/span>.<\/span>add<\/span>(<\/span>author1<\/span>,<\/span>author2<\/span>)<\/span>\r\nprint<\/span>(<\/span>book1<\/span>.<\/span>authors<\/span>.<\/span>all<\/span>())<\/span>\r\n\r\nbook3<\/span>.<\/span>authors<\/span>.<\/span>add<\/span>(<\/span>author1<\/span>,<\/span>author2<\/span>,<\/span>author3<\/span>)<\/span>\r\nprint<\/span>(<\/span>book3<\/span>.<\/span>authors<\/span>.<\/span>all<\/span>())<\/span>\r\n\r\nprint<\/span>(<\/span>book1<\/span>.<\/span>authors<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u53ef\u4ee5\u7528add\u65b9\u6cd5\u8fdb\u884c\u6dfb\u52a0\uff0c\u4e0d\u9700\u8981save\u3002
\nauthors\u62e5\u6709\u591a\u672c\u4e66\u3002
\nbooks\u4e5f\u62e5\u6709\u591a\u4f4d\u4f5c\u8005\u7684\u5173\u7cfb\u3002<\/p>\n
\u4ece\u5408\u5e76\u7684\u8bb0\u5f55\u4e2d\u63d0\u53d6\u6570\u636e<\/h3>\n
\u5728\u9009\u62e9\u662f\u5904\u7406\u4e00\u4e2a\u8fd8\u662f\u5904\u7406\u591a\u4e2a\u5bf9\u8c61\u65f6\uff0c\u63d0\u53d6\u65b9\u5f0f\u4e0d\u540c\u3002
\n\u5728manage.py\u7684\u540c\u4e00\u5c42\u7ea7\u4e0b\u521b\u5efaselect_foreign_table.py\u6587\u4ef6\u3002<\/p>\n
#! \u7d50\u5408\u3057\u305f\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u51fa\u3057\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>,<\/span>Schools<\/span>,<\/span>Prefectures<\/span>\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Places<\/span>,<\/span>Restaurant<\/span>\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Authors<\/span>,<\/span>Books<\/span>\r\n\r\n\r\ns<\/span>=<\/span>Schools<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>()<\/span>\r\nprint<\/span>(<\/span>type<\/span>(<\/span>s<\/span>))<\/span>\r\nprint<\/span>(<\/span>dir<\/span>(<\/span>s<\/span>))<\/span> #\u3053\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u6301\u3064\u4f7f\u3048\u308b\u5c5e\u6027\u3092\u8fd4\u3059\u4e2d\u306bprefecture\u3068students_set\u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u304c\u308f\u304b\u308b\r\n# Schools\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306fStudents\u306b\u5bfe\u3057\u3066\u306f\uff11\u5bfe\u591a\u3001Prefecture\u306b\u5bfe\u3057\u3066\u306f\u591a\u5bfe\uff11\u3067\u3042\u308b\u305f\u3081\r\n<\/span>print<\/span>(<\/span>s<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span>\r\n\r\nprint<\/span>(<\/span>'<\/span>*<\/span>'<\/span>*<\/span>100<\/span>)<\/span>\r\nst<\/span> =<\/span> s<\/span>.<\/span>students_set<\/span> #\u591a\u3092\u53d6\u308a\u51fa\u3059\u306b\u306f_set\r\n<\/span>print<\/span>(<\/span>type<\/span>(<\/span>st<\/span>))<\/span>\r\nprint<\/span>(<\/span>dir<\/span>(<\/span>st<\/span>))<\/span>\r\nprint<\/span>(<\/span>st<\/span>.<\/span>all<\/span>())<\/span>\r\nst<\/span> =<\/span> st<\/span>.<\/span>all<\/span>()<\/span> #all\u3067\u53d6\u5f97\u3059\u308b\r\n<\/span>for<\/span> s<\/span> in<\/span> st<\/span>:<\/span>\r\n    print<\/span>(<\/span>s<\/span>.<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span> #\u5927\u962a\u3000\u3092\u53d6\u308a\u51fa\u305b\u308b\r\n<\/span>    \r\n#OnetoOne\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\r\n<\/span>print<\/span>(<\/span>'<\/span>********onetoone*********<\/span>'<\/span>)<\/span>\r\np<\/span> =<\/span> Places<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>()<\/span>\r\nprint<\/span>(<\/span>f<\/span>'<\/span>\u30ec\u30b9\u30c8\u30e9\u30f3\u306e\u540d\u524d\u306f:<\/span>{<\/span>p<\/span>.<\/span>restaurant<\/span>.<\/span>name<\/span>}<\/span>'<\/span>)<\/span>\r\n#\u9006\u3082\u540c\u3058\u3088\u3046\u306b\u53d6\u308a\u51fa\u305b\u308b\r\n<\/span>r<\/span> =<\/span> Restaurant<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>()<\/span>\r\nprint<\/span>(<\/span>f<\/span>'<\/span>\u5834\u6240\u306f<\/span>{<\/span>r<\/span>.<\/span>place<\/span>.<\/span>address<\/span>}<\/span>\u306e<\/span>{<\/span>r<\/span>.<\/span>place<\/span>.<\/span>name<\/span>}<\/span>'<\/span>)<\/span>\r\n\r\n\r\n#ManyToMany\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\r\n<\/span>print<\/span>(<\/span>'<\/span>***********manytomany****************<\/span>'<\/span>)<\/span>\r\nb<\/span> =<\/span> Books<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>()<\/span>\r\nprint<\/span>(<\/span>type<\/span>(<\/span>b<\/span>))<\/span>\r\nprint<\/span>(<\/span>dir<\/span>(<\/span>b<\/span>))<\/span>\r\nprint<\/span>(<\/span>b<\/span>.<\/span>authors<\/span>.<\/span>all<\/span>())<\/span>\r\nbs<\/span> =<\/span> b<\/span>.<\/span>authors<\/span>.<\/span>all<\/span>()<\/span>\r\nfor<\/span> b<\/span> in<\/span> bs<\/span>:<\/span>\r\n    print<\/span>(<\/span>b<\/span>.<\/span>name<\/span>)<\/span> #Author1,Author2\u304c\u8868\u793a\u3055\u308c\u308b\r\n<\/span>\r\na<\/span>=<\/span> Authors<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>()<\/span>\r\nprint<\/span>(<\/span>a<\/span>.<\/span>books_set<\/span>.<\/span>all<\/span>())<\/span>\r\n#models.py\u306eAuthors\u30af\u30e9\u30b9\u306fBooks\u3068\u7d10\u3065\u3051\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6301\u3063\u3066\u3044\u306a\u3044\u306e\u3067Authors\u3068Books\u304c\uff11\u5bfe\u591a\u306e\u3088\u3046\u306a\r\n# \u95a2\u4fc2\u306b\u306a\u308b\u304b\u3089\u3053\u3061\u3089\u306f_set\u3092\u4f7f\u3046\uff1f\r\n<\/span>\r\na_s<\/span> =<\/span> a<\/span>.<\/span>books_set<\/span>.<\/span>all<\/span>()<\/span>\r\nfor<\/span> a<\/span> in<\/span> a_s<\/span>:<\/span>\r\n    print<\/span>(<\/span>a<\/span>.<\/span>name<\/span>)<\/span> # Book1,Book3\u304c\u8868\u793a\u3055\u308c\u308b\r\n<\/span>\r\n<\/code><\/pre>\n
\u6307\u5b9a\u6761\u4ef6\u4e0b\u83b7\u53d6\u6570\u636e<\/h3>\n
\u5728manage.py\u7684\u76f8\u540c\u76ee\u5f55\u4e0b\u521b\u5efaquery_01.py\u81f3query_04.py\u6587\u4ef6
\n\u4ee5\u4e0b\u662f\u7ec3\u4e60\u83b7\u53d6\u6240\u6709\u6570\u636e\u7684\u5185\u5bb9<\/p>\n
#! \u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u53d6\u5f97\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>\r\n\r\n#\u5168\u4ef6\u53d6\u5f97\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>())<\/span>\r\n\r\n#\u982d\u4e94\u4ef6\u53d6\u5f97\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()[:<\/span>5<\/span>])<\/span>\r\n\r\n#5\u4ef6\u76ee\u3088\u308a\u3042\u3068\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()[<\/span>5<\/span>:])<\/span>\r\n\r\n#5~7\u4ef6\u76ee\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()[:<\/span>8<\/span>])<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>()[<\/span>5<\/span>:<\/span>8<\/span>].<\/span>query<\/span>)<\/span> #\u5b9f\u969b\u306b\u767a\u884c\u3057\u3066\u3044\u308bquery\u3092\u898b\u308b\u3053\u3068\u304c\u3067\u304d\u308b\r\n<\/span>\r\n#\u4e00\u756a\u6700\u521d\u306e\u4e00\u4ef6\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>first<\/span>())<\/span>\r\n\r\n#\u7b49\u4fa1\u306e\u3082\u306e\u3060\u3051\u306b\u7d5e\u308a\u8fbc\u3080\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>age<\/span>=<\/span>17<\/span>).<\/span>all<\/span>())<\/span>\r\n\r\n#AND\u6761\u4ef6\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>,<\/span>pk<\/span>=<\/span>13<\/span>).<\/span>all<\/span>().<\/span>query<\/span>)<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>,<\/span>pk__gte<\/span>=<\/span>13<\/span>).<\/span>all<\/span>().<\/span>query<\/span>)<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>,<\/span>pk__lte<\/span>=<\/span>17<\/span>).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>,<\/span>pk__gte<\/span>=<\/span>13<\/span>,<\/span>pk__lte<\/span>=<\/span>20<\/span>).<\/span>all<\/span>().<\/span>query<\/span>)<\/span>\r\n\r\n#\u524d\u65b9\u4e00\u81f4\u3001\u5f8c\u65b9\u4e00\u81f4\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name__startswith<\/span>=<\/span>'<\/span>\u592a<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name__endswith<\/span>=<\/span>'<\/span>\u90ce<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\n\r\n#or\r\n<\/span>from<\/span> django.db.models<\/span> import<\/span> Q<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>Q<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>)<\/span>|<\/span>Q<\/span>(<\/span>pk__gt<\/span>=<\/span>19<\/span>)).<\/span>all<\/span>())<\/span>\r\n<\/code><\/pre>\n
__gte\u662fgreater than equal\u7684\u7f29\u5199\u3002
\n__lte\u662fless than equal\u7684\u7f29\u5199\u3002<\/p>\n
##! \u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u53d6\u5f97\u3000\u305d\u306e\uff12\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>,<\/span>Person<\/span>\r\n\r\n#IN\r\n<\/span>ids<\/span> =<\/span> [<\/span>13<\/span>,<\/span>14<\/span>,<\/span>15<\/span>]<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>pk__in<\/span>=<\/span>ids<\/span>).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>pk__in<\/span>=<\/span>[<\/span>15<\/span>,<\/span>16<\/span>,<\/span>17<\/span>]).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name__in<\/span>=<\/span>[<\/span>'<\/span>\u4e8c\u90ce<\/span>'<\/span>,<\/span>'<\/span>\u4e09<\/span>'<\/span>]).<\/span>all<\/span>())<\/span> #\u4e8c\u90ce\u306f\u53d6\u308a\u51fa\u305b\u308b\u304c\u4e09\u3067\u306f\u4e09\u90ce\u306f\u53d6\u308a\u51fa\u305b\u306a\u3044\r\n<\/span>\r\n# contain \u90e8\u5206\u4e00\u81f4\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name__contains<\/span>=<\/span>'<\/span>\u4e09<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\n\r\n#is null\r\n<\/span>print<\/span>(<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>salary__isnull<\/span>=<\/span>True<\/span>).<\/span>all<\/span>())<\/span>\r\n\r\n#\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u308a\u9664\u304fexclude(filter\u306e\u9006\u3092\u53d6\u308a\u51fa\u3059)\r\n<\/span>print<\/span>(<\/span>Person<\/span>.<\/span>objects<\/span>.<\/span>exclude<\/span>(<\/span>salary__isnull<\/span>=<\/span>True<\/span>).<\/span>all<\/span>())<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>exclude<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\n\r\n#\u30ab\u30e9\u30e0\u3092\u53d6\u308a\u51fa\u3059\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>id<\/span>'<\/span>,<\/span>'<\/span>name<\/span>'<\/span>,<\/span>'<\/span>age<\/span>'<\/span>).<\/span>all<\/span>().<\/span>query<\/span>)<\/span>\r\nstudents<\/span> =<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>id<\/span>'<\/span>,<\/span>'<\/span>name<\/span>'<\/span>,<\/span>'<\/span>age<\/span>'<\/span>).<\/span>all<\/span>()<\/span>\r\nfor<\/span> student<\/span> in<\/span> students<\/span>:<\/span>\r\n    print<\/span>(<\/span>'<\/span>id:{},\u540d\u524d:{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>student<\/span>[<\/span>'<\/span>id<\/span>'<\/span>],<\/span>student<\/span>[<\/span>'<\/span>name<\/span>'<\/span>]))<\/span>\r\n    \r\n#\u4e26\u3073\u66ff\u3048\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>order_by<\/span>(<\/span>'<\/span>name<\/span>'<\/span>,<\/span>'<\/span>-id<\/span>'<\/span>).<\/span>all<\/span>())<\/span> #\u7b2c\u4e00\u6761\u4ef6name\u3092\u6607\u9806\u3001\u7b2c\u4e8c\u6761\u4ef6id\u3092\u964d\u9806\u306b\u4e26\u3073\u66ff\u3048\u308b\r\n#filter\u3068order_by\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3082\u53ef\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>order_by<\/span>(<\/span>'<\/span>-id<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\n<\/code><\/pre>\n
##! \u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u53d6\u5f97\u3000\u305d\u306e3\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>\r\n\r\n# #\u4ef6\u6570\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>count<\/span>())<\/span> #12\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>count<\/span>())<\/span> #4\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>name<\/span>=<\/span>'<\/span>Taro<\/span>'<\/span>).<\/span>count<\/span>())<\/span> #0\r\n<\/span>\r\n# #\u4ef6\u6570\u3001\u6700\u5927\u5024\u3001\u6700\u5c0f\u5024\u3001\u5e73\u5747\u5024\u3001\u5408\u8a08\r\n<\/span>from<\/span> django.db.models<\/span> import<\/span> Count<\/span>,<\/span>Max<\/span>,<\/span>Min<\/span>,<\/span>Avg<\/span>,<\/span>Sum<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>aggregate<\/span>(<\/span>Count<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Avg<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Sum<\/span>(<\/span>'<\/span>age<\/span>'<\/span>)))<\/span>\r\naggregate_student<\/span> =<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>aggregate<\/span>(<\/span>Count<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Avg<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Sum<\/span>(<\/span>'<\/span>age<\/span>'<\/span>))<\/span>\r\n#{'pk__count':12,'pk__max':24}\u3068\u3044\u3063\u305f\u3088\u3046\u306b\u8f9e\u66f8\u578b\u3067\u8fd4\u3055\u308c\u308b\u305f\u3081\u4e0b\u8a18\u306e\u3088\u3046\u306a\u8a18\u8ff0\u3067\u53d6\u308a\u51fa\u305b\u308b\r\n<\/span>print<\/span>(<\/span>aggregate_student<\/span>[<\/span>'<\/span>pk__max<\/span>'<\/span>])<\/span>\r\n#\u5225\u540d\u3092\u3064\u3051\u308b\u3053\u3068\u3082\u3067\u304d\u308b\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>aggregate<\/span>(<\/span>counted_pk<\/span>=<\/span> Count<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>max_pk<\/span>=<\/span>Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>min_pk<\/span>=<\/span>Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>avg_pk<\/span>=<\/span>Avg<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>sum_pk<\/span>=<\/span>Sum<\/span>(<\/span>'<\/span>age<\/span>'<\/span>)))<\/span>\r\n\r\n#GROUP BY:\u3042\u308b\u7279\u5b9a\u306e\u30ab\u30e9\u30e0\u3067\u96c6\u8a08\u3057\u3066\u3001\u5408\u8a08\u3001\u6700\u5927\u306a\u3069\u3092\u6c42\u3081\u308b\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>name<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>\r\n    Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>)<\/span>\r\n).<\/span>query<\/span>)<\/span> #query\u3092\u898b\u308b\r\n<\/span>print<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>name<\/span>'<\/span>,<\/span>'<\/span>age<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>\r\n    max_id<\/span> =<\/span> Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>min_id<\/span> =<\/span> Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>)<\/span>#\u30ad\u30fc\u3092max_id\u3068\u3000min_id\u306b\u5909\u66f4\u3057\u3066\u3044\u308b\r\n<\/span>))<\/span> \r\n#\u8f9e\u66f8\u578b\u304c\u914d\u5217\u306e\u4e2d\u306b\u306f\u3044\u3063\u3066\u6e21\u3055\u308c\u308b\u306e\u3067for\u6587\u3067\u4e00\u3064\u4e00\u3064\u53d6\u308a\u51fa\u3057\u3066\u30ad\u30fc\u3092\u6307\u5b9a\u3057\u3066\u53d6\u308a\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u308b\r\n<\/span>for<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>name<\/span>'<\/span>,<\/span>'<\/span>age<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>\r\n    max_id<\/span> =<\/span> Max<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>),<\/span>min_id<\/span> =<\/span> Min<\/span>(<\/span>'<\/span>pk<\/span>'<\/span>)<\/span>\r\n):<\/span>\r\n    print<\/span>(<\/span>student<\/span>[<\/span>'<\/span>name<\/span>'<\/span>],<\/span>student<\/span>[<\/span>'<\/span>max_id<\/span>'<\/span>])<\/span>\r\n<\/code><\/pre>\n
#! \u30c7\u30fc\u30bf\u3092\u7d5e\u308a\u8fbc\u3093\u3067\u53d6\u5f97\u3000\u305d\u306e4 \u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u3064\u304b\u3063\u305f\u7d5e\u308a\u8fbc\u307f\r\n<\/span>import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelProject.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Students<\/span>,<\/span>Schools<\/span>\r\n\r\n# for student in Students.objects.all():\r\n#     print(student.name,student.school.name,student.school.prefecture.name)\r\n<\/span>\r\n#\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3063\u305ffilter\u304c\u3067\u304d\u308b(\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u540d__\u30ab\u30e9\u30e0\u3068\u3059\u308b)\r\n<\/span>for<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>school__name<\/span>=<\/span>'<\/span>\u5357\u9ad8\u6821<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span>\r\n\r\n#exclude\u3082\u3067\u304d\u308b\r\n<\/span>for<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>exclude<\/span>(<\/span>school__name<\/span>=<\/span>'<\/span>\u5357\u9ad8\u6821<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span>\r\n    \r\n#schools\u30c6\u30fc\u30d6\u30eb\u304b\u3089students\u3092\u53d6\u308a\u51fa\u3059\r\n<\/span>print<\/span>(<\/span>Schools<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>students__name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>all<\/span>())<\/span>\r\nfor<\/span> school<\/span> in<\/span> Schools<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>students__name<\/span>=<\/span>'<\/span>\u592a\u90ce<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>school<\/span>.<\/span>name<\/span>,<\/span>school<\/span>.<\/span>prefecture<\/span>.<\/span>name<\/span>)<\/span>\r\n    \r\nprint<\/span>(<\/span>'<\/span>-<\/span>'<\/span>*<\/span>100<\/span>)<\/span>\r\n#\u9806\u756a\u3092\u4e26\u3073\u66ff\u3048\u308b(order_by)\r\n<\/span>for<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>order_by<\/span>(<\/span>'<\/span>-school__name<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>)<\/span>\r\nprint<\/span>(<\/span>'<\/span>-<\/span>'<\/span>*<\/span>100<\/span>)<\/span>\r\nfor<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>school__name<\/span>=<\/span>'<\/span>\u897f\u9ad8\u6821<\/span>'<\/span>).<\/span>order_by<\/span>(<\/span>'<\/span>-school__name<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>)<\/span>\r\nprint<\/span>(<\/span>'<\/span>*<\/span>'<\/span>*<\/span>100<\/span>)<\/span>\r\n#\u30ea\u30b9\u30c8\u3092\u3064\u304f\u3063\u3066in\u3067\u6761\u4ef6\u6307\u5b9a\u3059\u308b\u3068\u8907\u6570\u306evalue\u304b\u3089\u4e00\u62ec\u53d6\u5f97\u3067\u304d\u308b\uff08\u81ea\u4f5c\uff09\r\n<\/span>school_names<\/span>=<\/span>[<\/span>'<\/span>\u5357\u9ad8\u6821<\/span>'<\/span>,<\/span>'<\/span>\u897f\u9ad8\u6821<\/span>'<\/span>]<\/span>\r\nfor<\/span> student<\/span> in<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>school__name__in<\/span>=<\/span>school_names<\/span>).<\/span>order_by<\/span>(<\/span>'<\/span>school__name<\/span>'<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>student<\/span>.<\/span>name<\/span>,<\/span>student<\/span>.<\/span>school<\/span>.<\/span>name<\/span>)<\/span>\r\n    \r\n#\u5916\u90e8\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3063\u305fGROUP BY\r\n<\/span>from<\/span> django.db.models<\/span> import<\/span> Count<\/span>,<\/span>Max<\/span>\r\nprint<\/span>(<\/span>Students<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>school__name<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>Count<\/span>(<\/span>'<\/span>id<\/span>'<\/span>),<\/span>Max<\/span>(<\/span>'<\/span>id<\/span>'<\/span>)))<\/span>\r\n#student\u304b\u3089School\u306ename\u3054\u3068\u306b\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u3066\u8fd4\u3059\r\n<\/span><\/code><\/pre>\n
\u7ec3\u4e60\u9898\u76ee<\/h3>\n
\"20230728-121553.png\"<\/div>\n
\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff1a
\n1. \u521b\u5efa\u9879\u76ee\u548c\u5e94\u7528\u7a0b\u5e8f\uff0c\u5e76\u5b8c\u6210\u8fc1\u79fb\u5de5\u4f5c\u3002
\n2. \u5728models.py\u4e2d\u521b\u5efa\u6a21\u578b\u3002
\n3. \u8fd0\u884cmakemigration\u548cmigrate\u547d\u4ee4\uff0c\u521b\u5efa\u8868\u683c\u3002
\n4. \u5b58\u50a8\u6570\u636e\u3002
\n5. \u4ece\u8868\u683c\u4e2d\u63d0\u53d6\u6570\u636e\u3002<\/p>\n
\u53ea\u6709\u4e00\u4e2a\u9009\u9879\uff1a\u7701\u75651\u3002<\/p>\n
\u4ece2\u5f00\u59cb\u63cf\u8ff0<\/p>\n
from<\/span> django.db<\/span> import<\/span> models<\/span>\r\n\r\nclass<\/span> Tests<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>tests<\/span>'<\/span>\r\n        \r\nclass<\/span> Test_Results<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    test<\/span>=<\/span>models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Tests<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>\r\n    )<\/span>\r\n    student<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Students<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>\r\n    )<\/span>\r\n    score<\/span> =<\/span> models<\/span>.<\/span>IntegerField<\/span>()<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>test_results<\/span>'<\/span>\r\n        \r\n\r\nclass<\/span> Students<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span>models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    grade<\/span> =<\/span> models<\/span>.<\/span>IntegerField<\/span>()<\/span>\r\n    classes<\/span> =<\/span> models<\/span>.<\/span>ForeignKey<\/span>(<\/span>\r\n        '<\/span>Classes<\/span>'<\/span>,<\/span>on_delete<\/span>=<\/span>models<\/span>.<\/span>CASCADE<\/span>\r\n    )<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>students<\/span>'<\/span>\r\n        \r\nclass<\/span> Classes<\/span>(<\/span>models<\/span>.<\/span>Model<\/span>):<\/span>\r\n    name<\/span> =<\/span> models<\/span>.<\/span>CharField<\/span>(<\/span>max_length<\/span>=<\/span>50<\/span>)<\/span>\r\n    \r\n    class<\/span> Meta<\/span>:<\/span>\r\n        db_table<\/span> =<\/span> '<\/span>classes<\/span>'<\/span>\r\n<\/code><\/pre>\n
\u53ea\u67093\u4e2a\u7701\u7565
\n4. \u5b58\u50a8\u6570\u636e<\/p>\n
import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelExam.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Tests<\/span>,<\/span>Test_Results<\/span>,<\/span>Students<\/span>,<\/span>Classes<\/span>\r\nimport<\/span> random<\/span>\r\n\r\n#classes\u306b\u30c7\u30fc\u30bf\u3092\u3044\u308c\u308b\r\n# classes_list=['classA','classB','classC','classD','classE','classF','classG','classH','classI','classJ']\r\n<\/span>classes_list<\/span> =<\/span> [<\/span>'<\/span>class<\/span>'<\/span>+<\/span> c<\/span> for<\/span> c<\/span> in<\/span> '<\/span>ABCDEFGHIJ<\/span>'<\/span>]<\/span>\r\n# students_list=['studentA','studentB','studentC','studentD','studentE','stundenF','studentG','studentH','studentI','studentJ']\r\n<\/span>students_list<\/span>=<\/span>[<\/span>'<\/span>student<\/span>'<\/span> +<\/span> c<\/span> for<\/span> c<\/span> in<\/span> '<\/span>ABCDEFGHIJ<\/span>'<\/span>]<\/span>\r\n# print(classes_list)\r\n<\/span>tests_list<\/span>=<\/span>[<\/span>'<\/span>\u6570\u5b66<\/span>'<\/span>,<\/span>'<\/span>\u82f1\u8a9e<\/span>'<\/span>,<\/span>'<\/span>\u56fd\u8a9e<\/span>'<\/span>]<\/span>\r\n\r\n\r\n#test\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u3063\u3066\u30ea\u30b9\u30c8\u306b\u683c\u7d0d\u3059\u308b\r\n<\/span>tests_instance_list<\/span> =<\/span> []<\/span>\r\nfor<\/span> test_name<\/span> in<\/span> tests_list<\/span>:<\/span>\r\n    test_instance<\/span> =<\/span> Tests<\/span>(<\/span>\r\n        name<\/span> =<\/span> test_name<\/span>\r\n    )<\/span>\r\n    test_instance<\/span>.<\/span>save<\/span>()<\/span>\r\n    tests_instance_list<\/span>.<\/span>append<\/span>(<\/span>test_instance<\/span>)<\/span>\r\n\r\n#\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u95a2\u6570 \r\n<\/span>def<\/span> insert_records<\/span>():<\/span>\r\n    for<\/span> classes_name<\/span> in<\/span> classes_list<\/span>:<\/span> \r\n        classes<\/span> =<\/span> Classes<\/span>(<\/span>\r\n            name<\/span>=<\/span>classes_name<\/span>\r\n        )<\/span>\r\n        classes<\/span>.<\/span>save<\/span>()<\/span>\r\n        \r\n        for<\/span> students<\/span> in<\/span> students_list<\/span>:<\/span>\r\n            #student\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u308b\r\n<\/span>            name<\/span> =<\/span> classes_name<\/span> +<\/span>'<\/span> '<\/span>+<\/span>students<\/span>\r\n            student<\/span> =<\/span> Students<\/span>(<\/span>\r\n                name<\/span> =<\/span> name<\/span>,<\/span>\r\n                grade<\/span> =<\/span> 1<\/span>,<\/span>\r\n                classes<\/span> =<\/span> classes<\/span>\r\n            )<\/span>\r\n            student<\/span>.<\/span>save<\/span>()<\/span>\r\n            for<\/span> test_name<\/span> in<\/span> tests_instance_list<\/span>:<\/span>\r\n                test_results<\/span> =<\/span> Test_Results<\/span>(<\/span>\r\n                    test<\/span> =<\/span> test_name<\/span>,<\/span>\r\n                    student<\/span> =<\/span> student<\/span>,<\/span>\r\n                    score<\/span> =<\/span> random<\/span>.<\/span>randint<\/span>(<\/span>50<\/span>,<\/span>100<\/span>)<\/span>\r\n                    )<\/span>\r\n                test_results<\/span>.<\/span>save<\/span>()<\/span>\r\n    \r\ninsert_records<\/span>()<\/span>\r\n<\/code><\/pre>\n
\u4ece\u8868\u4e2d\u63d0\u53d6\u6570\u636e<\/p>\n
import<\/span> os<\/span>\r\nos<\/span>.<\/span>environ<\/span>.<\/span>setdefault<\/span>(<\/span>'<\/span>DJANGO_SETTINGS_MODULE<\/span>'<\/span>,<\/span>'<\/span>ModelExam.settings<\/span>'<\/span>)<\/span>\r\nfrom<\/span> django<\/span> import<\/span> setup<\/span>\r\nsetup<\/span>()<\/span>\r\n\r\nfrom<\/span> ModelApp.models<\/span> import<\/span> Tests<\/span>,<\/span>Test_Results<\/span>,<\/span>Students<\/span>,<\/span>Classes<\/span>\r\nfrom<\/span> django.db.models<\/span> import<\/span> Sum<\/span>,<\/span>Avg<\/span>,<\/span>Max<\/span>,<\/span>Min<\/span>\r\n\r\nprint<\/span>(<\/span>'<\/span>id\u304c\uff11\u306estudent\u306e\u540d\u524d\u3068\u30c6\u30b9\u30c8\u79d1\u76ee\u3068\u70b9\u6570\u3092\u8868\u793a\u3059\u308b<\/span>'<\/span>)<\/span>\r\nfor<\/span> test_result<\/span> in<\/span> Test_Results<\/span>.<\/span>objects<\/span>.<\/span>filter<\/span>(<\/span>student__id<\/span> =<\/span> 1<\/span>).<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>\r\n        '<\/span>\u751f\u5f92\u540d:{}<\/span>\\\r\n<\/span>        \u30c6\u30b9\u30c8\u306e\u79d1\u76ee:{}<\/span>\\\r\n<\/span>        \u70b9\u6570:{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>test_result<\/span>.<\/span>student<\/span>.<\/span>name<\/span>,<\/span>test_result<\/span>.<\/span>test<\/span>.<\/span>name<\/span>,<\/span>test_result<\/span>.<\/span>score<\/span>)<\/span>\r\n    )<\/span>\r\n    \r\nprint<\/span>(<\/span>'<\/span>\u30af\u30e9\u30b9\u3054\u3068\u306e\u5404\u79d1\u76ee\u306e\u30c6\u30b9\u30c8\u306e\u5408\u8a08\u3001\u5e73\u5747\u3001\u6700\u5927\u3001\u6700\u5c0f\u3092\u8868\u793a\u3059\u308b<\/span>'<\/span>)<\/span>\r\n# s=Test_Results.objects.values('student__classes__name','test__name').annotate(\r\n#     Max('score'),Min('score'),Sum('score'),Avg('score')\r\n# )\r\n# print(s)\r\n<\/span>for<\/span> test_result<\/span> in<\/span> Test_Results<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>student__classes__name<\/span>'<\/span>,<\/span>'<\/span>test__name<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>\r\n    Max<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Min<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Sum<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Avg<\/span>(<\/span>'<\/span>score<\/span>'<\/span>)<\/span>\r\n):<\/span>\r\n    print<\/span>(<\/span>\r\n        '<\/span>\u30af\u30e9\u30b9:{}<\/span>\\\r\n<\/span>        \u79d1\u76ee:{}<\/span>\\\r\n<\/span>        \u6700\u5927\u5024:{}<\/span>\\\r\n<\/span>        \u6700\u5c0f\u5024:{}<\/span>\\\r\n<\/span>        \u5e73\u5747\u5024:{}<\/span>\\\r\n<\/span>        \u5408\u8a08:{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>test_result<\/span>[<\/span>'<\/span>student__classes__name<\/span>'<\/span>],<\/span>test_result<\/span>[<\/span>'<\/span>test__name<\/span>'<\/span>],<\/span>test_result<\/span>[<\/span>'<\/span>score__max<\/span>'<\/span>],<\/span>test_result<\/span>[<\/span>'<\/span>score__min<\/span>'<\/span>],<\/span>test_result<\/span>[<\/span>'<\/span>score__avg<\/span>'<\/span>],<\/span>test_result<\/span>[<\/span>'<\/span>score__sum<\/span>'<\/span>]))<\/span>\r\n    \r\nprint<\/span>(<\/span>'<\/span>id\u304c\uff11\u306estudent\u306e\u540d\u524d\u3068\u30c6\u30b9\u30c8\u79d1\u76ee\u3068\u70b9\u6570\u3092\u8868\u793a\u3059\u308b2<\/span>'<\/span>)<\/span>\r\nstudent<\/span> =<\/span> Students<\/span>.<\/span>objects<\/span>.<\/span>get<\/span>(<\/span>id<\/span> =<\/span> 1<\/span>)<\/span> #id\u3082\u53ef\r\n# student = Students.objects.get(pk = 1) #pk\u3082\u53ef\r\n# student = Students.objects.filter(id = 1) #? \u3053\u3061\u3089\u3067\u306ftest_result_set\u304c\u4f7f\u3048\u306a\u304b\u3063\u305f\u306e\u306f\u306a\u305c\uff1f\r\n#!filter\u306f\u30af\u30a8\u30ea\u30bb\u30c3\u30c8\u3092\u8fd4\u3057\u3001get\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\r\n<\/span>print<\/span>(<\/span>student<\/span>)<\/span>\r\nfor<\/span> test_result<\/span> in<\/span> student<\/span>.<\/span>test_results_set<\/span>.<\/span>all<\/span>():<\/span>\r\n    print<\/span>(<\/span>\r\n        '<\/span>\u751f\u5f92\u540d:{}<\/span>\\\r\n<\/span>        \u30c6\u30b9\u30c8\u306e\u79d1\u76ee:{}<\/span>\\\r\n<\/span>        \u70b9\u6570:{}<\/span>'<\/span>.<\/span>format<\/span>(<\/span>test_result<\/span>.<\/span>student<\/span>.<\/span>name<\/span>,<\/span>test_result<\/span>.<\/span>test<\/span>.<\/span>name<\/span>,<\/span>test_result<\/span>.<\/span>score<\/span>)<\/span>\r\n    )<\/span>\r\n    \r\nprint<\/span>(<\/span>'<\/span>\u30af\u30a8\u30ea\u3092\u307f\u3066\u307f\u308b<\/span>'<\/span>)<\/span>\r\nprint<\/span>(<\/span>Test_Results<\/span>.<\/span>objects<\/span>.<\/span>values<\/span>(<\/span>'<\/span>student__classes__name<\/span>'<\/span>,<\/span>'<\/span>test__name<\/span>'<\/span>).<\/span>annotate<\/span>(<\/span>\r\n    Max<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Min<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Sum<\/span>(<\/span>'<\/span>score<\/span>'<\/span>),<\/span>Avg<\/span>(<\/span>'<\/span>score<\/span>'<\/span>)<\/span>\r\n).<\/span>query<\/span>)<\/span>\r\n<\/code><\/pre>\n
filter\u548cget\u7684\u533a\u522b\u5728\u4e8e
\nfilter\u8fd4\u56de\u4e00\u4e2a\u67e5\u8be2\u96c6
\nget\u8fd4\u56de\u4e00\u4e2a\u5bf9\u8c61\u3002<\/p>\n
\u5982\u679c\u5bf9\u4e8e\u4ee5\u4e0a\u7684\u6a21\u578b\u6709\u4efb\u4f55\u65b0\u7684\u5b66\u4e60\uff0c\u6211\u4eec\u4f1a\u7ee7\u7eed\u66f4\u65b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Django\u8fd9\u5c06\u662f\u6211\u4e2a\u4eba\u7684\u5907\u5fd8\u5f55\u3002 \u672c\u6b21\u6211\u4eec\u5c06\u603b\u7ed3\u4e00\u4e0b\u5173\u4e8eModel\u7684\u64cd\u4f5c\u3002 \u5f00\u53d1\u73af\u5883 \u64cd\u4f5c\u7cfb\u7edf\uff1amac \u7f16\u8f91 […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-49752","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nDjango Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/django-model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\" \/>\n<meta property=\"og:description\" content=\"Django\u8fd9\u5c06\u662f\u6211\u4e2a\u4eba\u7684\u5907\u5fd8\u5f55\u3002 \u672c\u6b21\u6211\u4eec\u5c06\u603b\u7ed3\u4e00\u4e0b\u5173\u4e8eModel\u7684\u64cd\u4f5c\u3002 \u5f00\u53d1\u73af\u5883 \u64cd\u4f5c\u7cfb\u7edf\uff1amac \u7f16\u8f91 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/django-model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-01T01:31:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T04:08:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8d3e913a08637a6d2a91\/85-0.png\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/\",\"name\":\"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-10-01T01:31:23+00:00\",\"dateModified\":\"2024-04-29T04:08:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/django-model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\/","og_locale":"zh_CN","og_type":"article","og_title":"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09","og_description":"Django\u8fd9\u5c06\u662f\u6211\u4e2a\u4eba\u7684\u5907\u5fd8\u5f55\u3002 \u672c\u6b21\u6211\u4eec\u5c06\u603b\u7ed3\u4e00\u4e0b\u5173\u4e8eModel\u7684\u64cd\u4f5c\u3002 \u5f00\u53d1\u73af\u5883 \u64cd\u4f5c\u7cfb\u7edf\uff1amac \u7f16\u8f91 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/django-model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-10-01T01:31:23+00:00","article_modified_time":"2024-04-29T04:08:39+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d8d3e913a08637a6d2a91\/85-0.png"}],"author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"14 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/","name":"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-10-01T01:31:23+00:00","dateModified":"2024-04-29T04:08:39+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Django Model\u64cd\u4f5c\uff08\u4e2a\u4eba\u5907\u5fd8\u5f55\uff09"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/django-model%e6%93%8d%e4%bd%9c%ef%bc%88%e4%b8%aa%e4%ba%ba%e5%a4%87%e5%bf%98%e5%bd%95%ef%bc%89\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=49752"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49752\/revisions"}],"predecessor-version":[{"id":85186,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/49752\/revisions\/85186"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=49752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=49752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=49752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}