Assignment: SQLite Python Simulation

Overview

This project simulates a distributed system using SQLite databases. It includes three models (Users, Products, and Orders) stored in separate databases, with data inserted concurrently using Python's threading module.

Features

• Separate SQLite databases for Users, Products, and Orders.
• Concurrent data insertion using threads.
• Application-level data validation.

Files

• main.py: The Python script containing the implementation.
• Generated Databases: Automatically created after running the script:
  • users.db
  • products.db
  • orders.db

Prerequisites

• Python 3.x
• SQLite3
• DB Browser for SQLite for verification.

How to Run

1. Clone or download the project files.
2. Navigate to the project directory.
3. Execute the script:

   python main.py

4. The script will create the databases and insert data concurrently.

Verifying the Output

1. Open the database files (users.db, products.db, orders.db) in a tool like DB Browser for SQLite.
2. Run queries to check the data:

   SELECT * FROM Users;
   SELECT * FROM Products;
   SELECT * FROM Orders;

Notes

• Ensure a valid Python environment is set up before running the script.
• This project demonstrates basic concurrency and SQLite usage in Python.

Thankyou