This project integrates Python and SQL allows you to manage customer purchases, generate invoices, track stock, and log transactions automatically Integrated automatic database updates with live user inputs from Python. Every purchase entered through Python is automatically updated in the SQL database in real-time.
Python:
Connects to MySQL database using mysql.connector. Lets users make new purchases or update existing ones. Generates invoice-like receipts with customer, product, quantity, price, stock, and payment method details. Supports viewing tables like Stock, Product, Category, and Transaction Logs. Shows purchase summaries for all or specific customers.
SQL:
Creates the database tosqppy with tables: Category, Product, Stock, Customer, and TransactionLog. Inserts initial categories, products, and stock data. Implements triggers to: Calculate total price automatically. Update stock after purchases. Log all insert and update actions in TransactionLog.
- Real-time data synchronization between Python and SQL
- Multi-table joins for relational data analysis
- SQL triggers for automatic record updates
- Automatic database updates with live user inputs
- Automatic invoice generation
- Real-time stock management
- Transaction logging for audit
- Python
- MySQL
- SQL Triggers & Joins