{"id":2572,"date":"2021-02-09T18:26:48","date_gmt":"2021-02-09T09:26:48","guid":{"rendered":"https:\/\/qol-kk.com\/wp2\/?p=2572"},"modified":"2021-02-22T10:49:05","modified_gmt":"2021-02-22T01:49:05","slug":"post-2572","status":"publish","type":"post","link":"https:\/\/qol-kk.com\/wp2\/blog\/2021\/02\/09\/post-2572\/","title":{"rendered":"Django\uff1aCRUD\u3092\u5b9f\u88c5\u3059\u308b\u3010Read\u3011DB\u767b\u9332\u30c7\u30fc\u30bf\u306e\u4e00\u89a7\u8868\u793a"},"content":{"rendered":"

Django\uff1aCRUD\u3092\u5b9f\u88c5\u3059\u308b\u3010Read\u3011DB\u767b\u9332\u30c7\u30fc\u30bf\u306e\u4e00\u89a7\u8868\u793a<\/h2>\n

Read\u306b\u306fList(\u4e00\u89a7\u8868\u793a)\u3068Show(\u500b\u5225\u30c7\u30fc\u30bf\u8868\u793a)\u306e2\u7a2e\u304c\u3042\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

Show\u306fUpdate\u3068\u4e00\u7dd2\u306b\u69cb\u7bc9\u3059\u308b\u4e8b\u304c\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u3053\u306e\u8a18\u4e8b\u3067\u306fList(\u4e00\u89a7\u8868\u793a)\u306e\u307f\u3092\u6271\u3044\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\u30d7\u30ea\u30bb\u30c3\u30c8\u30af\u30e9\u30b9\u3092\u5229\u7528\u3057\u305fList\u306e\u8a18\u8f09\u65b9\u6cd5<\/h3>\n

Django\u306e\u30d7\u30ea\u30bb\u30c3\u30c8Class\u306b\u306f\u3010ListView\u3011\u3068\u3044\u3046\u4e00\u89a7\u8868\u793a\u7528\u306e\u30bb\u30c3\u30c8\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

\u25a0app\/urls.py<\/p>\n

from django.urls import path\r\nfrom . import views\r\n\r\napp_name = 'hoge'\r\nurlpatterns = [\r\n  path('<int:page>\/', views.HogeDetailView,as_View() name=\"hoge_detail\"),\r\n]<\/pre>\n
\u25a0app\/models.py<\/p>\n
from django.db import models\r\nfrom . import views\r\n\r\nclass Hoge(models.Model):\r\n  column01 = models.CharField(verbose_name='\u307b\u30521', max_length=200)\r\n  column02 = models.CharField(verbose_name='\u307b\u30522', max_length=200)\r\n  column03 = models.CharField(verbose_name='\u307b\u30523', max_length=200)\r\n  daylight_hours = models.FloatField(verbose_name='\u65e5\u7167\u6642\u9593')#\u5f8c\u534a\u3067\u691c\u7d22\u306e\u4f8b\u306b\u4f7f\u3044\u307e\u3059\u3002\r\n  observation_date = models.DateField(verbose_name='\u89b3\u6e2c\u65e5')#\u5f8c\u534a\u3067\u691c\u7d22\u306e\u4f8b\u306b\u4f7f\u3044\u307e\u3059\u3002\r\n\r\n    class Meta:\r\n        verbose_name_plural = 'Hoge'\r\n        def __str__(self):\r\n            return self.column01<\/pre>\n
\u25a0app\/views.py<\/p>\n
from django.views import generic \r\nfrom .models import Hoge\r\n\r\nclass HogeListView(generic.ListView):\r\n  model = hoge\r\n  template_name = 'hoge_list.html'\r\n  paginate_by = 10\r\n  ordering = ['-created_at']<\/pre>\n
\u25a0app\/template\/hoge_list.html<\/p>\n
{% extends \"base_site.html\" %}\r\n(\u4e2d\u7565)\r\n{% block content %}\r\n  {% for Hogelist in object_list %}\r\n    <table>\r\n      <tr>\r\n        <th>\u304b\u3089\u30801<\/th>\r\n        <th>\u304b\u3089\u30802<\/th>\r\n        <th>\u304b\u3089\u30803<\/th>\r\n      <\/tr>\r\n      <tr>\r\n        <td>{{Hogelist.column01}}<\/td>\r\n        <td>{{Hogelist.column02}}<\/td>\r\n        <td>{{Hogelist.column03}}<\/td>\r\n      <\/tr>\r\n    <\/table>\r\n  {% endfor %}\r\n{% endblock content %}\r\n(\u4ee5\u4e0b\u7565)<\/pre>\n
\u305f\u3063\u305f\u30b3\u30ec\u3060\u3051\u3067DB\u306b\u767b\u9332\u3055\u308c\u305f\u30ea\u30b9\u30c8\u3092\u62bd\u51fa\u3059\u308b\u3093\u3067\u3059\u3051\u3069\u3001\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u307e\u3067\u3064\u3044\u3066\u308b\u3093\u3060\u304b\u3089\u306d\u3002
\n\u4fbf\u5229\u306a\u3082\u3093\u3060\u3002<\/p>\n
\u30c1\u30e7\u30c3\u30c8\u89e3\u8aac<\/h4>\n
\u30d7\u30ea\u30bb\u30c3\u30c8\u30af\u30e9\u30b9\u3067\u306f\u3001Template\u306b\u9001\u308b\u5024\u306e\u540d\u524d\u306f\u56fa\u5b9a\u3055\u308c\u307e\u3059\u3002ListViews\u306e\u5834\u5408\u306f\u4e0b\u306e\u901a\u308a<\/p>\n
\n