Parser / Panel weryfikacji
Ten panel służy do sprawdzenia działania projektu: pobrania pogody z API, poprawności checksum oraz przepływu danych przez kolejkę i bazę.
1) Czytelne pobranie pogody (API)
2) Weryfikacja wiadomości (Base64/JSON → bardziej czytelne)
3) Podgląd przepływu danych (kolejka → worker → baza)
Kolejka: queue_messages • Docelowe dane: weather_measurements • DLQ: queue_deadletter
Worker uruchamiasz: php /var/www/html/weather/worker.php
Kolejka (ostatnie 10)
| ID | Status | Attempts | Created | Payload |
|---|
| 93 |
NEW |
0 |
2026-01-19 11:22:19 |
{"Measurement":"temperature","Location":"Cieszyn","Value":-2.5,"Timestamp":"2026-01-19T10:15Z","Checksum":"qc4LppZGSbvyij/h/1aDP58EqasKZG1Fy52QJjcNj88="} |
| 92 |
NEW |
0 |
2026-01-17 13:50:27 |
{"Measurement":"temperature","Location":"Cieszyn","Value":0.4,"Timestamp":"2026-01-17T12:50Z","Checksum":"sglEiGFCzKMVYDf3rfPPD0EAtBA4pNSW19qMWA6o2DM="} |
Dane zapisane (ostatnie 10)
| ID | Measurement | Location | Value | TS | Inserted |
|---|
| 90 |
temperature |
Cieszyn |
4.0 |
2026-01-17 12:45:00.000000 |
2026-01-17 13:48:40 |
| 89 |
temperature |
Cieszyn |
4.0 |
2026-01-17 12:30:00.000000 |
2026-01-17 13:48:40 |
| 88 |
temperature |
Kraków |
-1.7 |
2026-01-17 12:15:00.000000 |
2026-01-17 13:48:40 |
| 87 |
temperature |
Cieszyn |
0.4 |
2026-01-17 12:14:00.000000 |
2026-01-17 13:48:40 |
| 86 |
temperature |
Cieszyn |
4.1 |
2026-01-17 12:00:00.000000 |
2026-01-17 13:48:40 |
| 85 |
temperature |
Cieszyn |
-3.5 |
2026-01-11 12:00:00.000000 |
2026-01-17 13:48:40 |
| 84 |
temperature |
Cieszyn |
-3.5 |
2026-01-11 11:45:00.000000 |
2026-01-17 13:48:40 |
| 83 |
temperature |
Cieszyn |
0.4 |
2026-01-11 11:52:00.000000 |
2026-01-17 13:48:40 |
| 82 |
temperature |
Cieszyn |
0.4 |
2026-01-11 11:41:00.000000 |
2026-01-17 13:48:40 |
| 81 |
temperature |
Cieszyn |
-3.5 |
2026-01-11 11:15:00.000000 |
2026-01-11 12:22:09 |
DLQ (ostatnie 10)
| ID | Error | Created | Payload |
|---|
| 2 |
Failed data parse |
2026-01-17 13:41:41 |
{"Measurement":"temperature","Location":"Kraków","Value":0.6,"Timestamp":"2026-01-01:Z63","Checksum":"IfhcwZuoRQHVjyog71koRA/F8POwfYj631VrFDzI7ZE="} |
| 1 |
Failed checksum error |
2026-01-17 13:33:11 |
{"Measurement":"temperature","Location":"Cieszyn","Value":-3.5,"Timestamp":"2026-01-11T11:15Z","Checksum":"fetchAll();"} |
4) Szybkie linki