# coding: cp1251
import cx_Oracle
import fdb
import pprint
import threading
import datetime
import pythoncom
import time
res_spaces_queue=[]
ora_mutex=threading.Lock()
def get_soft_data(gissz_num,target_host):
    pythoncom.CoInitialize()
    ora_con = cx_Oracle.connect("orausr/orapass@"+target_host+"/XE")
    ora_cur = ora_con.cursor()
    ora_cur.execute("select dbms_utility.port_string, (select platform_name from v$database) ,(select version from v$instance) from dual")
    ora_mutex.acquire()
    for result in ora_cur:    
        res_spaces_queue.append([gissz_num,result[0],result[1],result[2]])
        
    ora_mutex.release()    
    ora_cur.close()
    ora_con.close()
    pythoncom.CoUninitialize()
#==========================================
#==========================================
# Main function
def main(argv=None):
    start_time=datetime.datetime.now()
    fb_conn = fdb.connect(dsn='firebird:d:\\NET_ANALISYS.FDB',user='user',password='password')
    fb_cur = fb_conn.cursor()
    SELECT=r"SELECT p.gissz_num,p.lanaddress FROM points p JOIN srv_roles s ON p.id=s.point JOIN srv_roles_types st ON st.id=s.""ROLE"" WHERE p.enabled=1 AND st.name ='ГИССЗ'"
    fb_cur.execute(SELECT)
    for row in fb_cur.fetchall():    
        t = threading.Thread(target=get_soft_data,name='id'+str(row[0]),args=(row[0],row[1],))         
        t.start()
    while threading.activeCount()>1:
        time.sleep(0.25)
    pprint.pprint(res_spaces_queue)
    
#==========================================        
if __name__ == "__main__":
    main()