Files
zeekay eb9a9887d0 fix: complete umami purge and get all 34 e2e tests passing
- Replace @umami/* imports with @hanzo/* npm aliases in package.json
- Rename redis client to KVClient (UmamiRedisClient as KVClient)
- Rename collector/forward/umami.go → analytics.go (git mv)
- Remove all umami backwards-compat aliases from tracker (data-umami-event,
  window.umami, umami.disabled localStorage, eventNameAttributeLegacy)
- Purge 93 umami. prefixes from ClickHouse SQL migrations
- Update default admin password hash from "umami" to "analytics"
- Rebrand podman service files, GitHub Actions, telemetry URL, seed scripts
- Add data-test attributes to WebsiteAddButton, WebsitesTable, UserAddForm,
  UserEditForm for Cypress test compatibility
- Refactor UsersTable: replace MenuButton portal dropdown with inline
  LinkButton (edit) + Button (delete) so Cypress .within() can find them
- Fix Cypress tests: update selectors (td[label] → cy.contains), remove
  stale tab-navigation (settings page is vertical, not tabbed), scope
  button[type=submit] to [role=dialog] for delete confirmation
- All 34 Cypress e2e tests now pass (was 28/34)
2026-02-27 16:46:39 -08:00

18 lines
763 B
SQL

-- edit event_data values
ALTER TABLE "event_data" RENAME COLUMN "event_date_value" TO "date_value";
ALTER TABLE "event_data" RENAME COLUMN "event_numeric_value" TO "number_value";
ALTER TABLE "event_data" RENAME COLUMN "event_string_value" TO "string_value";
ALTER TABLE "event_data" RENAME COLUMN "event_data_type" TO "data_type";
-- add job_id
ALTER TABLE "website_event" ADD COLUMN "job_id" UUID AFTER "created_at";
ALTER TABLE "event_data" ADD COLUMN "job_id" UUID AFTER "created_at";
-- update event_data string
alter table analytics.event_data
update string_value = number_value
where data_type = 2
alter table analytics.event_data
update string_value = replaceOne(concat(CAST(toDateTime(date_value, 'UTC'), 'String'),'Z'), ' ', 'T')
where data_type = 4