kianiadee
  • Joined on 2026-03-06
274473c544 docs: update analytics report with live DB state (18 Apr 2026)
cebcf74ba2 feat: business analytics expansion + driver CSV import
Compare 2 commits »
8867be9d3d perf+fix: SAVEPOINT-per-item pollers, batched GPS inserts, parallel detail fetch
f7cc48cc6a chore: align .python-version to 3.12.0 (matches Docker image and pyproject.toml)
20d3ddb841 feat: add db_audit health checks, runner, and scheduled Forgejo workflow
6ed4d3a1e2 test: add test suite - unit tests, webhook endpoint tests, and CI workflow
2ca3d2f021 ci: add ruff + mypy static analysis config and Forgejo workflow
Compare 9 commits »
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-11 19:18:47 +00:00
fcc745f09d Fix Grafana provisioning: bake datasource/dashboard config into custom image
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-11 16:22:32 +00:00
d706d17cc8 Fix Grafana datasource: add GRAFANA_DB_RO_PASSWORD and sync grafana_ro on startup
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-11 15:42:26 +00:00
87ecab4a72 Wire /pushevent to device_events table (was log-only)
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-11 15:31:43 +00:00
b1e4d6e85f Fix 5 webhook bugs: SAVEPOINTs, NULL guards, BCD timestamps, /pushevent, log NULL fix
1f11a65b0b Add 02_tracksolid_docker_commands.md — remote DB command reference
ae5bd2c960 Update tracksolidApiDocumentation.md with live implementation findings
d7ffa136a3 Regenerate 260410_baseline_report.md from live database (post-migration)
f277532a9d Regenerate 260410_baseline_report.md with post-migration comprehensive data
Compare 5 commits »
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-10 20:48:33 +00:00
5f1b32f1dc Extend seed sentinels to cover migrations 04 and 05
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-10 20:43:48 +00:00
5d47eece6b Fix: seed pre-tracking migrations to skip already-applied 02 and 03
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-10 20:40:35 +00:00
63e555b822 Fix: create tracksolid schema before schema_migrations table
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-10 20:34:59 +00:00
aa290151ea Update run_migrations.py: add 04+05, idempotency tracking, expanded verify
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-10 20:32:06 +00:00
20a98074a6 Add idempotent migration runner script
97b19eb968 Add 2026-04-10 baseline fleet report from live database query
40e452e156 Replace hardcoded container names with dynamic lookup
09b3860706 Add fleet business analytics document
3797a4e2ca Implement POLL-01 high-res GPS trails and POLL-03 on-demand location refresh
Compare 11 commits »
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 16:37:00 +00:00
2f3879aa2a Add n8n workflow templates and change webhook port to 8888
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 14:59:08 +00:00
004fed7ab9 Add operations manual with verification queries per service
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 14:27:52 +00:00
e1402f6af1 Fix NoneType crash: API returns null result instead of missing key
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 14:18:03 +00:00
326764e1a0 Fix migration failures: switch to full TimescaleDB + use psql runner
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 14:11:14 +00:00
3bbf3b777d Run migrations inline at each service startup instead of init service
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 14:02:12 +00:00
4a31de30b1 Add db_migrate init service to auto-run SQL schema on deploy
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 13:49:55 +00:00
b59616c7aa Remove webhook_receiver host port binding (Coolify proxy handles routing)
kianiadee pushed to main at kianiadee/tracksolid_timescale_grafana_prod 2026-04-08 13:42:24 +00:00
2fbd286d29 Fix timescale_db: remove empty ports key causing Coolify deploy failure