Skip to content

Latest commit

 

History

History
59 lines (35 loc) · 1.77 KB

README.md

File metadata and controls

59 lines (35 loc) · 1.77 KB
Raw

SQLxPython

Supermarket Database Management Software

This is a simple supermarket database management software developed using Python and the SQLite3 database. The software provides a graphical user interface (GUI) built with the Tkinter library for querying and managing data within the SQLite database.

Features

  • Display tables and their contents.
  • Execute custom SQL commands.
  • Add new rows to tables.

Requirements

  • Python 3.x
  • SQLite3

Getting Started

  1. Clone or download this repository to your local machine.
  2. Open a terminal and navigate to the project directory.

Usage

  1. Run the main.py script:

    python main.py

The GUI application will open, allowing you to perform various actions on the SQLite database.

Display Table: Select a table from the dropdown menu and click the "Display The Complete Table" button to view its contents.

Add Row: Select a table from the dropdown menu, enter values for the new row, and click the "Add Row" button to add the row to the table.

Custom Command: Enter a custom SQL command in the input field and click the "Execute" button to run the command and view the results.

Close the Application: Click the close button (X) on the application window to exit.

File Structure main.py: The main Python script containing the GUI application. functions.py: A separate Python file containing utility functions for interacting with the database. icon.ico: Icon file for the GUI window. SuperMarketDB.sqlite: Sample SQLite database file with mock data. Notes The provided SuperMarketDB.sqlite file contains mock data for demonstration purposes. The software is developed for educational purposes and can be extended with additional features and improvements. License This project is licensed under the MIT License.