# matheusvancoll/musica-do-dia architecture

> Architecture diagram of the GitHub repository matheusvancoll/musica-do-dia, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/matheusvancoll/musica-do-dia
- Repository: https://github.com/matheusvancoll/musica-do-dia

## Overview

Música do dia is a Next.js app for publishing one selected track per day, displaying it with listening links, and browsing a seven-day history. The daily track is chosen from Deezer playlists or entered manually, enriched with metadata and service links, then stored in a SQL database. The graph follows the visible page/API/data flow and includes the documented Vercel cron trigger. Some API implementations and the Spotify adapter were not excerpted, so their internal behavior is represented only where the source index supports it.

Main entry points: [`pages/musica-hoje.js`](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/musica-hoje.js) (Today page), [`utils/saveMusic.js`](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/saveMusic.js) (Track selection and save), [`utils/db.js`](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/db.js) (Database access), [`pages/api/music/get-today-music.js`](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-today-music.js) (Today endpoint)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_experience["Web experience"]
  node_home["Home page<br/>[index.js]"]
  node_today_page["Today page<br/>[musica-hoje.js]"]
  node_history_page["History page<br/>[historico.js]"]
  node_layout["Page layout<br/>[Layout.js]"]
  node_navbar["Navigation bar<br/>[Navbar.js]"]
  node_music_card["Track card<br/>[CardMusic.js]"]
  node_vinyl["Vinyl artwork<br/>[Vinyl.js]"]
end

subgraph group_routes["API routes"]
  node_today_api["Today endpoint<br/>[get-today-music.js]"]
  node_history_api["History endpoint"]
  node_all_api["All-music endpoint"]
  node_insert_api["Manual insert endpoint"]
  node_cron_api["Daily cron endpoint<br/>[daily-music.js]"]
end

subgraph group_music["Music services and data"]
  node_save_music["Track selection and save<br/>[saveMusic.js]"]
  node_deezer["Deezer integration<br/>[deezer.js]"]
  node_spotify["Spotify link lookup<br/>[spotify.js]"]
  node_dates["Date utilities<br/>[dates.js]"]
  node_db_client["Database access<br/>[db.js]"]
  node_music_store[("Music-day table")]
end

node_visitor(("Listener"))
node_deezer_service["Deezer API"]
node_cron_scheduler(("Vercel Cron"))

node_visitor -.->|"opens"| node_home
node_visitor -.->|"opens"| node_today_page
node_visitor -.->|"opens"| node_history_page
node_home -->|"renders"| node_layout
node_home -->|"renders"| node_vinyl
node_layout -->|"renders"| node_navbar
node_today_page -->|"renders"| node_layout
node_today_page -->|"renders"| node_music_card
node_today_page -->|"renders"| node_vinyl
node_today_page -->|"fetches"| node_today_api
node_today_api -->|"returns music"| node_today_page
node_history_page -->|"renders"| node_layout
node_history_page -->|"fetches"| node_history_api
node_history_api -->|"returns history"| node_history_page
node_music_card -->|"renders"| node_vinyl
node_today_api -->|"reads"| node_db_client
node_today_api -->|"ensures track"| node_save_music
node_history_api -->|"reads"| node_db_client
node_history_api -->|"uses date range"| node_dates
node_all_api -->|"reads"| node_db_client
node_insert_api -->|"saves track"| node_save_music
node_cron_scheduler -->|"invokes daily"| node_cron_api
node_cron_api -->|"ensures track"| node_save_music
node_save_music -->|"reads and writes"| node_db_client
node_save_music -->|"looks up tracks"| node_deezer
node_save_music -->|"gets day"| node_dates
node_deezer -->|"looks up link"| node_spotify
node_deezer -->|"requests metadata"| node_deezer_service
node_db_client -->|"creates and accesses"| node_music_store

click node_home "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/index.js"
click node_today_page "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/musica-hoje.js"
click node_history_page "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/historico.js"
click node_layout "https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Layout.js"
click node_navbar "https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Navbar.js"
click node_music_card "https://github.com/matheusvancoll/musica-do-dia/blob/master/components/CardMusic.js"
click node_vinyl "https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Vinyl.js"
click node_today_api "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-today-music.js"
click node_history_api "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-music-history.js"
click node_all_api "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-all-music-list.js"
click node_insert_api "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/insert-music-list.js"
click node_cron_api "https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/cron/daily-music.js"
click node_save_music "https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/saveMusic.js"
click node_deezer "https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/deezer.js"
click node_spotify "https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/spotify.js"
click node_dates "https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/dates.js"
click node_db_client "https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/db.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_home,node_today_page,node_history_page,node_layout,node_navbar,node_music_card,node_vinyl toneBlue
class node_today_api,node_history_api,node_all_api,node_insert_api,node_cron_api toneAmber
class node_save_music,node_deezer,node_spotify,node_dates,node_db_client,node_music_store,node_deezer_service toneMint
class node_visitor,node_cron_scheduler toneIndigo
```

## Components

### Web experience

- [Home page](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/index.js): `pages/index.js`
- [Today page](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/musica-hoje.js): `pages/musica-hoje.js`
- [History page](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/historico.js): `pages/historico.js`
- [Page layout](https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Layout.js): `components/Layout.js`
- [Navigation bar](https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Navbar.js): `components/Navbar.js`
- [Track card](https://github.com/matheusvancoll/musica-do-dia/blob/master/components/CardMusic.js): `components/CardMusic.js`
- [Vinyl artwork](https://github.com/matheusvancoll/musica-do-dia/blob/master/components/Vinyl.js): `components/Vinyl.js`

### API routes

- [Today endpoint](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-today-music.js): `pages/api/music/get-today-music.js`
- [History endpoint](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-music-history.js): `pages/api/music/get-music-history.js`
- [All-music endpoint](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/get-all-music-list.js): `pages/api/music/get-all-music-list.js`
- [Manual insert endpoint](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/music/insert-music-list.js): `pages/api/music/insert-music-list.js`
- [Daily cron endpoint](https://github.com/matheusvancoll/musica-do-dia/blob/master/pages/api/cron/daily-music.js): `pages/api/cron/daily-music.js`

### Music services and data

- [Track selection and save](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/saveMusic.js): `utils/saveMusic.js`
- [Deezer integration](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/deezer.js): `utils/deezer.js`
- [Spotify link lookup](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/spotify.js): `utils/spotify.js`
- [Date utilities](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/dates.js): `utils/dates.js`
- [Database access](https://github.com/matheusvancoll/musica-do-dia/blob/master/utils/db.js): `utils/db.js`
- **Music-day table**

### Other components

- **Listener**
- **Deezer API**
- **Vercel Cron**

## Connections

- Listener → Home page: opens
- Listener → Today page: opens
- Listener → History page: opens
- Home page → Page layout: renders (evidence: `pages/index.js`)
- Home page → Vinyl artwork: renders (evidence: `pages/index.js`)
- Page layout → Navigation bar: renders (evidence: `components/Layout.js`)
- Today page → Page layout: renders (evidence: `pages/musica-hoje.js`)
- Today page → Track card: renders (evidence: `pages/musica-hoje.js`)
- Today page → Vinyl artwork: renders (evidence: `pages/musica-hoje.js`)
- Today page → Today endpoint: fetches (evidence: `pages/musica-hoje.js`)
- Today endpoint → Today page: returns music (evidence: `pages/musica-hoje.js`)
- History page → Page layout: renders (evidence: `pages/historico.js`)
- History page → History endpoint: fetches (evidence: `pages/historico.js`)
- History endpoint → History page: returns history (evidence: `pages/historico.js`)
- Track card → Vinyl artwork: renders (evidence: `components/CardMusic.js`)
- Today endpoint → Database access: reads (evidence: `pages/api/music/get-today-music.js`)
- Today endpoint → Track selection and save: ensures track (evidence: `pages/api/music/get-today-music.js`)
- History endpoint → Database access: reads (evidence: `pages/api/music/get-music-history.js`)
- History endpoint → Date utilities: uses date range (evidence: `pages/api/music/get-music-history.js`)
- All-music endpoint → Database access: reads (evidence: `pages/api/music/get-all-music-list.js`)
- Manual insert endpoint → Track selection and save: saves track (evidence: `pages/api/music/insert-music-list.js`)
- Vercel Cron → Daily cron endpoint: invokes daily (evidence: `pages/api/cron/daily-music.js`)
- Daily cron endpoint → Track selection and save: ensures track (evidence: `pages/api/cron/daily-music.js`)
- Track selection and save → Database access: reads and writes (evidence: `utils/saveMusic.js`)
- Track selection and save → Deezer integration: looks up tracks (evidence: `utils/saveMusic.js`)
- Track selection and save → Date utilities: gets day (evidence: `utils/saveMusic.js`)
- Deezer integration → Spotify link lookup: looks up link (evidence: `utils/deezer.js`)
- Deezer integration → Deezer API: requests metadata (evidence: `utils/deezer.js`)
- Database access → Music-day table: creates and accesses (evidence: `utils/db.js`)
