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
