Generating PDF using inputs through Tkinter GUI and data from SQLite Database

• Initialize a Tkinter window to create the GUI with input fields and buttons.
• Set up a database connection using SQLAlchemy to connect to an SQLite database.
• Create an input field for the user to enter a student ID.
• Implement the `save_file()` function to open a file save dialog and pass the selected path to `save_pdf()`.
• In `save_pdf()`, query the database for the student ID, retrieve the data, and use ReportLab to write this data into a PDF.
• Save and close the PDF, then close the Tkinter window.

Generate PDF from user input and data from SQLite table →

SQLite3 The command line tool to manage SQLite Database

• Downloading and installing the SQLite3 command-line tool
• Running the SQLite3 command-line tool
• Understanding the help and quit commands
• Opening or creating a database file
• Creating a table
• Inserting data into a table
• Retrieving data from a table using a SELECT query
• Using the mode command to manage the display

SQLite3 Command Line tool to Manage SQLite Database →

Data Transfer from Google sheets to MySQL and vice versa

By using Pandas DataFrame we can transfer data from MySQL database table to Google sheets and from Google sheets to MySQL.
Generate PDF files with Charts and Images →