Consult several Django models

Question

Consult several Django models

Navigation

#1 by (1 votes)
#2 by (1 votes)

1

I have these models:

class TablaA(models.Model):
    estado = models.BooleanField()
    # mas campos...

class TablaB(models.Model):
    tabla_a = models.ForeignKey(TablaA)
    estado = models.BooleanField()
    # mas campos...

class TablaC(models.Model):
    tabla_a = models.ForeignKey(TablaA)
    # mas campos...

What I need is to have the data of TablaC when the fields estado of TablaA and% TablaB are False .

How is it possible to do this?

django django-models

asked by Christian M 17.01.2017 в 01:14

source

2 answers

Why is the error, in this fragment? Hide the value of an input in an html5 form

score 1 · Answer 1

ps you could do it like that ..

from yourapp import models
a = models.TablaA
b = models.TablaB
c = models.TablaC
if a.estado == False and b.estado == False:
  return c.tabla_a

You can return c.table_a or any other data that is in the table.

You tell me how you are doing

greetings

score 1 · Answer 2

I solved it using select_related() and FOO_set .

data = TablaB.objects.filter(tabla_a__Estado=False)

And in the template when going through:

{% for d in data %}
    data.tabla_c.tablaa_set.all
    {{ data.foo.bar }}
{% endfor %}

Taking into account that in TablaB there is also a reference to TablaC.

However now, in another section of the application, I need to do it in a single query so that in the template I can only go through and no longer make an additional query. I still can not do it.