GitLab

Sample database

See merge request !851

Following !813.

Any Vidjil server may be used to store sample sets that may be not patients.
Moreover, following !813, we don't want that people upload patient-related data on non-healthcare servers.

Healthcare-compliant servers : documentation, warnings

Closes #4506

See merge request !813

Single query, improve set queries

Closes #3169

See merge request !832

since the anon permissions are no longer in the sample_set_list, we need
to adjust the test

Since we don't use them to display the list, we'll save a little time

setting the sql_mode caused an issue with escaped characters. It would
seem I had overwritten an option required for web2py

Set MySQL to use pipes for concat just like SQLITE.

The syntax for specifying the GROUP_CONCAT separator seems to differ
between SQLITE and MySQL.

fixes issue with sequence_file count for sample_sets accessible to
multiple groups

Add a second left join for performance reasons to include permissions
regarding 'patient', 'run' and 'generic'.

Pass a helper instance to SampleSetList instead of a set type

rather than calculate the most used config in the sample_set list,
calculate in the index.

use auth.vidjil_accessible_query to include permissions

the on query for anon permissions was causing a cross join with the
auth_membership table, which made the file_count and file_size fields
incorrect