タイトル: SELECT, INSERT, UPDATE, DELETE

SEOタイトル: DjangoにおけるデータベースのSELECT, INSERT, UPDATE, DELETE

前提

・データベースの接続設定が済んでいること（まだの方はこちらを参照）

from django.db import models
from datetime import datetime

class User(models.Model):

user_name = models.CharField(primary_key=True, max_length=100)

password = models.CharField(max_length=100)

created_at = models.DateTimeField(default=datetime.now)

class Meta:

db_table = 'User'

from django.views.generic import TemplateView
from test_app.models.user import User

class RegistView(TemplateView):

def post(self, request, *args, **kwargs):

users = User.objects.all().filter(user_name='aaa').order_by('created_at')

context = {
'users': users,
}

template_name = 'test_app/index.html'

return render(request, template_name, context)

from django.views.generic import TemplateView
from test_app.models.user import User

class RegistView(TemplateView):

def post(self, request, *args, **kwargs):

user_name = request.POST['user_name']
password = request.POST['password']

user = User(user_name=user_name, password=password)
user.save()

...

※他の処理に関しては随時追記予定