rcpch / rcpch-census-platform Goto Github PK

The database for this app needs to migrate from azure db into a different deployment

The RCPCH Census Platform should have a curated list of:

1. all organisations in the UK where children are cared for (hospitals both acute and community)
2. the relationships of these organisations with their parent (eg trust or health board)
3. the relationships of this organisations with their ICB or NHS region
4. their relationships with other paediatric organisational units (eg PZ number for diabetes centres, OPEN UK region for epilepsy etc)
5. The organisations should contain the ODS code as the national standard
6. The organisation list should be versioned and kept current against the spineservices API, bumping the version when a merger takes place and storing the date
7. The same potentially could be done for all GP practices

This means in addition to a database back end it would need some kind of scheduling element, such as celery beat.

This service would be a further dependency for other RCPCH projects, such as NPDA and Epilepsy12

There are currently no tests.

• add pytest-django to requirements
• curate a list of gold standard IMDs against postcodes for England
• curate a list of gold standard IMDs against postcodes for Wales
• curate a list of gold standard IMDs against postcodes for Scotland
• curate a list of gold standard IMDs against postcodes for Northern Ireland
• test script to compare gold standard IMD raw score, rank against API
• test script to compare quantile against gold standard rank

This API currently is a key dependency of the Epilepsy12 project but in time will be a dependency of other projects.

1. does it needs it's own url as part of rcpch.tech? If so: census-data.rcpch.tech?
2. is this a service that should sit behind the RCPCH API management layer or should it be available to all?

In Azure it appears this possibly could be [email protected]. Since he has left the RCPCH we need to check this.

Error [PostcodeView]: unable to guess serializer. This is graceful fallback handling for APIViews. Consider using GenericAPIView as view base class, if view is under your control. Either way you may want to add a serializer_class (or method). Ignoring view for now.

Error [UKIndexMultipleDeprivationQuantileView]: unable to guess serializer. This is graceful fallback handling for APIViews. Consider using GenericAPIView as view base class, if view is under your control. Either way you may want to add a serializer_class (or method). Ignoring view for now.

2023-03-30T15:23:34.624880334Z: [ERROR]  /tmp/8db3131c8624dce/deprivation_scores/views.py: Error [UKIndexMultipleDeprivationView]: unable to guess serializer. This is graceful fallback handling for APIViews. Consider using GenericAPIView as view base class, if view is under your control. Either way you may want to add a serializer_class (or method). Ignoring view for now.

These errors seem to be coming from the non-class-based endpoints. We should look into a way to fix this.

Currently authentication to the API endpoints is by Django token access.
Should this instead with an azure API key?

Encountered 2 components with identical names "Nested" and different classes <class 'rest_framework.serializers.ModelSerializer.build_nested_field..NestedSerializer'> and <class 'rest_framework.serializers.ModelSerializer.build_nested_field..NestedSerializer'>. This will very likely result in an incorrect schema. Try renaming one.

https://rcpch-census-engine.azurewebsites.net/api/v1/boundaries?postcode=yo83tl
https://api.rcpch.ac.uk/deprivation/v1/api/v1/boundaries?postcode=yo83tl

return 500 errors even when called with correct credential in Postman

Using this toolchain it is possible to automatically generate client libraries which make integration of this API easier in other languages.

We can of course produce them in various languages, Python would probably be a good start, but we could also consider Dart since this would make the creation of the future WHAM/Inequalities app much easier and less of a manual process.

#lesslabourmorework!