Ispyb

-------------------

* New tables for storing X-ray centring results (contributed by rjgildea):

* ``XrayCentring``
* ``XrayCentringResult`` (replaces unused/legacy ``XrayCentringResult`` table)

* New columns:

* In ``Detector`` table: ``numberOfROIPixelsX`` + ``numberOfROIPixelsY`` (for ROI mode)
* In ``GridInfo`` table: ``micronsPerPixelX`` + ``micronsPerPixelY`` (these will eventually replace ``pixelsPerMicronX`` and ``pixelsPerMicronY``)

* New tables to hold configuration parameters for searching LDAP:

* ``LDAPSearchParameters``
* ``LDAPSearchBase``
* ``UserGroup_has_LDAPGroup``

* Stored procedures:

* New procedure ``update_sample_append_staff_comments``
* Modified procedure ``retrieve_dc_group`` now also returns ``proposalCode``, ``proposalNumber`` and ``sessionNumber``
* Modified procedures ``upsert_dcg_grid`` and ``upsert_dc_grid`` so they additionally write to the new ``GridInfo`` columns

* Build (contributed by garryod):

* Added Dockerfile to create container image
* Tagged releases are now published to the Github Container Registry

* Tools (contributed by gfrn):

* Script ``bin/export_session.sh`` now also exports tables relatd to EM SPA and EM tomography

-------------------

* New tables, rows and enum options for SSX (serial crystallography):

* Table ``SSXDataCollection``
* Table ``Component``
* Table ``SampleComposition``
* Table ``CrystalComposition``
* Table ``EventChain``
* Table ``EventType``
* Table ``Event``
* Rows for ``EventType``, ``ComponentType``, ``ExperimentType``
* Enum options in ``DataCollectionGroup.experimentType``: 'Still' (not for SSX), 'SSX-Chip', 'SSX-Jet'

* Turn on column compression for ``PDB.contents``. (This is a slow operation which takes several minutes on a table with thousands of rows.)
* Drop unneccessary column ``Tomogram.processingJobId``.

-------------------

* Add ``EXECUTE`` perm on procedure ``update_dc_append_comments`` to 'ispyb_processing' role.

-------------------

Table/column changes:

* Table ``Tomogram``: Extra path and file columns

Stored procedures:

* New procedure ``update_container_dispose`` to mark a container as disposed
* New procedure ``update_dc_append_comments`` to append text to the comments column in a data collection

Grants & roles:

* Add ``EXECUTE`` perms on new procedures to relevant roles
* Create role ispyb_web_verify_tests + grants for verifying data written by with ispyb_web
* Add missing grant for ispyb_web role

Scripts:

* Add new script ``mdb_cluster_health.sh`` to display info about MariaDB Galera cluster health
* ``mdb_cluster_backup.sh``: Misc tweaks
* ``build.sh``: Add import of new grants + document in README

-------------------

Table/column changes:

* Table ``Shipping``: Add column ``extra`` (JSON)
* Table ``BLSample_has_DataCollectionPlan``: Change datatype of ``planOrder`` to smallint unsigned
* Table ``BLSession``: Drop left-behind constraint

Data:

* Table ``ExperimentType``: Insert rows for 'em' proposalTypes 'Tomography' and 'Single Particle'
* Table ``ContainerType``: Set correct capacity for Block-4

Stored procedures:

* Procedure ``update_container_assign``: Add ``proposalCode``, ``proposalNumber`` to returned result

* Grants:

* Add ``SELECT``, ``INSERT``, ``UPDATE`` perms on ``ProcessingJob`` + ``ProcessingJobParameter`` tables for ``ispyb_processing`` role

Other:

* Scripts: Add extra mariabackup options to ``mdb_cluster_backup.sh``
* Analysis schema: Create and populate ``SummaryResults`` table

-------------------

* More grants files with new roles
* Stored procedure: Changed datatype from float to double for parameter ``p_flux`` in ``upsert_dc``
* Tables and columns:

* ``DiffractionPlan``: Add JSON column ``scanParameters``
* ``GridInfo``: Add columns patchesX and patchesY
* New table ``BLSampleImage_has_Positioner`` linking ``BLSampleImage`` and ``Positioner``