Skip to content

Instantly share code, notes, and snippets.

@fredkingham

fredkingham/referral_route_clean.py

Last active May 31, 2016 15:15
Show Gist options
  • Save fredkingham/7c011827838975df3afaec4cf0d3a967 to your computer and use it in GitHub Desktop.
Save fredkingham/7c011827838975df3afaec4cf0d3a967 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
referral_route_clean.py
import csv
import pprint
from opal import models as opal_models
LOOKUPS = [{'': '',
'CHANGE TO': 'Care of the Elderly',
'episode_id': '5386',
'opat_referral_team': 'Acute Geriatrics'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3040',
'opat_referral_team': 'Acute Medicine'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3122',
'opat_referral_team': 'Acute Medicine'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3124',
'opat_referral_team': 'Acute Medicine (Ambicare)'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3433',
'opat_referral_team': 'Ambicare'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3435',
'opat_referral_team': 'Ambicare'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '4122',
'opat_referral_team': 'Ambicare'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '4636',
'opat_referral_team': 'Ambulatory Care'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3207',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3250',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3292',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3317',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3325',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '4175',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '4403',
'opat_referral_team': 'AMU'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4520',
'opat_referral_team': 'Andrology'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '3497',
'opat_referral_team': 'Breast Surgery'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3278',
'opat_referral_team': 'Cardiothoracic'},
{'': '',
'CHANGE TO': 'Care of the Elderly',
'episode_id': '5341',
'opat_referral_team': 'Care of elderly'},
{'': '',
'CHANGE TO': 'Care of the Elderly',
'episode_id': '4850',
'opat_referral_team': 'Care or elderly'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4267',
'opat_referral_team': 'Checkley'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '2949',
'opat_referral_team': 'Colorectal'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '3115',
'opat_referral_team': 'Colorectal'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '3780',
'opat_referral_team': 'Colorectal Surgery'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '2948',
'opat_referral_team': 'Colorrectal'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '3887',
'opat_referral_team': 'EACU'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '3294',
'opat_referral_team': 'ED'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '4492',
'opat_referral_team': 'ED'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '4769',
'opat_referral_team': 'ED'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '5048',
'opat_referral_team': 'ED'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '5161',
'opat_referral_team': 'ED'},
{'': '',
'CHANGE TO': 'Emergency Department',
'episode_id': '3897',
'opat_referral_team': 'ED / ID'},
{'': '',
'CHANGE TO': 'ENT & Head and neck surgery',
'episode_id': '2722',
'opat_referral_team': 'ENT'},
{'': '',
'CHANGE TO': 'Gastroenterology',
'episode_id': '3232',
'opat_referral_team': 'Gastro'},
{'': '',
'CHANGE TO': 'Gastroenterology',
'episode_id': '4583',
'opat_referral_team': 'Gastro'},
{'': '',
'CHANGE TO': 'Gastroenterology',
'episode_id': '5220',
'opat_referral_team': 'Gastro - Upper GI'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3085',
'opat_referral_team': 'General Medicine'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3526',
'opat_referral_team': 'General Medicine'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '3848',
'opat_referral_team': 'General Medicine'},
{'': '',
'CHANGE TO': 'General Surgery',
'episode_id': '4234',
'opat_referral_team': 'General Surgery and bariatrics'},
{'': '',
'CHANGE TO': 'Primary Care',
'episode_id': '3186',
'opat_referral_team': 'GP'},
{'': '',
'CHANGE TO': 'Primary Care',
'episode_id': '4085',
'opat_referral_team': 'GP'},
{'': '',
'CHANGE TO': 'Primary Care',
'episode_id': '4283',
'opat_referral_team': 'GP'},
{'': '',
'CHANGE TO': 'Primary Care',
'episode_id': '5417',
'opat_referral_team': 'GP'},
{'': '',
'CHANGE TO': 'Obstetrics & Gynaecology',
'episode_id': '2837',
'opat_referral_team': 'Gynaecology'},
{'': '',
'CHANGE TO': 'Hepatobiliary',
'episode_id': '2787',
'opat_referral_team': 'Hepato-Pancreato-Biliary'},
{'': '',
'CHANGE TO': 'HIV & GUM',
'episode_id': '3226',
'opat_referral_team': 'HIV'},
{'': '',
'CHANGE TO': 'HIV & GUM',
'episode_id': '4969',
'opat_referral_team': 'HIV'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4700',
'opat_referral_team': 'HTD'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4326',
'opat_referral_team': 'HTD Walk in'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4347',
'opat_referral_team': 'HTD walk in'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4646',
'opat_referral_team': 'HTD walk in clinic'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '2731',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '2902',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '2947',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3014',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3293',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3311',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3467',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3546',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3551',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3565',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3577',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3635',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3671',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3721',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3829',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3857',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3929',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4021',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4127',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4173',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4174',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4207',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4216',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4232',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4233',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4284',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4289',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4360',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4488',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4528',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4773',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4813',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4863',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4893',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5002',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5288',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5348',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5349',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5367',
'opat_referral_team': 'ID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3765',
'opat_referral_team': 'ID / Cardiology - Barts'},
{'': '',
'CHANGE TO': 'Haematology',
'episode_id': '2742',
'opat_referral_team': 'Leukaemia'},
{'': '',
'CHANGE TO': 'General and Acute Medicine',
'episode_id': '4164',
'opat_referral_team': 'Medics'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4860',
'opat_referral_team': 'Micro'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5486',
'opat_referral_team': 'Micro - the whittington'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3893',
'opat_referral_team': 'Mr Ahmed'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2721',
'opat_referral_team': 'Mr Youngman'},
{'': '',
'CHANGE TO': 'neurosurgery',
'episode_id': '3750',
'opat_referral_team': 'Neurosurgical'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4379',
'opat_referral_team': 'Gastroeterology'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2790',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2857',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2860',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2864',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2872',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2880',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '2919',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3033',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3071',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3096',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3107',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3125',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3155',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3208',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3248',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3277',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3291',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3460',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3498',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3730',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3826',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3946',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3954',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4102',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4594',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4599',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4704',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4807',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '4890',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '5572',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '5799',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '5891',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '5904',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '5920',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '6181',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '6228',
'opat_referral_team': 'None'},
{'': '',
'CHANGE TO': 'Gastroenterology',
'episode_id': '5267',
'opat_referral_team': 'Nutrition'},
{'': '',
'CHANGE TO': 'Gastroenterology',
'episode_id': '5410',
'opat_referral_team': 'Nutrition'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '4128',
'opat_referral_team': 'Onclology'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '2993',
'opat_referral_team': 'Oncology'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '4458',
'opat_referral_team': 'Oncology'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '4506',
'opat_referral_team': 'Oncology'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '7333',
'opat_referral_team': 'OPAT Team'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2769',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2920',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2921',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '3035',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '3072',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '3276',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '3976',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '4121',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '5028',
'opat_referral_team': 'Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '4713',
'opat_referral_team': 'Orthopaedics'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '4970',
'opat_referral_team': 'Orthopaedics'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4295',
'opat_referral_team': 'Phil Gothard'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '2873',
'opat_referral_team': 'Prof Brown'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4851',
'opat_referral_team': 'Prostate Ca'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3075',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3209',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3466',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3578',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3783',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3901',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4113',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4159',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4206',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4505',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4770',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4799',
'opat_referral_team': 'RAID'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '3285',
'opat_referral_team': 'Resp'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '5350',
'opat_referral_team': 'Resp'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '2720',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '2788',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '3902',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4256',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4282',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4285',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4297',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4366',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '4421',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Respiratory Medicine',
'episode_id': '5201',
'opat_referral_team': 'Respiratory'},
{'': '',
'CHANGE TO': 'Rheumatology',
'episode_id': '3830',
'opat_referral_team': 'Rhumatology'},
{'': '',
'CHANGE TO': 'Rheumatology',
'episode_id': '4367',
'opat_referral_team': 'Rhumatology'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4323',
'opat_referral_team': 'S. Logan'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '3784',
'opat_referral_team': 'Sarcoma'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '5082',
'opat_referral_team': 'Sarcoma'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '3527',
'opat_referral_team': 'Sarcoma team'},
{'': '',
'CHANGE TO': 'Oncology/Palliative Care',
'episode_id': '3715',
'opat_referral_team': 'Sarcoma Team (Oncology)'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3329',
'opat_referral_team': 'Smith'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '2968',
'opat_referral_team': 'Stone and Endourology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3962',
'opat_referral_team': 'Stones and Endourology'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '2887',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3114',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3123',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3434',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3471',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3567',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3568',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '3831',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '4484',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '4494',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '4495',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '4971',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '4972',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '5031',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Cardiothoracic Surgery',
'episode_id': '5040',
'opat_referral_team': 'Thoracic'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2727',
'opat_referral_team': 'Trauma and Ortho'},
{'': '',
'CHANGE TO': 'Orthopaedics & Trauma',
'episode_id': '2821',
'opat_referral_team': 'Trauma and Ortho'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '2739',
'opat_referral_team': 'Trop'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '3468',
'opat_referral_team': 'Tropical'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4114',
'opat_referral_team': 'Tropical'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4774',
'opat_referral_team': 'Tropical'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '4979',
'opat_referral_team': 'Tropical'},
{'': '',
'CHANGE TO': 'Infectious Diseases',
'episode_id': '5305',
'opat_referral_team': 'Tropical'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '2718',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '2729',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '2789',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3007',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3566',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3716',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4086',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4089',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4090',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4296',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4493',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4772',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4973',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '5494',
'opat_referral_team': 'Urology'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3855',
'opat_referral_team': 'Urology - Stones'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '4624',
'opat_referral_team': 'Urology - Stones'},
{'': '',
'CHANGE TO': 'Urological surgery',
'episode_id': '3856',
'opat_referral_team': 'Urology - Stones and Endourology'},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3262',
'opat_referral_team': ''},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3261',
'opat_referral_team': ''},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '7773',
'opat_referral_team': ''},
{'': '',
'CHANGE TO': 'DELETE TAG',
'episode_id': '3083',
'opat_referral_team': ''}
]
opat_team_names = [
"opat",
"opat_referrals",
"opat_current",
"opat_followup",
]
def clean_routes():
opat_teams = opal_models.Team.objects.filter(name__in=opat_team_names)
for i in LOOKUPS:
episode = opal_models.Episode.objects.get(id=int(i["episode_id"]))
if i["CHANGE TO"] == "DELETE TAG":
tags = opal_models.Tagging.objects.filter(episode=episode, team__in=opat_teams)
for tag in tags:
print "deleting {0} for {1}".format(episode.id, tag.team.name)
tag.delete()
else:
location = episode.location_set.first()
location.opat_referral_team = i["CHANGE TO"]
location.save()
def extract(username):
from opal.core.search.views import *
from django.contrib.auth.models import User
user = User.objects.get(username=username)
criteria = [{
"combine": "and",
"column": "tagging",
"field": "Opat",
"lookup_list": [],
"page_number": 1,
"query": None,
"queryType": None
}]
query = queries.SearchBackend(
user, criteria
)
episodes = query.get_episodes()
fname = zip_archive(episodes, query.description(), user)
print fname
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment