如何通过比较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.
更多推荐
发布评论