shawn/canteen-asset-tracker
1
0
Fork 0
Code Issues 8 Pull Requests Actions Packages Projects Releases Wiki Activity

v5 migration: dex_report_date and install_date columns #37

New Issue
Closed
opened 2026-05-23 21:28:10 +00:00 by shawn · 0 comments
shawn commented 2026-05-23 21:28:10 +00:00
Owner
Copy Link
Copy Source

What

Added two new columns to the assets table via ALTER TABLE ADD COLUMN migration:

  1. dex_report_date TEXT DEFAULT NULL - stores Last Dex Report Time from Cantaloupe import as ISO datetime string
  2. install_date TEXT DEFAULT NULL - stores machine deployment date

Files changed

  • server.py init_db() lines 460-465 (after disney_park migration)
  • admin_server.py init_db() lines 333-337 (after geofence_radius migration)

Pattern

Uses existing PRAGMA table_info pattern (same as lat/lng v3 migration).

Verified

Columns confirmed in assets.db. Both servers healthy.

## What Added two new columns to the assets table via ALTER TABLE ADD COLUMN migration: 1. `dex_report_date TEXT DEFAULT NULL` - stores Last Dex Report Time from Cantaloupe import as ISO datetime string 2. `install_date TEXT DEFAULT NULL` - stores machine deployment date ## Files changed - server.py init_db() lines 460-465 (after disney_park migration) - admin_server.py init_db() lines 333-337 (after geofence_radius migration) ## Pattern Uses existing PRAGMA table_info pattern (same as lat/lng v3 migration). ## Verified Columns confirmed in assets.db. Both servers healthy.
shawn closed this issue 2026-05-23 21:28:16 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
blocked
Kanban task is blocked
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
shawn
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: shawn/canteen-asset-tracker#37
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?