{"id":10911,"date":"2022-09-25T11:03:00","date_gmt":"2022-09-25T05:33:00","guid":{"rendered":"http:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/"},"modified":"2022-09-25T11:03:00","modified_gmt":"2022-09-25T05:33:00","slug":"solved-how-to-convert-an-sql-output-to-a-python-list-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/","title":{"rendered":"[Solved] How to convert an SQL Output to a python list [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-60462516\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"60462516\" data-parentid=\"60462197\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>It is minimal example which create database with two elements and later it uses data from database to fill Treeview<\/p>\n<p>You have to use <code>create()<\/code> only once.<\/p>\n<pre><code>import tkinter as tk\nfrom tkinter import ttk\nimport sqlite3\n\ndef create(con):\n    cur = con.cursor()\n\n    cur.execute('''CREATE TABLE IF NOT EXISTS  user (\n        id INTEGER PRIMARY KEY,\n        name TEXT NOT NULL,\n        age TEXT NOT NULL,\n        email TEXT NOT NULL UNIQUE,\n        town TEXT NOT NULL\n    );''')\n\n    cur.execute('INSERT INTO user (name, age, email, town) values(\"James Bond\", 45, \"bond@mi6.uk\", \"London\")')\n    cur.execute('INSERT INTO user (name, age, email, town) values(\"Rambo\", 45, \"rambo@usa.com\", \"Washington\")')\n\n    con.commit()\n\n# --- main ---\n\ncon = sqlite3.connect(\"user_info.db\")\ncur = con.cursor()\n\ncreate(con)\n\nroot = tk.Tk()\n\ntv = ttk.Treeview(root)\ntv.pack(fill=\"both\", expand=True)\ntv.config(columns= (\"name\", 'age', 'email', 'town'))\n\ntv.heading('#0', text=\"ID\")\ntv.column('#0', width = 100)\n\ntv.heading('1', text = \"Age\")\ntv.column('1', width = 100)\n\ntv.heading('name', text=\"Name\")\ntv.column('name', width = 100)\n\ntv.heading('2', text = \"email\")\ntv.column(\"2\", width = 100)\n\ntv.heading('3', text = \"Town\")\ntv.column(\"3\", width = 100)\n\ncur.execute('SELECT * FROM user')\nfor number, row in enumerate(cur.fetchall()):\n    print(row)\n    item = 'item{}'.format(number)\n    tv.insert(\"\", 'end', item, text=row[0])\n    tv.set(item, 'name', row[1])\n    tv.set(item, 'age', row[2])\n    tv.set(item, 'email', row[3])\n    tv.set(item, 'town', row[4])\n\nroot.mainloop()\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How to convert an SQL Output to a python list [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] It is minimal example which create database with two elements and later it uses data from database to fill Treeview You have to use create() only once. import tkinter as tk from tkinter import ttk import sqlite3 def create(con): cur = con.cursor() cur.execute(&#8221;&#8217;CREATE TABLE IF NOT EXISTS user ( id INTEGER PRIMARY KEY, name &#8230; <a title=\"[Solved] How to convert an SQL Output to a python list [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\" aria-label=\"More on [Solved] How to convert an SQL Output to a python list [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[349,341,707,768],"class_list":["post-10911","post","type-post","status-publish","format-standard","hentry","category-solved","tag-python","tag-sql","tag-sqlite","tag-tkinter"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How to convert an SQL Output to a python list [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to convert an SQL Output to a python list [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] It is minimal example which create database with two elements and later it uses data from database to fill Treeview You have to use create() only once. import tkinter as tk from tkinter import ttk import sqlite3 def create(con): cur = con.cursor() cur.execute(&#039;&#039;&#039;CREATE TABLE IF NOT EXISTS user ( id INTEGER PRIMARY KEY, name ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-25T05:33:00+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to convert an SQL Output to a python list [closed]\",\"datePublished\":\"2022-09-25T05:33:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\"},\"wordCount\":52,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"python\",\"sql\",\"sqlite\",\"tkinter\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\",\"name\":\"[Solved] How to convert an SQL Output to a python list [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-25T05:33:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to convert an SQL Output to a python list [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to convert an SQL Output to a python list [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to convert an SQL Output to a python list [closed] - JassWeb","og_description":"[ad_1] It is minimal example which create database with two elements and later it uses data from database to fill Treeview You have to use create() only once. import tkinter as tk from tkinter import ttk import sqlite3 def create(con): cur = con.cursor() cur.execute('''CREATE TABLE IF NOT EXISTS user ( id INTEGER PRIMARY KEY, name ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-25T05:33:00+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to convert an SQL Output to a python list [closed]","datePublished":"2022-09-25T05:33:00+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/"},"wordCount":52,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["python","sql","sqlite","tkinter"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/","name":"[Solved] How to convert an SQL Output to a python list [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-25T05:33:00+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-convert-an-sql-output-to-a-python-list-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to convert an SQL Output to a python list [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=10911"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10911\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}