How to get names of columns from QuerySet without executing it

[Eugene Kulak]

How to get names of columns from QuerySet without executing it?

If it is not possible what would be the most easier way to execute a lighter version of the query. 

The query itself is unknown, it could be anything.

[Akinfolarin Stephen]

you can filter out the column you want by using 

[name of model].objects.get(filter=[name of the column you want])

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/60c63ddd-80fa-44c5-9a8e-10091e307099o%40googlegroups.com.

[Vishesh Mangla]

I think learning some sql commands would be good. Lots of youtube tuts available online. https://docs.djangoproject.com/en/3.0/topics/db/sql/#executing-custom-sql-directly

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFujGLyz6U%3D4t3RSiiAzOo5jkXiCc7bcvzYYyD4do3R-fgbdoQ%40mail.gmail.com.

[Eugene Kulak]

Thank you, Stephen, but this is not what I asked. I can't change QuerySet and I don't know how it looks like.

On Saturday, July 4, 2020 at 4:30:40 PM UTC-4, Akinfolarin Stephen wrote:

you can filter out the column you want by using 

[name of model].objects.get(filter=[name of the column you want])

On Sun, Jul 5, 2020 at 10:12 AM Eugene Kulak <widowmak...@gmail.com> wrote:

How to get names of columns from QuerySet without executing it?

If it is not possible what would be the most easier way to execute a lighter version of the query. 

The query itself is unknown, it could be anything.

--
You received this message because you are subscribed to the Google Groups "Django users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.

[Eugene Kulak]

I think reading the question first and answer only when you have anything to say is even better?

On Saturday, July 4, 2020 at 5:08:04 PM UTC-4, Vishesh Mangla wrote:

I think learning some sql commands would be good. Lots of youtube tuts available online. https://docs.djangoproject.com/en/3.0/topics/db/sql/#executing-custom-sql-directly

On Sun, Jul 5, 2020 at 1:59 AM Akinfolarin Stephen <akinfolar...@gmail.com> wrote:

you can filter out the column you want by using 

[name of model].objects.get(filter=[name of the column you want])

On Sun, Jul 5, 2020 at 10:12 AM Eugene Kulak <widowmak...@gmail.com> wrote:

How to get names of columns from QuerySet without executing it?

If it is not possible what would be the most easier way to execute a lighter version of the query. 

The query itself is unknown, it could be anything.

--
You received this message because you are subscribed to the Google Groups "Django users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/60c63ddd-80fa-44c5-9a8e-10091e307099o%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.

[Eugene Kulak]

The closes I can get with this is the following:

comp = queryset.query.get_compiler(DEFAULT_DB_ALIAS)
fields = [alias or sql.split('.')[1] for _, (sql, _), alias in comp.get_select()[0]]

[Michael Fladischer]

What about introspecting the model associated with the QuerySet:

qs = SomeModel.objects.all()
columns = [f.column for f in qs.model._meta.fields]

Regards, Michael

[Eugene Kulak]

Michael, this will not work for cases with `values` and `annotations`

[Dvil Djé]

For a light version of the query, you can try a qs.first() as Django will limit the SQL request to the first element.