def sql_t():
con_db2 = DAL.DB2('IPACSDB','192.168.130.66','50000','db2inst1','db2inst1')
if con_db2:
#sql = "select * from PACS.TX_PACS where PATIENT_ID = '63023596' and to_char(STUDY_DATE,'yyyy-mm-dd') >= CURRENT DATE"
sql = "select to_char(STUDY_DATE,'yyyy-mm-dd') from PACS.TX_PACS where PATIENT_ID = '63023596'"
result = con_db2.execute(sql)
print result
con_db2.close()
def select_path_from_db2(ris_list):
con_db2 = DAL.DB2('database_name', 'host', 'port', 'user', 'pwd')
if con_db2:
Ris_list = ris_list
Patient_info_list = []
for ris_id in Ris_list:
sql = "select PATIENT_ID,SERIES_UID,to_char(STUDY_DATE,'yyyymmdd') from VIEW_NAME where PATIENT_ID = '{}' and to_char(STUDY_DATE,'yyyy-mm-dd') >= CURRENT DATE".format(
ris_id)
result = con_db2.execute(sql)
if len(result) > 0:
root = '/..../.../Data/isilon.thyy.com/'
series_list = [root + s[2] + '/CT/' + s[1] for s in result]
patient_info = [s[0], series_list]
Patient_info_list.append(patient_info)
#print Patient_info_list,'---------'+str(len(Patient_info_list))
print Patient_info_list
con_db2.close()
return Patient_info_list
def select_path_from_db2(ris_list):
con_db2 = DAL.DB2('IPACSDB','192.168.130.66','50000','db2inst1','db2inst1')
if con_db2:
Ris_list = select_id_list_from_sqls(False)
Patient_info_list = []
for ris_id in Ris_list:
sql = "select SERIES_UID,to_char(STUDY_DATE,'yyyymmdd') from PACS.TX_PACS where PATIENT_ID = '{}'".format(ris_id)
result = con_db2.execute(sql)
# Patient_info_list.append(result)
if len(result) > 0:
series_list = [s for s in result]
series_id_list =[i[1]+'/XA/'+i[0] for i in series_list]
Patient_info_list.append(i[1]+'/XA/'+i[0])
# patient_info = [s[0],series_list]
# Patient_info_list.append(series_list)
print Patient_info_list
print len(Patient_info_list)
con_db2.close()
return Patient_info_list
