Skip to content

Latest commit

 

History

History
15 lines (10 loc) · 785 Bytes

README.md

File metadata and controls

15 lines (10 loc) · 785 Bytes

NHS Dictionary of medicines and devices (dm+d) Postgres SQL parser

These Python and Postgres SQL scripts are used to parse the dm+d releases in XML format into a Postgres database. Relational fields are referenced together using foreign keys, and the description of the columns are stored in their comments.

You can download the official releases of dm+d for free from https://isd.digital.nhs.uk.

Usage

  1. Install PostgresSQL server, unzip the dm+d releases into a folder and clone this repo.
  2. Run pip install -r requirements.txt to install the required Python packages.
  3. Run python parser.py -u [your postgres username] -p [your postgres password] -d [relative or absolute path to the directory containing the dm+d folders]

Database ERD

Database ERD