{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4ae6950a-eb83-4428-abdf-87e3e28830fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "import os\n",
    "sys.path.append('../')\n",
    "import labkeyInterface\n",
    "import labkeyDatabaseBrowser\n",
    "import labkeyFileBrowser"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "af1c70b6-a8eb-444f-b3ae-e2c9072a8d73",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "User: andrej studen CSRF: 044cc6e0e790d221200c1e6fd8ace602\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'044cc6e0e790d221200c1e6fd8ace602'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "net=labkeyInterface.labkeyInterface()\n",
    "db=labkeyDatabaseBrowser.labkeyDB(net)\n",
    "fconfig=os.path.join(os.path.expanduser('~'),'.labkey','labkey-public.json')\n",
    "net.init(fconfig)\n",
    "\n",
    "#this reports the certificate used\n",
    "try:\n",
    "    print('Using: {}'.format(net.connectionConfig['SSL']['user']))\n",
    "except KeyError:\n",
    "    pass\n",
    "\n",
    "#This gets a deafult CSRF code; It should report user name plus a long string of random hex numbers\n",
    "net.getCSRF()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "bafb076a-a860-4884-b124-ed1dab42aa27",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'domainId': 769, 'name': 'demographicData', 'domainURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1', 'description': None, 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'fields': [{'propertyId': 7296, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#Key', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'Key', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#int', 'conceptURI': None, 'label': None, 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': None, 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7315, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#crfRef', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'crfRef', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#string', 'conceptURI': None, 'label': None, 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [{'rowId': 3027, 'errorMessage': None, 'new': True, 'expression': '~lte=4000', 'type': 'Length', 'description': None, 'name': 'Text Length', 'properties': {}}], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7316, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#submissionDate', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'submissionDate', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#dateTime', 'conceptURI': None, 'label': None, 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7297, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#patientName', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'patientName', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#string', 'conceptURI': None, 'label': 'Patient name', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [{'rowId': 3022, 'errorMessage': None, 'new': True, 'expression': '~lte=4000', 'type': 'Length', 'description': None, 'name': 'Text Length', 'properties': {}}], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7298, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#birthDate', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'birthDate', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#dateTime', 'conceptURI': None, 'label': 'Place of birth', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7299, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#birthPlace', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'birthPlace', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#string', 'conceptURI': None, 'label': 'Place of birth', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [{'rowId': 3023, 'errorMessage': None, 'new': True, 'expression': '~lte=4000', 'type': 'Length', 'description': None, 'name': 'Text Length', 'properties': {}}], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7300, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#histologyFlag', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'histologyFlag', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#int', 'conceptURI': None, 'label': 'Patient has Histologically confirmed localized (low-intermediate-high risk) prostate cance', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': 'lists', 'lookupQuery': 'enumBoolFlag', 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': True, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': 'lists.enumBoolFlag', 'fileType': False}, {'propertyId': 7305, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#patientWeight', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'patientWeight', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Weight (kg)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7306, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#patientWeightFlag', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'patientWeightMode', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#int', 'conceptURI': None, 'label': 'Mode of measurement', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': 'lists', 'lookupQuery': 'enumMeasurementMode', 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': True, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': 'lists.enumMeasurementMode', 'fileType': False}, {'propertyId': 7307, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#patientHeight', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'patientHeight', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Height (cm)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7308, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#participantCode', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'participantCode', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#string', 'conceptURI': None, 'label': None, 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [{'rowId': 3024, 'errorMessage': None, 'new': True, 'expression': '~lte=4000', 'type': 'Length', 'description': None, 'name': 'Text Length', 'properties': {}}], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7386, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#ECOGstatus', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'ECOGstatus', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#int', 'conceptURI': None, 'label': 'ECOG Performance Status', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': 'lists', 'lookupQuery': 'enumECOGStatus', 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': True, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': 'lists.enumECOGStatus', 'fileType': False}, {'propertyId': 7387, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#sysPressure', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'sysPressure', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Systolic Blood Pressure (Torr)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7388, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#diaPressure', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'diaPressure', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Diastolic Blood Pressure  (Torr)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7389, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#hgLevel', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'hgLevel', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Haemoglobin Level (g/dl)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 7390, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#leucocyteCount', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'leucocyteCount', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#double', 'conceptURI': None, 'label': 'Leucocyte Count (10^9/l)', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': None, 'lookupQuery': None, 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': True, 'dimension': False, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': '(none)', 'fileType': False}, {'propertyId': 9893, 'propertyURI': 'urn:lsid:labkey.com:IntList.Folder-61:demographicData-1#whoStatus', 'container': '1268c77b-7cf6-103a-9533-9caba13bc053', 'ontologyURI': None, 'name': 'whoStatus', 'description': None, 'rangeURI': 'http://www.w3.org/2001/XMLSchema#int', 'conceptURI': None, 'label': 'WHO Status', 'searchTerms': None, 'semanticType': None, 'format': None, 'required': False, 'hidden': False, 'lookupContainer': None, 'lookupSchema': 'lists', 'lookupQuery': 'enumWHOStatus', 'defaultValueType': 'FIXED_EDITABLE', 'defaultValue': None, 'defaultDisplayValue': '[none]', 'mvEnabled': False, 'importAliases': None, 'url': None, 'shownInInsertView': True, 'shownInUpdateView': True, 'shownInDetailsView': True, 'measure': False, 'dimension': True, 'recommendedVariable': False, 'defaultScale': 'LINEAR', 'facetingBehaviorType': 'AUTOMATIC', 'phi': 'NotPHI', 'scale': 4000, 'redactedText': None, 'conditionalFormats': [], 'propertyValidators': [], 'excludeFromShifting': False, 'setDimension': True, 'setMeasure': True, 'setExcludeFromShifting': True, 'typeEditable': True, 'preventReordering': False, 'disableEditing': False, 'lookupDescription': 'lists.enumWHOStatus', 'fileType': False}], 'indices': [], 'schemaName': None, 'queryName': None, 'templateDescription': None}\n"
     ]
    }
   ],
   "source": [
    "#specific tests\n",
    "project='hypoAfrica/Study'\n",
    "schema='lists'\n",
    "query='demographicData'\n",
    "ds=db.getQueryDesign(project,schema,query)\n",
    "print(ds)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "83418c1c-eec8-4439-b049-996bbc05321e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}