snapshot-0516

Bi-Weekly Snapshot (Week 11 - 2025.05.16)

1. Model Integration and Deployment

• Connected to the Colab-hosted capston-team-5/finma-7b-4bit-quantized model API.
• Implemented the run_prediction logic and deployed prediction endpoint.
• Verified end-to-end inference pipeline and deployed with Docker Compose.

2. Database Migration and ORM Setup

• Migrated backend database from MongoDB to MySQL (Amazon RDS).
• Defined core relational models using SQLAlchemy: Ticker, ChartData, Prediction, News.
• Updated database connection and query structure to match new relational schema.
• DB schema documentation: db/README.md

3. CRUD Refactoring and DB Caching

• Refactored backend into modular CRUD files: chart.py, news.py, prediction.py, explanation.py

• Introduced get_session() helper for unified session management.

• Added DB caching logic to reduce redundant external API calls:

  • Chart: Fetches and stores only missing date ranges.
  • News: Compares latest pubDate with DB before fetching.
  • Prediction: Caches based on (ticker, horizon, predicted_date).

4. Multi-Market & Horizon-Aware Charting

• /chart and /stock-info endpoints now support:

  • Weekly data for horizon = 7
  • Monthly data for horizon = 30

• Previously always returned 30-days daily data → Now aligns better with prediction scale.

---

Related PRs

• [#8] Add KOSPI support in /search
• [#9] News integration for US/KOSPI stocks
• [#10] API connection to Colab-hosted prediction server
• [#11] Migration to MySQL + full CRUD refactor
• [#12][#13] Hotfixes: chart interval bug, Docker import path issue