Python/Tkinter SQL 'Interpreter' for Ms-Access or SQLite
Budget: $30 – $250 USD
In this assignment you fill in the missing parts of a preexisting Python/Tkinter program that reads a SQL script from a text file, parses that script into separate SQL statements, diplays these statements, one after the other, in a listbox, and sends them, one-by-one to either a SQLite or Ms-Access database for execution.
Although Ms-Access offers an interface for running SQL commands, it lacks a facility that can read a(n) SQL script and execute all of its statements. If later in this course you decide to use Ms-Access as your project database (which would be fine), the results of this assignment will be quite handy for quickly generating your Ms-Access database from a SQL script. If you decide to instead use SQLite for your project (which is just as fine), you will not need the code for this assignment later because SQLite does have that facility. In either case, however, this is a good exercise for practicing Python-database communications.
Although Ms-Access offers an interface for running SQL commands, it lacks a facility that can read a(n) SQL script and execute all of its statements. If later in this course you decide to use Ms-Access as your project database (which would be fine), the results of this assignment will be quite handy for quickly generating your Ms-Access database from a SQL script. If you decide to instead use SQLite for your project (which is just as fine), you will not need the code for this assignment later because SQLite does have that facility. In either case, however, this is a good exercise for practicing Python-database communications.