Repository: spacetelescope/rad (language: python)

Issue:
Drop `filename_l1a` and `filename_pnt5` from database for TVAC and FPS schemas
We (RTB) have been told that in the example file that we provided following the `rad` TVAC schema, the fields `filename_l1a` and `filename_pnt5` were much longer than the number of characters allocated (allocated 80 characters and one of them was 649 characters long). We don't know how stable the length of these fields is, as versions and locations in disk on the GSFC side are happening often, and we think that this is a field that is not going to be useful for 99.99% of the potential users. So we would like to request to please keep these fields on the schema but drop them from the database, so the length limit is not enforced.

Thank you in advance!


Discussion / hints:
_This issue is tracked on JIRA as [RAD-169](https://jira.stsci.edu/browse/RAD-169)._

Fix patch:
diff --git a/CHANGES.rst b/CHANGES.rst
index 71186c71..4fdbc23b 100644
--- a/CHANGES.rst
+++ b/CHANGES.rst
@@ -3,6 +3,8 @@
 
 - Separated TVAC and FPS schemas into their own suite of files. [#414]
 
+- Removed the db entries for filename_l1a and filename_pnt5 in TVAC and FPS schemas. [#421]
+
 
 0.19.4 (2024-05-08)
 -------------------


Test patch:
diff --git a/src/rad/resources/schemas/fps/groundtest-1.0.0.yaml b/src/rad/resources/schemas/fps/groundtest-1.0.0.yaml
index 6c5c4420..2c3e684e 100644
--- a/src/rad/resources/schemas/fps/groundtest-1.0.0.yaml
+++ b/src/rad/resources/schemas/fps/groundtest-1.0.0.yaml
@@ -57,9 +57,6 @@ properties:
   filename_pnt5:
     title: L0.5 File Name
     type: string
-    archive_catalog:
-      datatype: nvarchar(80)
-      destination: [WFICommon.filename_pnt5]
   filepath_level_pnt5:
     title: L0.5 File Path
     type: string
@@ -69,9 +66,6 @@ properties:
   filename_l1a:
     title: L1A File Name
     type: string
-    archive_catalog:
-      datatype: nvarchar(80)
-      destination: [WFICommon.filename_l1a]
   detector_id:
     title: SCA Identifier
     type: string
diff --git a/src/rad/resources/schemas/tvac/groundtest-1.0.0.yaml b/src/rad/resources/schemas/tvac/groundtest-1.0.0.yaml
index 47fd9122..9d0cc8eb 100644
--- a/src/rad/resources/schemas/tvac/groundtest-1.0.0.yaml
+++ b/src/rad/resources/schemas/tvac/groundtest-1.0.0.yaml
@@ -57,9 +57,6 @@ properties:
   filename_pnt5:
     title: L0.5 File Name
     type: string
-    archive_catalog:
-      datatype: nvarchar(80)
-      destination: [WFICommon.filename_pnt5]
   filepath_level_pnt5:
     title: L0.5 File Path
     type: string
@@ -69,9 +66,6 @@ properties:
   filename_l1a:
     title: L1A File Name
     type: string
-    archive_catalog:
-      datatype: nvarchar(80)
-      destination: [WFICommon.filename_l1a]
   detector_id:
     title: SCA Identifier
     type: string