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}')
