CubeCraft-Creations/remote-rig
11
0
Fork 0
generated from CubeCraft-Creations/Tracehound
Code Issues 9 Pull Requests 1 Actions Packages Projects Releases 1 Wiki Activity

[CUB-228] Add battery_calibration_offset to cameras table #23

New Issue
Open
opened 2026-05-27 10:55:51 -04:00 by Hermes · 1 comment
Hermes commented 2026-05-27 10:55:51 -04:00
Owner
Copy Link
Copy Source

Imported from Linear: CUB-228
Linear URL: https://linear.app/cubecraft-creations/issue/CUB-228/add-battery-calibration-offset-to-cameras-table

Description

GoPro Hero 3 reports battery as raw byte (offset 57). Store per-camera calibration offset so hub converts raw to percentage. Add column to schema, update migration, update Go models. NULL = no calibration, use raw value as-is.

Imported Linear metadata

  • Linear ID: CUB-228
  • State: In Review
  • Priority: Urgent
  • Project: RemoteRig
  • Labels: Hex
  • Due date: none
  • Original assignee: unassigned
  • Creator: CubeCraft Creations
  • Linear branch name: cubecraftcreations1/cub-228-add-battery_calibration_offset-to-cameras-table
  • Linear comments archived/imported: 1
Imported from Linear: **CUB-228** Linear URL: https://linear.app/cubecraft-creations/issue/CUB-228/add-battery-calibration-offset-to-cameras-table ## Description GoPro Hero 3 reports battery as raw byte (offset 57). Store per-camera calibration offset so hub converts raw to percentage. Add column to schema, update migration, update Go models. NULL = no calibration, use raw value as-is. ## Imported Linear metadata - Linear ID: CUB-228 - State: In Review - Priority: Urgent - Project: RemoteRig - Labels: Hex - Due date: none - Original assignee: unassigned - Creator: CubeCraft Creations - Linear branch name: cubecraftcreations1/cub-228-add-battery_calibration_offset-to-cameras-table - Linear comments archived/imported: 1
Hermes added the agent/hexpriority/urgentstate/in-reviewproject/remoterig labels 2026-05-27 10:55:51 -04:00
Hermes commented 2026-05-27 10:55:52 -04:00
Author
Owner
Copy Link
Copy Source

Imported Linear comment from CubeCraft Creations at 2026-05-23T02:32:24.411Z on CUB-228:

CUB-228: Add battery_calibration_offset to cameras table — Complete ✅

Branch: agent/hex/CUB-228-battery-calibration-offset
Commit: 1704d8a
Validation: PASS (go vet ./pkg/models/ ./internal/db/ ./internal/api/ all clean; go vet ./internal/mqtt/ has a pre-existing go.sum issue unrelated to this change)
PR: #7

Changes Summary

File Change
pkg/models/camera.go Added BatteryCalibrationOffset *float64 field to Camera struct (JSON: battery_calibration_offset, omitempty)
internal/db/migrations/001_create_tables.sql Added battery_calibration_offset REAL column to CREATE TABLE for fresh databases
internal/db/migrations/002_add_camera_calibration.sql New migration: ALTER TABLE cameras ADD COLUMN battery_calibration_offset REAL
internal/db/db.go Embed migration 002; added runIncrementalMigrations() with pragma_table_info guard for idempotent migration on existing databases
internal/api/cameras.go Updated GetCameraDetail SELECT to include new column
internal/mqtt/subscriber.go Updated getCamera SELECT to include new column

Migration Strategy

  • Fresh databases: column created via 001_create_tables.sql
  • Existing databases: 002_add_camera_calibration.sql runs via pragma_table_info idempotency check — safe to run multiple times
Imported Linear comment from **CubeCraft Creations** at `2026-05-23T02:32:24.411Z` on **CUB-228**: --- **CUB-228: Add battery_calibration_offset to cameras table** — Complete ✅ **Branch**: `agent/hex/CUB-228-battery-calibration-offset` **Commit**: `1704d8a` **Validation**: PASS (`go vet ./pkg/models/ ./internal/db/ ./internal/api/` all clean; `go vet ./internal/mqtt/` has a pre-existing go.sum issue unrelated to this change) **PR**: https://code.cubecraftcreations.com/CubeCraft-Creations/remote-rig/pulls/7 ### Changes Summary | File | Change | |------|--------| | `pkg/models/camera.go` | Added `BatteryCalibrationOffset *float64` field to `Camera` struct (JSON: `battery_calibration_offset`, omitempty) | | `internal/db/migrations/001_create_tables.sql` | Added `battery_calibration_offset REAL` column to CREATE TABLE for fresh databases | | `internal/db/migrations/002_add_camera_calibration.sql` | New migration: `ALTER TABLE cameras ADD COLUMN battery_calibration_offset REAL` | | `internal/db/db.go` | Embed migration 002; added `runIncrementalMigrations()` with `pragma_table_info` guard for idempotent migration on existing databases | | `internal/api/cameras.go` | Updated `GetCameraDetail` SELECT to include new column | | `internal/mqtt/subscriber.go` | Updated `getCamera` SELECT to include new column | ### Migration Strategy - **Fresh databases**: column created via 001_create_tables.sql - **Existing databases**: 002_add_camera_calibration.sql runs via `pragma_table_info` idempotency check — safe to run multiple times
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
agent/dex
Backend development agent
 agent/hermes
Hermes orchestration/automation
 agent/hex
Database/migration agent
 agent/nano
Firmware/microcontroller development agent
 agent/otto
Reviewer/orchestrator agent
 agent/pip
Raspberry Pi/hub development agent
 agent/rex
Frontend development agent
 agent/sketch
UI/UX and design agent
 priority/high
Linear priority: High
 priority/low
Linear priority: Low
 priority/medium
Linear priority: Medium
 priority/urgent
Linear priority: Urgent
 project/bot-task-tracker
Bot Task Tracker project
 project/control-center
Control Center / Command Hub project
 project/extrudex
Extrudex project
 project/product-pipeline
Product Pipeline project
 project/remoterig
RemoteRig project
 project/shopify-bugs
Shopify Bugs project
 project/social-media-content-pipeline
Social Media Content Pipeline project
 project/tracehound
TraceHound project
 state/backlog
Imported/active backlog work not yet scheduled
 state/canceled
Canceled/won’t do; used on closed imported issues
 state/done
Completed work; used on closed imported issues
 state/duplicate
Duplicate issue; used on closed imported issues
 state/in-progress
Currently being worked
 state/in-review
Pull request or implementation under review
 state/todo
Ready to start
 status/blocked
Blocked by dependency or decision
 status/needs-dev-breakdown
Needs implementation breakdown before agents start
 status/needs-research
Needs research before implementation
 type/bug
Bug fix
 type/feature
Feature work
 type/hardware
Hardware/mechanical/electronics work
 type/improvement
Improvement/refactor
No Label agent/hex priority/urgent project/remoterig state/in-review
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
Dex Grimm Hermes Hex Nano openclaw-mcp Otto (Otto the Minion) overseer (Joshua) Pip Rex Sketch
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: CubeCraft-Creations/remote-rig#23
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?