Latest posts on Insert data into ttk.treeview widget to specific column topichttp://python.su/forum/topic/39179/2020-06-29T11:58:03+03:00Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-29T11:58:03+03:00Feelgood210967<strong>xam1816</strong><br/>агонь) всё красиво, спасибо!!!
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-26T20:25:56+03:00xam1816210944тогда так<br/><div class="code"><pre> <span class="n">tree</span><span class="o">.</span><span class="n">insert</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span> <span class="s1">'end'</span><span class="p">,</span> <span class="n">values</span><span class="o">=</span><span class="p">(</span><span class="s2">""</span><span class="p">,</span><span class="n">row</span><span class="p">[</span><span class="mi">0</span><span class="p">],</span><span class="n">row</span><span class="p">[</span><span class="mi">1</span><span class="p">],</span><span class="n">row</span><span class="p">[</span><span class="mi">2</span><span class="p">]))</span>
</pre></div>
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-26T18:45:22+03:00Feelgood210943<strong>xam1816</strong><br/>Да будет нумерация по порядку, ID тоже доделаю.<br/><br/>Тогда оно всё в один столбец помещает, скрин прикрепил:<br/><div class="code"><pre> <span class="p">[</span><span class="bp">self</span><span class="o">.</span><span class="n">tree</span><span class="o">.</span><span class="n">insert</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span> <span class="s1">'end'</span><span class="p">,</span> <span class="n">values</span><span class="o">=</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span><span class="n">row</span><span class="p">))</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="bp">self</span><span class="o">.</span><span class="n">db</span><span class="o">.</span><span class="n">c</span><span class="o">.</span><span class="n">fetchall</span><span class="p">()]</span>
</pre></div>
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-25T22:49:07+03:00xam1816210939<blockquote><em>Feelgood</em><br/>вставка начинается из первого столбца, а мне нужно чтоб начиналось со второго столбца.</blockquote>а в первом столбце что будет? не понятно,там будет ID из базы данных,или просто нумерация в дереве по порядку<br/><br/>или как-то так<br/><br/><div class="code"><pre> <span class="p">[</span><span class="bp">self</span><span class="o">.</span><span class="n">tree</span><span class="o">.</span><span class="n">insert</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span> <span class="s1">'end'</span><span class="p">,</span> <span class="n">values</span><span class="o">=</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span><span class="n">row</span><span class="p">))</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="bp">self</span><span class="o">.</span><span class="n">db</span><span class="o">.</span><span class="n">c</span><span class="o">.</span><span class="n">fetchall</span><span class="p">()]</span>
</pre></div>
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-25T22:14:30+03:00Feelgood210938<strong>ZerG</strong><br/>Код с treeview - это тестово для форума, а функция из реального приложения… Когда тяну из БД 3 поля, и вставляю в виджет treeview в котором 4 столбца, соответственно вставка начинается из первого столбца, а мне нужно чтоб начиналось со второго столбца.
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-25T09:46:27+03:00ZerG210935Для начала можно просто руками набросать данные и попробовать и посомтреть как оно выглядити работает <br/>а потом уже с базы тянуть.
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-24T23:47:27+03:004kpt_V210933А как данные получить?<br/>Сначала просто получите данные, отпринтуйте их, а потом уже смело вставляйте.
Общий :: GUI :: Insert data into ttk.treeview widget to specific column
2020-06-24T22:10:41+03:00Feelgood210932Всем привет!<br/>Вопрос состоит в том, как вставить в treeview данные из БД начиная из столбца “description”, <br/>(если что код treeview приведен справочно)<br/><br/><div class="code"><pre> <span class="kn">import</span> <span class="nn">tkinter</span> <span class="kn">as</span> <span class="nn">tk</span>
<span class="kn">from</span> <span class="nn">tkinter</span> <span class="kn">import</span> <span class="n">ttk</span>
<span class="n">root</span> <span class="o">=</span> <span class="n">tk</span><span class="o">.</span><span class="n">Tk</span><span class="p">()</span>
<span class="n">root</span><span class="o">.</span><span class="n">title</span><span class="p">(</span><span class="s2">"Household finance"</span><span class="p">)</span>
<span class="n">root</span><span class="o">.</span><span class="n">geometry</span><span class="p">(</span><span class="s2">"665x360"</span><span class="p">)</span>
<span class="n">tree</span> <span class="o">=</span> <span class="n">ttk</span><span class="o">.</span><span class="n">Treeview</span><span class="p">(</span><span class="n">columns</span><span class="o">=</span><span class="p">(</span><span class="s1">'ID'</span><span class="p">,</span> <span class="s1">'description'</span><span class="p">,</span> <span class="s1">'costs'</span><span class="p">,</span> <span class="s1">'total'</span><span class="p">),</span> <span class="n">height</span><span class="o">=</span><span class="mi">15</span><span class="p">,</span> <span class="n">show</span><span class="o">=</span><span class="s1">'headings'</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">column</span><span class="p">(</span><span class="s1">'ID'</span><span class="p">,</span> <span class="n">width</span><span class="o">=</span><span class="mi">30</span><span class="p">,</span> <span class="n">anchor</span><span class="o">=</span><span class="n">tk</span><span class="o">.</span><span class="n">CENTER</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">column</span><span class="p">(</span><span class="s1">'description'</span><span class="p">,</span> <span class="n">width</span><span class="o">=</span><span class="mi">365</span><span class="p">,</span> <span class="n">anchor</span><span class="o">=</span><span class="n">tk</span><span class="o">.</span><span class="n">CENTER</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">column</span><span class="p">(</span><span class="s1">'costs'</span><span class="p">,</span> <span class="n">width</span><span class="o">=</span><span class="mi">150</span><span class="p">,</span> <span class="n">anchor</span><span class="o">=</span><span class="n">tk</span><span class="o">.</span><span class="n">CENTER</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">column</span><span class="p">(</span><span class="s1">'total'</span><span class="p">,</span> <span class="n">width</span><span class="o">=</span><span class="mi">100</span><span class="p">,</span> <span class="n">anchor</span><span class="o">=</span><span class="n">tk</span><span class="o">.</span><span class="n">CENTER</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">heading</span><span class="p">(</span><span class="s1">'ID'</span><span class="p">,</span> <span class="n">text</span><span class="o">=</span><span class="s1">'ID'</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">heading</span><span class="p">(</span><span class="s1">'description'</span><span class="p">,</span> <span class="n">text</span><span class="o">=</span><span class="s1">'Наименование'</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">heading</span><span class="p">(</span><span class="s1">'costs'</span><span class="p">,</span> <span class="n">text</span><span class="o">=</span><span class="s1">'Статья дохода/расхода'</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">heading</span><span class="p">(</span><span class="s1">'total'</span><span class="p">,</span> <span class="n">text</span><span class="o">=</span><span class="s1">'Сумма'</span><span class="p">)</span>
<span class="n">tree</span><span class="o">.</span><span class="n">pack</span><span class="p">()</span>
<span class="n">root</span><span class="o">.</span><span class="n">mainloop</span><span class="p">()</span>
</pre></div><br/>Функция извлечения и вставки в treeview. <br/><br/><div class="code"><pre> <span class="k">def</span> <span class="nf">view_records</span><span class="p">(</span><span class="bp">self</span><span class="p">):</span>
<span class="bp">self</span><span class="o">.</span><span class="n">db</span><span class="o">.</span><span class="n">c</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s1">'''SELECT description, costs, total FROM finance'''</span><span class="p">)</span>
<span class="p">[</span><span class="bp">self</span><span class="o">.</span><span class="n">tree</span><span class="o">.</span><span class="n">delete</span><span class="p">(</span><span class="n">i</span><span class="p">)</span> <span class="k">for</span> <span class="n">i</span> <span class="ow">in</span> <span class="bp">self</span><span class="o">.</span><span class="n">tree</span><span class="o">.</span><span class="n">get_children</span><span class="p">()]</span>
<span class="p">[</span><span class="bp">self</span><span class="o">.</span><span class="n">tree</span><span class="o">.</span><span class="n">insert</span><span class="p">(</span><span class="s1">''</span><span class="p">,</span> <span class="s1">'end'</span><span class="p">,</span> <span class="n">values</span><span class="o">=</span><span class="n">row</span><span class="p">)</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="bp">self</span><span class="o">.</span><span class="n">db</span><span class="o">.</span><span class="n">c</span><span class="o">.</span><span class="n">fetchall</span><span class="p">()]</span>
</pre></div>