Create a postAsk question

全部

内容 8|
RicciflowsRicciflows
|
8 months ago
|
Article

Django count RawQuerySet

QuestionHay, I'm using django 1.2 and i want to know how to count rows from a raw queryset(RawQuerySet).The traditional .count() method doesn't work.Heres my queryquery = "SELECT *, ((ACOS(SIN(%s * PI() / 180) * SIN(lat * PI() / 180) + COS(%s * PI() / 180) * COS(lat * PI() / 180) * COS((%s - lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance FROM app_car WHERE price BETWEEN %s AND %s HAVING distance<=%s ORDER BY distance ASC" cars = Car.objects.raw(query, [lat, lat, lon, min_price, ...

0
Like
292
0 comment
RicciflowsRicciflows
|
8 months ago
|
Article

django object has no attribute 'count'

QuestionI am learning django / python and I am stuck on an issue.I have a view: create_document.py in which I want to count the number of name details from a models class: NameDetails.I cannot get the correct syntax!Here is my models.py code:class NameDetails(FillableModelWithLanguageVersion): user = models.ForeignKey(User) name_details_prefix_title = models.CharField(null=True, blank=True, max_length=25) name_details_first_name = models.CharField(null=False, blank=False, max_length= ...

0
Like
273
0 comment
RicciflowsRicciflows
|
8 months ago
|
Question

Django change an existing field to foreign key

I have a Django model that used to look like this:class Car(models.Model): manufacturer_id = models.IntegerField()There is another model called Manufacturer that the id field refers to. However, I realized that it would be useful to use Django's built-in foreign key functionality, so I changed the model to this:class Car(models.Model): manufacturer = models.ForeignKey(Manufacturer)This change appears to work fine immediately, queries work without errors, but when I try to run migrations, ...

287
1 answer
NekomusumeNekomusume
|
10 months ago
|
Article

Django use __icontains with __in for field lookup

In Django, __icontains and __in are field lookups to the QuerySet methods. __icontains is a case-insensitive containment test, and __in means that the field is in a given iterable. So I would like to do the following lookup:keywords = ['How', 'to', 'setup', 'PrismJS', 'and', 'Autoloader', 'plugin', 'with', 'Nuxt', '3?'] #Possible keywords of title Writings.objects.filter(title__icontains__in=arr)Unfortunately, we can not combine field lookups in Django. To implement our desire, we can use Q() ob ...

0
Like
432
0 comment
RicciflowsRicciflows
|
a year ago
|
Article

Django ImageField max_length error when uploading image

I'm using Django 4.2. I have a model whose fields containing ImageField, for example:class Example(models.Model) image = models.ImageField( blank=True, upload_to=my_image_path, )When I uploaded my image, I got this error from django: Ensure this filename has at most 100 characters (it has 107).Taken from the Django documentation:FileField instances are created in your database as varchar columns with a default max length of 100 characters. As with other fields, you ...

0
Like
615
0 comment
NekomusumeNekomusume
|
a year ago
|
Article

Djano云服务器部署 uwsgi+nginx+https部署

Django启动服务器的命令runserver，其实也是启动了一个自带的uwsgi服务。如果想要一直在后台不停的运行django项目，需要部署uwsgi服务器。uwsgi安装官方文档：安装uWSGI — uWSGI 2.0 文档 (uwsgi-docs-zh.readthedocs.io)可以直接用pip安装uwsgi：pip install uwsgi在django项目根地址，即跟manage.py同目录下新建配置文件uwsgi.ini，如：mysite1/uwsgi.iniuwsgi.ini必须以[uwsgi]开头，内容如下：[uwsgi] chdir=/mysite1 module=mysite1.wsgi:application socket=127.0.0.1:8000 master=True pidfile=uwsgi.pid vacuum=True max-requests=5000 daemonize=uwsgi.logchdir为django项目根地址，socket为django启动服务器的ip地址，daemonize为日志地址。注意，每个django项目中自动生成一 ...

0
Like
586
0 comment
NekomusumeNekomusume
|
a year ago
|
Article

Django combine multiple QuerySets

Suppose that we have two different models.class Author(models.Model): name = models.CharField(max_length=50) class Article(models.Model): title = models.CharField(max_length=100) author = models.ForeignKey(Author)In certain circumstances, you might want to merge two querysets into one queryset. For example, you may want to combine Author.objects.all() and Article.objects.all(). You could accomplish this by pure python method itertools.chain, or using Django's inbuilt queryset method ...

0
Like
458
0 comment
RicciflowsRicciflows
|
a year ago
|
Article

How to split views.py to several smaller files in Django

When your views.py is too large, it becomes much more difficult to manage your code. So you might want to split views.py into several subviews, each of which contains a single sort of views.To split views.py, you could follow the following steps. Your original views.py might look like this:import ... def view1(request): pass def view2(request): passNow, create a new folder subviews aside with views.py , i.e. /Django/mysite/MyAPI/subviews. Next, create __init__.py, viewsa.py, and viewsb. ...

0
Like
507
0 comment