Latest posts on Помогите с фильтром Queryset topichttps://python.su/forum/topic/38378/2020-01-31T10:01:02+02:00Веб-технологии :: Django :: Помогите с фильтром Queryset
2020-01-31T10:01:02+02:00W7NTED207117<blockquote><em>m0nte-cr1st0</em><br/></blockquote>спс за наводку и помощ, получилось так<br/><div class="code"><pre> <span class="n">Candidate</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">planet</span><span class="o">=</span><span class="n">Jedi</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="nb">id</span><span class="o">=</span><span class="mi">2</span><span class="p">)</span><span class="o">.</span><span class="n">planet</span><span class="p">,</span> <span class="n">tested</span><span class="o">=</span><span class="bp">True</span><span class="p">)</span>
</pre></div>
Веб-технологии :: Django :: Помогите с фильтром Queryset
2020-01-31T09:40:19+02:00m0nte-cr1st0207116<blockquote><em>W7NTED</em><br/>NameError: name ‘jedi’ is not defined</blockquote>Я понятия не имею, в какой переменной ты хранишь объект.
Веб-технологии :: Django :: Помогите с фильтром Queryset
2020-01-31T09:04:31+02:00W7NTED207115<blockquote><em>m0nte-cr1st0</em><br/></blockquote>первый фильтр отрабатывает, второй пишет <br/><div class="code"><pre> <span class="ne">NameError</span><span class="p">:</span> <span class="n">name</span> <span class="s1">'jedi'</span> <span class="ow">is</span> <span class="ow">not</span> <span class="n">defined</span>
</pre></div>при<br/><div class="code"><pre> <span class="n">Candidate</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">planet</span><span class="o">=</span><span class="n">Jedi</span><span class="o">.</span><span class="n">planet</span><span class="p">)</span>
</pre></div><div class="code"><pre> <span class="ne">TypeError</span><span class="p">:</span> <span class="n">Field</span> <span class="s1">'id'</span> <span class="n">expected</span> <span class="n">a</span> <span class="n">number</span> <span class="n">but</span> <span class="n">got</span> <span class="o"><</span><span class="n">django</span><span class="o">.</span><span class="n">db</span><span class="o">.</span><span class="n">models</span><span class="o">.</span><span class="n">fields</span><span class="o">.</span><span class="n">related_descriptors</span>
</pre></div><br/>
Веб-технологии :: Django :: Помогите с фильтром Queryset
2020-01-31T00:12:33+02:00m0nte-cr1st0207112<div class="code"><pre> <span class="n">candidates</span> <span class="o">=</span> <span class="n">Candidate</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">tested</span><span class="o">=</span><span class="bp">True</span><span class="p">,</span> <span class="n">planet</span><span class="o">=</span><span class="n">jedi</span><span class="o">.</span><span class="n">planet</span><span class="p">)</span>
</pre></div>
Веб-технологии :: Django :: Помогите с фильтром Queryset
2020-01-30T23:01:27+02:00W7NTED207111никак не получается победить фильтрацию объектов<br/><br/>Суть, есть модели <br/><div class="code"><pre> <span class="k">class</span> <span class="nc">Planet</span><span class="p">(</span><span class="n">models</span><span class="o">.</span><span class="n">Model</span><span class="p">):</span>
<span class="n">planet</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">CharField</span><span class="p">(</span><span class="n">max_length</span><span class="o">=</span><span class="mi">25</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Планета'</span><span class="p">)</span>
<span class="k">class</span> <span class="nc">Candidate</span><span class="p">(</span><span class="n">models</span><span class="o">.</span><span class="n">Model</span><span class="p">):</span>
<span class="n">name_c</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">CharField</span><span class="p">(</span><span class="n">max_length</span><span class="o">=</span><span class="mi">25</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Имя'</span><span class="p">)</span>
<span class="n">planet</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">ForeignKey</span><span class="p">(</span>
<span class="n">Planet</span><span class="p">,</span> <span class="n">on_delete</span><span class="o">=</span><span class="n">models</span><span class="o">.</span><span class="n">CASCADE</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Планета'</span><span class="p">)</span>
<span class="n">tested</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">BooleanField</span><span class="p">(</span><span class="n">default</span><span class="o">=</span><span class="bp">False</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Протестирован?'</span><span class="p">)</span>
<span class="k">class</span> <span class="nc">Jedi</span><span class="p">(</span><span class="n">models</span><span class="o">.</span><span class="n">Model</span><span class="p">):</span>
<span class="n">name_j</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">CharField</span><span class="p">(</span><span class="n">max_length</span><span class="o">=</span><span class="mi">20</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Имя'</span><span class="p">)</span>
<span class="n">planet</span> <span class="o">=</span> <span class="n">models</span><span class="o">.</span><span class="n">ForeignKey</span><span class="p">(</span>
<span class="n">Planet</span><span class="p">,</span> <span class="n">on_delete</span><span class="o">=</span><span class="n">models</span><span class="o">.</span><span class="n">CASCADE</span><span class="p">,</span> <span class="n">verbose_name</span><span class="o">=</span><span class="s1">'Планета'</span><span class="p">)</span>
</pre></div>Есть известный id выбранного объекта Jedi, нужно отобрать в переменную все объекты Candidate у которых tested = True и такая же планета, как и у выше упомянутого Jedi c его id, <br/><br/>Тоесть оканчательная задача, показать этому Jedi.id список объектов Candidate, у которых совпадают два условия, tested = True, у Candidate и Jedi.id одинаковые планеты<br/>