当前位置:网站首页>Day07 ORM table relationship and operation
Day07 ORM table relationship and operation
2022-07-19 01:23:00 【Wbig】
1. many-to-one
1.1 What is the relationship of many to one ?
A class , There are many students in a class , Just like the foreign keys in the table
class Major(models.Model):
major_name = models.CharField(max_length=20,verbose_name=' Major name ')
class Meta:
verbose_name = ' Professional watch '
verbose_name_plural = verbose_name
db_table = 'major'
def __str__(self):
return self.major_name
class Student(models.Model):
stu_name = models.CharField(max_length=20,verbose_name=' The student's name ')
score = models.IntegerField(verbose_name=' achievement ')
sex = models.CharField(max_length=2,verbose_name=' Gender ')
major = models.ForeignKey(Major,on_delete=models.CASCADE,verbose_name=' Major number ')
class Meta:
verbose_name = ' Student list '
verbose_name_plural = verbose_name
db_table = 'student'
def __str__(self):
return self.stu_name
1.2 Many to one addition, deletion and modification
increase
def post(self,request):
name = request.POST.get('name')
score = request.POST.get('score')
sex = request.POST.get('sex')
major = request.POST.get('major')
try:
Student.objects.create(
stu_name = name,
score = score,
sex = sex,
major_id = major
)
except Exception as e:
print(e)
return HttpResponse(' Add failure ')
return redirect('/major/')
Delete
class DeleteView(View):
def get(self,request,id):
Student.objects.filter(id=id).delete()
return redirect('/major/')
modify
class UpdateView(View):
def get(self,request,id):
try:
stud_data = Student.objects.get(id=id)
except Exception as e:
print(e)
return HttpResponse(' Failed to get data ')
return render(request,'update.html',{'stus':stud_data})
def post(self,request,id):
name = request.POST.get('name')
score = request.POST.get('score')
sex = request.POST.get('sex')
major = request.POST.get('major')
try:
Student.objects.filter(id=id).update(
stu_name=name,
score=score,
sex=sex,
major=major
)
except Exception as e:
print(e)
return HttpResponse(' Add failure ')
return redirect('/major/')
边栏推荐
猜你喜欢
随机推荐
Maker-HarmonyOS应用开发培训笔记01
CVE-2022-34265 Django Extract & Trunc SQL注入漏洞复现
CobalStrike的部署(附带资源)
pytorch index_select
Pytorch手动实现线性回归
[SWPU 2019]Network-TTL加密和涉及的一些知识
递归方法|斐波那契数列
Day16-排序,限流
P6-day01-通用试图(P4复习)
Tool version number
Use NN in pytoch to realize linear regression (simple implementation)
RedisTemplate无法根据key 获取值的问题
Redis command
Markdown various mathematical symbols
CLI and vite realize cross domain through proxy
关于外键的引用,跨域头部,ref的用法
2021-3-17-字节-胡牌
Oracle 数据库启用归档日志模式和归档日志删除和生成频率
Oracle自动存储管理18c分步安装-2
物联网开发基础








![Eye of depth III - (4, 5)] mathematics: matrix eigenvalues and eigenvectors 2](/img/fc/7a4bffc642d82fcfaf3be80bcc39fc.png)