如何在Django的不同模型的任何两个字段之间建立一对一的关系？

Question

class HmsMedicine(models.Model):
    id = models.IntegerField(primary_key=True)
    medicine_name = models.CharField(max_length=100)
    price = models.IntegerField(max_length=6)

class HmsBilling(models.Model):
    id = models.IntegerField(primary_key=True)
    regid = models.ForeignKey(HmsPatient, db_column='regid')
    medicine = models.ForeignKey(HmsMedicine, db_column='medicine')
    quantity = models.IntegerField()
    rate = models.IntegerField()

我想在rate字段中有price字段的值。你知道吗

Answer 1

class HmsBilling(models.Model):
    id = models.IntegerField(primary_key=True)
    regid = models.ForeignKey(HmsPatient, db_column='regid')
    medicine = models.ForeignKey(HmsMedicine, db_column='medicine')
    quantity = models.IntegerField()
    rate = models.ForeignKey(HmsMedicine, db_column='price')

hms = HmsBilling.objects.select_related().get(id=5)
hms.rate

这将为您提供id=5的账单的价格（请参见this link以获取有关选择的参考）

更好：

class HmsBilling(models.Model):
    id = models.IntegerField(primary_key=True)
    medicine = models.ForeignKey(HmsMedicine)
    quantity = models.IntegerField()

hms = HmsBilling.objects.select_related().get(id=5)
hms.medicine.price