Convert ehr api to export api

[stefpiatek]

Definition of Done / Acceptance Criteria

Once we have finished off the 100 days integration of new model for redaction in UCLH-Foundry/the-rolling-skeleton/issues/214 , strip out the emap star querying from PIXL

• Remove tables from PIXL DB relating to EHR data (this is now in the OMOP extract)
• Convert ehr api to export api and rename endpoints for exporting data (see top level document for step naming)
• Remove redundant tests, fake cogstack api, fake emap star etc.
• the pixl CLI create radiology linker table on the fly (and writes to export dir): on export will read in the omop data, query the pixl pipeline database for all images in the project name, and merge the omop data with the hashed imaging identifier to write the linker parquet file
• Rename EHR env vars and document that these need renaming in config file
• Remove ehr queue
• move orthanc anon's ftps export into the export api. orthanc anon tells export api that this resource is ready for export

Testing

No response

Documentation

• Update documentation to reflect exporting function, documenting pathways for exporting images and parquet files, imaging alone and parquet alone?

Dependencies

• UCLH-Foundry/the-rolling-skeleton/issues/214

Details and Comments

No response

[jeremyestein]

@stefpiatek Am assuming the pixl az-copy-ehr command can be removed?

[stefpiatek]

@stefpiatek Am assuming the pixl az-copy-ehr command can be removed?

Yep!