Gorbunova-Varvara

🏛️ Museum Exhibition Management API

A comprehensive REST API for managing museum exhibitions, artifacts, owners, and movements across Russia. Built with FastAPI and SQLAlchemy.

🚀 Features

👥 Owner Management - Complete CRUD for artifact owners
🖼️ Artifact Management - Manage museum artifacts with types and profitability
🏛️ Exhibition Venues - Handle multiple exhibition locations across Russia
🚚 Movement Tracking - Track artifact movements between venues
📊 Analytics - Advanced analytics and business intelligence
🔍 SQL Query Logging - Every response includes executed SQL queries for learning

🛠️ Tech Stack

FastAPI - Modern, fast web framework for APIs
SQLAlchemy - SQL toolkit and ORM
SQLite - Database (easily switchable to PostgreSQL/MySQL)
Pydantic - Data validation and settings management
Faker - Test data generation
Uvicorn - ASGI server

📋 API Endpoints

👥 CUSTOM

👥 Owners

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/owners/ | Get all owners | | GET | /api/v1/owners/{id} | Get owner by ID | | GET | /api/v1/owners/{email}/wings | Get owner’s artifacts by email |

🖼️ Artifacts (Wings)

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/wings/ | Get all artifacts | | GET | /api/v1/wings/{id} | Get artifact by ID | | PUT | /api/v1/wings/{id} | Update artifact information |

🏛️ Exhibition Venues

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/places/ | Get all exhibition venues | | GET | /api/v1/places/{id} | Get venue by ID |

🚚 Movements

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/moves/ | Get all movements | | POST | /api/v1/moves/ | Create new movement | | DELETE | /api/v1/moves/{id} | Delete movement |

🏷️ Artifact Types

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/types/ | Get all artifact types | | GET | /api/v1/types/{id} | Get type by ID |

📊 Analytics

| Method | Endpoint | Description | |——–|———-|————-| | GET | /api/v1/analytics/owner-most-wings | Owner with most artifacts | | GET | /api/v1/analytics/most-expensive-wing | Most expensive artifact movement | | GET | /api/v1/analytics/most-profitable-wing | Most profitable artifact | | GET | /api/v1/analytics/most-profitable-place | Most profitable venue | | GET | /api/v1/analytics/most-popular-type | Most popular artifact type | | GET | /api/v1/analytics/wing-move-frequency/{id} | Artifact movement frequency |

🗄️ Database Schema

owners (id, email, first_name, last_name, middle_name, birth_date)
types (id, name)
wings (id, owner_id, type_id, profit, name)
places (id, location, scale)
moves (id, wing_id, place_id, price, dt)

🚀 Quick Start Guide

Step 1: Clone and Setup

git clone <repository-url>
cd museum-api
python -m venv .venv

# Windows: .venv\Scripts\activate
# macOS/Linux: source .venv/bin/activate

Step 2: Install requirements

pip install -r requirements.txt

Step 3: Run application

python run.py

This site is open source. Improve this page.