How alshdevprojects/innowise_laboratory works
This repository is a set of progressively numbered programming exercises: terminal output, profile and grade-analysis scripts, a school database artifact, and two similar book-collection APIs. The principal application workflow is a client request routed by FastAPI handlers to CRUD operations, which use SQLAlchemy models and a SQLite database; Pydantic schemas define request and response shapes. Lecture 5 and lecture 6 are represented separately because each has its own implementation. The README provides no capability details, and unsampled exercises are shown without inferred internal relationships.
Main entry points: app/main.py Book API Routes · app/main.py Book API Routes · app/crud.py Book Operations · app/crud.py Book Operations
Components 20
Introductory Exercises
- Colored Greeting
lecture_1/main.py - Profile Exercise
lecture_2/profile.py - Grade Analyzer
lecture_3/student_grade_analyzer.py
School Data
- School SQL
lecture_4/school.sql - School Database
lecture_4/school.db
Lecture 5 API
- API Client
- Book API Routes
lecture_5/book_api/app/main.py - Book Operations
lecture_5/book_api/app/crud.py - Book ORM Model
lecture_5/book_api/app/models.py - Book Schemas
lecture_5/book_api/app/schemas.py - Database Setup
lecture_5/book_api/app/database.py - Books SQLite Store
lecture_5/book_api/books.db
Lecture 6 API
- API Client
- Book API Routes
lecture_6/book_api/app/main.py - Book Operations
lecture_6/book_api/app/crud.py - Book ORM Model
lecture_6/book_api/app/models.py - Book Schemas
lecture_6/book_api/app/schemas.py - Database Setup
lecture_6/book_api/app/database.py - Books SQLite Store
lecture_6/book_api/books.db
Other components
- Exercise User
Connections 16
- API Client → Book API Routes: sends requests
lecture_5/book_api/app/main.py - Book API Routes → Book Operations: calls operations
lecture_5/book_api/app/main.py - Book API Routes → Book Schemas: uses schemas
lecture_5/book_api/app/main.py - Book API Routes → Database Setup: creates sessions
lecture_5/book_api/app/main.py - Book Operations → Book ORM Model: queries models
lecture_5/book_api/app/crud.py - Book Operations → Book Schemas: accepts input
lecture_5/book_api/app/crud.py - Book ORM Model → Database Setup: uses base
lecture_5/book_api/app/models.py - Database Setup → Books SQLite Store: configures SQLite
lecture_5/book_api/app/database.py - API Client → Book API Routes: sends requests
lecture_6/book_api/app/main.py - Book API Routes → Book Operations: calls operations
lecture_6/book_api/app/main.py - Book API Routes → Book Schemas: uses schemas
lecture_6/book_api/app/main.py - Book API Routes → Database Setup: creates sessions
lecture_6/book_api/app/main.py - Book Operations → Book ORM Model: queries models
lecture_6/book_api/app/crud.py - Book Operations → Book Schemas: accepts input
lecture_6/book_api/app/crud.py - Book ORM Model → Database Setup: uses base
lecture_6/book_api/app/models.py - Database Setup → Books SQLite Store: configures SQLite
lecture_6/book_api/app/database.py