如何通过比较Django视图文件中相同模型的其他字段来获取唯一一个字段(How to get only one field by comparing other field of same model

如何通过比较Django视图文件中相同模型的其他字段来获取唯一一个字段(How to get only one field by comparing other field of same model in view file of Django)

我想运行这个查询：

"SELECT pname FROM PaientSignup WHERE email=p_email"

我使用过滤器方法，给我所有其他与给定的电子邮件相匹配的数据。

p= PatientSignup.objects.filter(email=p_email)

从那个输出我无法取得病人的名字。

models.py

class PatientSignup(models.Model): pid = models.AutoField(verbose_name='Patient Id', primary_key=True, auto_created=True) pname = models.CharField(verbose_name='Enter Name', max_length=50, default=NameError) email = models.CharField(verbose_name='Enter Email', max_length=100,unique=True) age = models.PositiveIntegerField(verbose_name='Enter age',default=5, null=True) password = models.CharField(verbose_name='Enter Password',max_length=12)

views.py

def pFeedback(request): #feedback = textarea input p_email = request.session['pusername'] #here, I want only patient name->pname to store in database saveFeedback = patientFeedback() saveFeedback.feedback = feedback saveFeedback.patientName = patient saveFeedback.save()

I want to run this query:

"SELECT pname FROM PaientSignup WHERE email=p_email"

I used filter method that gives me all other data that match with email given.

p= PatientSignup.objects.filter(email=p_email)

From that output I could not able to fetch on name of patient.

models.py

class PatientSignup(models.Model): pid = models.AutoField(verbose_name='Patient Id', primary_key=True, auto_created=True) pname = models.CharField(verbose_name='Enter Name', max_length=50, default=NameError) email = models.CharField(verbose_name='Enter Email', max_length=100,unique=True) age = models.PositiveIntegerField(verbose_name='Enter age',default=5, null=True) password = models.CharField(verbose_name='Enter Password',max_length=12)

views.py

def pFeedback(request): #feedback = textarea input p_email = request.session['pusername'] #here, I want only patient name->pname to store in database saveFeedback = patientFeedback() saveFeedback.feedback = feedback saveFeedback.patientName = patient saveFeedback.save()

最满意答案

试试PatientSignup.objects.filter(email=p_email).values_list('pname', flat=True) 。 它将返回与电子邮件匹配的名称列表。

Try PatientSignup.objects.filter(email=p_email).values_list('pname', flat=True). It will returns list of names matching with email.