def getLinkTypes(): errCode = 0 # validate access token accessToken = request.headers['token'] checkToken = tokenValidate(accessToken) if checkToken['status'] > 200: errCode = 14001 message = checkToken['message'] result = {"status": errCode, "message": message} if errCode == 0: cmd = "select * from FHIR247.REF_LINK_TYPE" conn = phoenixConn() cursor = conn.cursor() cursor.execute(cmd) listUser = cursor.fetchall() User = [] for data in listUser: UserJSON = {} UserJSON['code'] = data[0] UserJSON['display'] = data[1] UserJSON['definition'] = data[2] User.append(UserJSON) conn.close() result = User return result
def addAdministrativeGender(): errCode = 0 # validate access token accessToken = request.headers['token'] checkToken = tokenValidate(accessToken) if checkToken['status'] > 200: errCode = 14001 message = checkToken['message'] # request data = request.data dataUser = json.loads(data) # code if 'code' in dataUser and dataUser['code'] != '': code = dataUser['code'] else: errCode = 14003 message = "Code is required." # display if 'display' in dataUser and dataUser['display'] != '': display = dataUser['display'] else: errCode = 14003 message = "display is required." # definition if 'definition' in dataUser and dataUser['definition'] != '': definition = dataUser['definition'] else: errCode = 14003 message = "definition is required." if errCode == 0: conn = phoenixConn() cursor = conn.cursor() #insert try: cmd = "UPSERT INTO FHIR247.REF_ADMINISTRATIVE_GENDER " \ "(CODE, DISPLAY, DEFINITION) " \ " VALUES" \ "('" + code + "','" + display + "','" + definition + "')" cursor.execute(cmd) conn.close() errCode = 200 message = "User added successfully" except OSError as err: errCode = 13002 message = err result = {"status": errCode, "message": message} else: result = {"status": errCode, "message": message} return result
def updateLanguage(code): errCode = 0 # validate access token accessToken = request.headers['token'] checkToken = tokenValidate(accessToken) if checkToken['status'] > 200: errCode = 14001 message = checkToken['message'] result = {"status": errCode, "message": message} # request data = request.data dataUser = json.loads(data) # code if 'code' in dataUser and dataUser['code'] != '': codee = dataUser['code'] else: errCode = 14003 message = "Code is required." result = {"status": errCode, "message": message} # display if 'display' in dataUser and dataUser['display'] != '': display = dataUser['display'] else: errCode = 14003 message = "display is required." result = {"status": errCode, "message": message} if errCode == 0: connDB = phoenixConn() cursor = connDB.cursor() try: select = "SELECT CODE FROM FHIR247.REF_LANGUAGES WHERE CODE = '" + code + "'" cursor.execute(select) dataCode = cursor.fetchone() errCode = 14002 if dataCode: cmd = "UPSERT INTO FHIR247.REF_LANGUAGES " \ "(CODE, DISPLAY) " \ " VALUES" \ "('" + codee + "','" + display + "')" cursor.execute(cmd) conn.close() errCode = 200 message = "User updated successfully" result = {"status": errCode, "message": message} else: message = "Data doesn't exist" result = {"status": errCode, "message": message} except OSError as err: errCode = 13002 message = err result = {"status": errCode, "message": message} return result
def getMaritalStatus(code): errCode = 0 # validate access token accessToken = request.headers['token'] checkToken = tokenValidate(accessToken) if checkToken['status'] > 200: errCode = 14001 message = checkToken['message'] result = {"status": errCode, "message": message} if errCode == 0: conn = phoenixConn() cursor = conn.cursor() try: select = "SELECT CODE FROM FHIR247.REF_MARITAL_STATUS WHERE CODE = '" + code + "'" cursor.execute(select) dataCode = cursor.fetchone() errCode = 14002 if dataCode: cmd = "select * from FHIR247.REF_MARITAL_STATUS WHERE code = '" + code + "' " cursor.execute(cmd) listUser = cursor.fetchall() User = [] for data in listUser: UserJSON = {} UserJSON['code'] = data[0] UserJSON['system'] = data[1] UserJSON['display'] = data[2] UserJSON['definition'] = data[3] User.append(UserJSON) conn.close() result = User else: message = "Data doesn't exist" result = {"status": errCode, "message": message} except OSError as err: errCode = 13002 message = err result = {"status": errCode, "message": message} return result
def deleteLanguage(code): errCode = 0 # validate access token accessToken = request.headers['token'] checkToken = tokenValidate(accessToken) if checkToken['status'] > 200: errCode = 14001 message = checkToken['message'] result = {"status": errCode, "message": message} if errCode == 0: conn = phoenixConn() cursor = conn.cursor() try: select = "SELECT CODE FROM FHIR247.REF_LANGUAGES WHERE CODE = '" + code + "'" cursor.execute(select) dataCode = cursor.fetchone() errCode = 14002 if dataCode: cmd = "DELETE from FHIR247.REF_LANGUAGES WHERE code = '" + code + "' " cursor.execute(cmd) conn.close() errCode = 200 message = "Successfully deleted" result = {"status": errCode, "message": message} else: message = "Data doesn't exist" result = {"status": errCode, "message": message} except OSError as err: errCode = 13002 message = err result = {"status": errCode, "message": message} return result