Update DB ingestion for PerSectionParameters table

[manasaV3]

Blocked by: #1056

Task

This import step should be executed after the import of Tiltseries and Frames to ensure all the records that are referenced are already created.

DB schema

The schema of the new table

Name	Data type	Nullable	Defaults
astigmatic_angle	float	true
frame_id	int	false
id	int	false	Auto Increment
major_defocus	float	true
minor_defocus	float	true
phase_shift	float	true	0.0
max_resolution	float	true
raw_angle	float	false
run_id	int	false
tiltseries_id	int	false
z_index	int	false

Metadata mapping

The data is sourced from the tiltseries_metadata.json

Name	Source
astigmatic_angle	metadata: per_section_parameters[*]. astigmatic_angle
frame_id	frame.id find frame by run_id, and acquisition_order
major_defocus	metadata: per_section_parameters[*]. major_defocus
minor_defocus	metadata: per_section_parameters[*]. minor_defocus
phase_shift	metadata: per_section_parameters[*]. phase_shift defaults to 0.0 if value is null.
max_resolution	metadata: per_section_parameters[*]. max_resolution
raw_angle	metadata: per_section_parameters[*]. raw_angle
run_id	parent: run.id
tiltseries_id	parent: tiltseries.id
z_index	metadata: per_section_parameters[*]. z_index

What done looks like?

The api has been updated to reflect the per section parameter data model, and data can be populated for all the per section parameter field.

Notes

1. https://github.com/chanzuckerberg/cryoet-data-portal-backend/tree/main/apiv2