I haven’t tried this, but I’m relatively sure you can just set it as a default in your field. pic = models.ImageField(upload_to=’blah’, default=”path/to/my/default/image.jpg”) EDIT: Stupid StackOverflow won’t let me comment on other people’s answers, but that old snippet is not what you want. I highly recommend django-imagekit because it does tons of great image resizing … Read more
I solved it like this: MyClass.objects.filter(name__iexact=my_parameter) There is even a way to use it for substring search: MyClass.objects.filter(name__icontains=my_parameter) There’s a link to the documentation.
from django.db.models import Q User.objects.filter(Q(income__gte=5000) | Q(income__isnull=True)) via Documentation
This is exactly what select_related() does. The only gotcha is that you have to start with the Answer model, rather than Question, but the result is the same: answers = Answer.objects.filter(question_id=1).select_related() Now each answer object has a pre-fetched ‘question’ attribute, and accessing it won’t hit the db again.
You can convert it into string by using JSON and store it as string. For example, In [3]: json.dumps([[1, 3, 4], [4, 2, 6], [8, 12, 3], [3, 3, 9]]) Out[3]: ‘[[1, 3, 4], [4, 2, 6], [8, 12, 3], [3, 3, 9]]’ You can add a method into your class to convert it automatically … Read more
From django>=1.8 you can use annotate and F object from django.db.models import F MyModel.objects.annotate(renamed_value=F(‘cryptic_value_name’)).values(‘renamed_value’) Also extra() is going to be deprecated, from the django docs: This is an old API that we aim to deprecate at some point in the future. Use it only if you cannot express your query using other queryset methods. If … Read more
If you’re using Django >= 1.6, there’s a BinaryField
Since Django 1.8 it is possible with: from django.db.models.functions import Lower MyModel.objects.order_by(Lower(‘myfield’)) https://code.djangoproject.com/ticket/6498
Nate C was close, but not quite. From the docs: You can evaluate a QuerySet in the following ways: Iteration. A QuerySet is iterable, and it executes its database query the first time you iterate over it. For example, this will print the headline of all entries in the database: for e in Entry.objects.all(): print … Read more
Try: from django.db.models import Count Literal.objects.values(‘name’) .annotate(Count(‘id’)) .order_by() .filter(id__count__gt=1) This is as close as you can get with Django. The problem is that this will return a ValuesQuerySet with only name and count. However, you can then use this to construct a regular QuerySet by feeding it back into another query: dupes = Literal.objects.values(‘name’) .annotate(Count(‘id’)) … Read more