Unique IDs for Transformation Requests
AndrewEckart opened this issue · 1 comments
AndrewEckart commented
Story
Currently, we have both id
(autoincremented integers) and request_id
(UUID) attributes on transformers. The former is used as a primary key, while the latter is not even indexed. Furthermore, we are using String
as the column type although SQLAlchemy supports UUID
columns for Postgres.
As a ServiceX developer I want to simplify unique IDs so I can refer to transformation requests unambiguously
Acceptance Criteria
- The integer column is removed, and the UUID is the primary key.
- There is a web route to view a single transformation request by its UUID
- A new column is added,
description
, to be used in the web interface
Assumptions
- Advantages to UUIDs - constant length, won't clash with other ServiceX deployments in the same namespace, already used on the frontend. Disadvantages: Ugly/long, not as nice in the web interface (alleviated by
description
)
AndrewEckart commented