how to Campare input string with database object

Question

Here when I give input to feature_name as newFeature, it gives me folder found but when I give newFeature123, it gives me folder not found

In FeatureCache table these two are newFeature123 and newFeature. These folder name are present but its match with newFeature but not with newFeature123.

views.py:

def passReviewerProjFeature(request):
    if request.method == 'POST':
        feature_name = request.POST['tcrsearch_id']
        project_id = request.POST['tcrproject_id']
        featureObjectarray=FeatureCache.objects.filter(project=project_id)
        for object in featureObjectarray:
               print object.name
               if feature_name not in str(object.name):
                   print feature_name
                   print "not Present"
                   return render(request,'index.html',{'errmsg':"Folder Not Found"})
               else:
                   return render(request,'index.html',{'errmsg':"Folder Found"})

sagarchalise · Accepted Answer · 2014-05-12 11:44:03Z

1

Look for field lookups in django queryset.

Basically contains and icontains may be what you are looking for:

FeatureCache.objects.filter(project__icontains=feature_name, project__exact=project_id)

which will do case insensitive lookup. Something like this:

featureObjectarray=FeatureCache.objects.filter(project__icontains=feature_name, project__exact=project_id)
if featureObjectarray.exists():
  return render(request,'index.html',{'errmsg':"Folder Found"})
else:
  print feature_name
  print "not Present"
  return render(request,'index.html',{'errmsg':"Folder Not Found"})

answered May 12, 2014 at 11:44

sagarchalise

1,0209 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to Campare input string with database object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related