def handleConnect(sock, addr): dbconn, cur = do_init() print('total connect:', total_in_list()) myLog.mylogger.error('total connect:%s', total_in_list()) while True: try: b_data = sock.recv(1024) if b_data == b'': print('reomte closed!') sock.close() break #print(len(b_data), b_data) myLog.mylogger.debug('recv %s %s %s',addr[0], addr[1], str(b_data)) #¡¡process data r_data = processData.process_data(b_data, dbconn, cur) sock.send(r_data) except: # should not get error while print exception print(traceback.format_exc()) myLog.mylogger.error(traceback.format_exc()) break do_finish(dbconn, cur, sock) print('left connect:', total_in_list()) myLog.mylogger.error('left connect:%s', total_in_list()) return
def handleConnect(sock, addr): dbconn, cur = do_init() print("total connect:", total_in_list()) myLog.mylogger.error("total connect:%s", total_in_list()) while True: try: b_data = sock.recv(1024) if b_data == b"": print("reomte closed!") sock.close() break # print(len(b_data), b_data) myLog.mylogger.debug("recv %s %s %s", addr[0], addr[1], str(b_data)) # ¡¡process data r_data, infos = processData.process_data(b_data) sock.send(r_data) # proecss db processDB.process_db(infos, dbconn, cur) except: # should not get error while print exception print(traceback.format_exc()) myLog.mylogger.error(traceback.format_exc()) break do_finish(dbconn, cur, sock) print("left connect:", total_in_list()) myLog.mylogger.error("left connect:%s", total_in_list()) return
def handleConnect(queue): if platform.system() == 'Windows': sock = queue.get() dbconn, cur = do_init() while True: try: b_data = sock.recv(1024) #print(b_data) if b_data == b'': print('reomte closed!') sock.close() break r_data = processData.process_data(b_data, dbconn, cur) sock.send(r_data) #print('send over') except: print(traceback.format_exc()) break do_finish(dbconn, cur, sock) print('sub process done') return
state = input('Enter state name again. Please check spelling: ') # set up db path = os.path.dirname(os.path.abspath(__file__)) conn = sqlite3.connect(path + '/' + 'census_data.db') cur = conn.cursor() # call income and poverty api print('Calling income and poverty API . . .') get_income_and_poverty(cur, conn) # call race api print('Calling race API . . .') get_race(cur, conn) # process data and send to output file output_file = path + '/output' data = process_data(cur, conn, state_codes[state], output_file) with open(output_file, 'w') as out: out.writelines('|'.join(str(j) for j in i) + '\n' for i in data[:-2]) out.write(data[-2]) out.write(data[-1]) print(f'Processed data in {output_file}') # create visualizetions if not os.path.exists('visualizations'): os.makedirs('visualizations') output_folder = path + '/visualizations/' visualize(data, output_folder, state) print(f'Data Visuals in {output_folder}')