Django-表的自关联 related_name

models

from django.db import models

# Create your models here.

class Userinfo(models.Model):
    nickname = models.CharField(max_length=32)
    username = models.CharField(max_length=32)
    password = models.CharField(max_length=32)
    gender_choice = (
        (1,'男'),
        (2,'女'),
    )
    gender = models.IntegerField(choices=gender_choice)

class U2U(models.Model):
    b = models.ForeignKey('Userinfo',on_delete=models.CASCADE,related_name='girls')
    g = models.ForeignKey('Userinfo',on_delete=models.CASCADE,related_name='boys')


views

from django.shortcuts import render,HttpResponse,redirect
from app01 import models

# Create your views here.

def test(request):
    # boy = models.Userinfo.objects.filter(gender=1,id=1).first()
    # girl = models.Userinfo.objects.filter(gender=2,id=5).first()
    # models.U2U.objects.create(b=boy,g=girl)

    # models.U2U.objects.create(b_id=1,g_id=4)
    # models.U2U.objects.create(b_id=1,g_id=5)
    # models.U2U.objects.create(b_id=1,g_id=6)

    # models.U2U.objects.create(b_id=2,g_id=4)
    # models.U2U.objects.create(b_id=3,g_id=4)
    # models.U2U.objects.create(b_id=2,g_id=5)



    aaron = models.Userinfo.objects.filter(id=1).first()
    result = aaron.girls.all()
    # print(result)
    for u in result:
        print(u.g.nickname)

    alice = models.Userinfo.objects.filter(id=4).first()
    alice_boys = alice.boys.all()
    for b in alice_boys:
        print(b.b.nickname)
    return HttpResponse('success')

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值