📌 Flask SQLite CRUD API
This is a simple Flask + SQLite API project that demonstrates how to perform basic CRUD (Create, Read, Update, Delete) operations. The project is designed to be tested using Postman (no frontend/webpage).
🚀 Features
Create an item (Name, Email)
Read all items
Update an item by ID
Delete an item by ID
SQLite database (my_database.db) for persistence
🗂️ Project Structure
├── app.py # Main Flask app (routes)
├── databaseconnection.py # Database connection helper
├── models.py # Database operations (CRUD logic)
├── my_database.db # SQLite database (auto-created)
└── README.md # Project documentation
⚙️ Installation & Setup
- Clone this repository
git clone <repo_url>
cd flask-crud-api
- Create a virtual environment (recommended)
python -m venv venv
source venv/bin/activate # Mac/Linux
venv\Scripts\activate # Windows
- Run the server
python app.py
🛠️ Testing with Postman
Test endpoints:
POST /items → Add data
GET /items → View all data
PUT /items/ → Update data
DELETE /items/ → Delete data