{"id":3335,"date":"2019-09-04T08:35:20","date_gmt":"2019-09-04T06:35:20","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=3335"},"modified":"2019-11-13T18:09:33","modified_gmt":"2019-11-13T17:09:33","slug":"python-sqlite3-part-3-reoganizing-the-code","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/python-sqlite3-part-3-reoganizing-the-code\/","title":{"rendered":"Python sqlite3 – part. 3: reoganizing the code"},"content":{"rendered":"

Let’s continue out example of possible use of sqlite3<\/strong> (database module) for Python<\/strong>. We created this GUI for our database with tkinter<\/strong> to show the basic use of both module, sqlite3 and tkinter. We added some widgets<\/strong> and some basic functions to create a database and a table<\/strong>. Now we want to make the GUI<\/strong> more clear and add some features like adding values. To see the table in the database you can use this free software<\/strong> DB Browser for Sqlite<\/a>.<\/p>\n

\"Risultati<\/a><\/p>\n

Video about the app until now<\/h2>\n

Click on the arrow in the middle to start the video with the way the app works explained.<\/p>\n

https:\/\/pythonprogramming.altervista.org\/wp-content\/uploads\/2019\/09\/sqlite3_3.mp4<\/a><\/video><\/div>\n

 <\/p>\n

Let’s re-organize our code<\/h2>\n

We want to get back and remake our code so that we can have different windows for different funtions, so that it is easier to manage the program.<\/p>\n

This is the code for the main window, the menu window<\/p>\n

import sqlite3 as lite\r\nfrom sqlite3 import Error\r\nimport tkinter as tk\r\nfrom glob import glob\r\n\r\nclass App:\r\n    def __init__(self, root):\r\n        self.root = root\r\n        self.root.geometry(\"300x100\")\r\n        self.root['bg'] = \"cyan\"\r\n        self.butnew(\"Create Database\", Win1)\r\n        self.butnew(\"Create Table\", Win2)\r\n    \r\n    def butnew(self, text, _class):\r\n        tk.Button(self.root, text = text, command=lambda: self.new_window(_class)).pack()\r\n        \r\n    def new_window(self, _class):\r\n        self.new = tk.TopLevel(self.root)\r\n        _class(self.new)\r\n    \r\n\r\nroot = tk.Tk()\r\nwin = App(root)\r\nroot.mainloop()<\/pre>\n
This is the output until now<\/p>\n
\"\"<\/a><\/p>\n
The App class code video<\/h2>\n
This is the video of the live coding of the menu window (see the code above) that will call the other 2 windows:<\/p>\n