[PR #16] [MERGED] DB API definitions #16

New issue

Closed

opened 2026-02-28 15:18:48 +03:00 by kerem · 0 comments

kerem commented

2026-02-28 15:18:48 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/TheTedLab/SpotiStats/pull/16
Author: @TheTedLab
Created: 12/14/2023
Status: ✅ Merged
Merged: 12/14/2023
Merged by: @TheTedLab

Base: dev ← Head: dbapi

📝 Commits (8)

a5d4ae5 Add entity definition - on conflict update
a720066 Update entity definition - on conflict do nothing
5ad8cfb Complete saveArtist action
0116760 Add api for retrieving stats; prepare docker for api
5dedaac Add flags for python optimization
9e1f6b8 Fix CORS
7d4cd4d API service depends on DB
f2e267e Fix saving cities; add query endpoint; fix issue with long track names

📊 Changes

18 files changed (+975 additions, -0 deletions)

View changed files

➖ src/__init__.py (+0 -0)
➕ src/api/Dockerfile (+14 -0)
➕ src/api/action/getAverageFollowersPerGenres.py (+30 -0)
➕ src/api/action/getTracksPerYearForGenre.py (+15 -0)
➕ src/api/action/query.py (+187 -0)
➕ src/api/action/saveArtist.py (+66 -0)
➕ src/api/config.py (+8 -0)
➕ src/api/entity/album.py (+70 -0)
➕ src/api/entity/albumType.py (+57 -0)
➕ src/api/entity/artist.py (+138 -0)
➕ src/api/entity/city.py (+66 -0)
➕ src/api/entity/genre.py (+57 -0)
➕ src/api/entity/track.py (+84 -0)
➕ src/api/main.py (+65 -0)
➕ src/api/requirements.txt (+4 -0)
➕ src/db/Dockerfile (+3 -0)
➕ src/db/init.sql (+84 -0)
➕ src/docker-compose.yml (+27 -0)

📄 Description

No description provided

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/TheTedLab/SpotiStats/pull/16 **Author:** [@TheTedLab](https://github.com/TheTedLab) **Created:** 12/14/2023 **Status:** ✅ Merged **Merged:** 12/14/2023 **Merged by:** [@TheTedLab](https://github.com/TheTedLab) **Base:** `dev` ← **Head:** `dbapi` --- ### 📝 Commits (8) - [`a5d4ae5`](https://github.com/TheTedLab/SpotiStats/commit/a5d4ae57b6c2f2223632844b09882c29f3c8cbd7) Add entity definition - on conflict update - [`a720066`](https://github.com/TheTedLab/SpotiStats/commit/a7200669fe8b4c7963579c2d70068c038ff8c475) Update entity definition - on conflict do nothing - [`5ad8cfb`](https://github.com/TheTedLab/SpotiStats/commit/5ad8cfb5ec05cf382fbdb9fa068d17c1e39b0116) Complete saveArtist action - [`0116760`](https://github.com/TheTedLab/SpotiStats/commit/011676037c2f4efc26e23f6f812ef630097cbb3b) Add api for retrieving stats; prepare docker for api - [`5dedaac`](https://github.com/TheTedLab/SpotiStats/commit/5dedaac9ced253205a88dd2c49d3f1ee649587a4) Add flags for python optimization - [`9e1f6b8`](https://github.com/TheTedLab/SpotiStats/commit/9e1f6b8e4383940a2b41978d9d0c24511636fd44) Fix CORS - [`7d4cd4d`](https://github.com/TheTedLab/SpotiStats/commit/7d4cd4d78510bd8f2471b79f7a2f4322475150ba) API service depends on DB - [`f2e267e`](https://github.com/TheTedLab/SpotiStats/commit/f2e267ee0d4680d6cdbba9c8a8eb23390bb088c5) Fix saving cities; add query endpoint; fix issue with long track names ### 📊 Changes **18 files changed** (+975 additions, -0 deletions) <details> <summary>View changed files</summary> ➖ `src/__init__.py` (+0 -0) ➕ `src/api/Dockerfile` (+14 -0) ➕ `src/api/action/getAverageFollowersPerGenres.py` (+30 -0) ➕ `src/api/action/getTracksPerYearForGenre.py` (+15 -0) ➕ `src/api/action/query.py` (+187 -0) ➕ `src/api/action/saveArtist.py` (+66 -0) ➕ `src/api/config.py` (+8 -0) ➕ `src/api/entity/album.py` (+70 -0) ➕ `src/api/entity/albumType.py` (+57 -0) ➕ `src/api/entity/artist.py` (+138 -0) ➕ `src/api/entity/city.py` (+66 -0) ➕ `src/api/entity/genre.py` (+57 -0) ➕ `src/api/entity/track.py` (+84 -0) ➕ `src/api/main.py` (+65 -0) ➕ `src/api/requirements.txt` (+4 -0) ➕ `src/db/Dockerfile` (+3 -0) ➕ `src/db/init.sql` (+84 -0) ➕ `src/docker-compose.yml` (+27 -0) </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

kerem

2026-02-28 15:18:48 +03:00

closed this issue
added the
pull-request
label

No labels

enhancement

pull-request

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/SpotiStats#16

No description provided.

Rows
Columns