UKRDC-SQLA
SQLAlchemy models for the UKRDC and related databases.
Installation
pip install ukrdc-sqla
Example Usage
from datetime import datetime
from ukrdc_sqla.ukrdc import LabOrder, PatientNumber, PatientRecord, ResultItem
def commit_extra_resultitem(session):
patient_record = PatientRecord(
pid="PYTEST01:LABORDERS:00000000L",
sendingfacility="PATIENT_RECORD_SENDING_FACILITY_1",
sendingextract="PV",
localpatientid="00000000L",
ukrdcid="000000001",
repository_update_date=datetime(2020, 3, 16),
repository_creation_date=datetime(2020, 3, 16),
)
patient_number = PatientNumber(
id=2,
pid="PYTEST01:LABORDERS:00000000L",
patientid="111111111",
organization="NHS",
numbertype="NI",
)
laborder = LabOrder(
id="LABORDER_TEST2_1",
pid="PYTEST01:LABORDERS:00000000L",
external_id="EXTERNAL_ID_TEST2_1",
order_category="ORDER_CATEGORY_TEST2_1",
specimen_collected_time=datetime(2020, 3, 16),
)
resultitem = ResultItem(
id="RESULTITEM_TEST2_1",
order_id="LABORDER_TEST2_1",
service_id_std="SERVICE_ID_STD_TEST2_1",
service_id="SERVICE_ID_TEST2_1",
service_id_description="SERVICE_ID_DESCRIPTION_TEST2_1",
value="VALUE_TEST2_1",
value_units="VALUE_UNITS_TEST2_1",
observation_time=datetime(2020, 3, 16),
)
session.add(patient_record)
session.add(patient_number)
session.add(laborder)
session.add(resultitem)
session.commit()
Developer notes
Publish updates
- Iterate the version number (
poetry version major/minor/patch) - Push to GitHub repo
- Create a GitHub release
- GitHub Actions will automatically publish the release to PyPI
3 maintainers
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ukrdc_sqla-4.2.2.tar.gz
(21.4 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file ukrdc_sqla-4.2.2.tar.gz.
File metadata
- Download URL: ukrdc_sqla-4.2.2.tar.gz
- Upload date:
- Size: 21.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.2.1 CPython/3.9.25 Linux/6.17.0-1020-azure
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
fb3443391dd757a4eb9811ddc0cabd4fc1d17f43c0587cfd27e34e1d4a10dc48
|
|
| MD5 |
3e840f91c70d156c30ea6fc2df7595e3
|
|
| BLAKE2b-256 |
00680e7acd1aaab5b5b4187fe1fb9243840d863aaff0d4b1fd4ce00c8ba174f4
|
File details
Details for the file ukrdc_sqla-4.2.2-py3-none-any.whl.
File metadata
- Download URL: ukrdc_sqla-4.2.2-py3-none-any.whl
- Upload date:
- Size: 25.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.2.1 CPython/3.9.25 Linux/6.17.0-1020-azure
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
dea6dbb7a9f712162334f9e83ec20fa5e4073e4ec939c81be5ccdca5497f7c82
|
|
| MD5 |
2fabd997a64b43f258fd029f2d5b37e4
|
|
| BLAKE2b-256 |
8cf17abdee65ce8b1b17f46593b02803d3a770778e856e43d311795120806ec6
|
