# start [int], # end [int], # duration [int] # } if len(sys.argv)!=2: print 'Usage: %s [directory path]' % (__file__) print ' parse all the files in the directory and generate database' sys.exit() filePath = sys.argv[1] save_done_path = filePath+'/../row_data_done/%s' %filePath.split('/')[-1] dirFileList = glob.glob(filePath + '/*') DB.setDBFile(filePath + '.db') for input_file in dirFileList: input_file_ptr = open(input_file, 'r') print "%s is starting..." % (input_file) doctorData_list = {} checkPointCount = 0 for line in input_file_ptr: line = line.strip('\n') token = line.split(' ') timeStamp = token[0] date = datetime.datetime.fromtimestamp( int(timeStamp) ).strftime('%Y-%m-%d') interval = token[1] dept = token[2] room = token[3]
f = open('temp/%s.txt' % doctorName, 'w') for k in range(1,8): store_n = {"morning":{}, "afternoon":{},"night":{}} #f.write("=====(%d)======\n" %k) # for k in range(len(weeksData[lastweek][today])) for i in weeksData[k]: for interval in weeksData[k][i]: for j in weeksData[k][i][interval]: if j not in store_n[interval] : store_n[interval][j] = [] store_n[interval][j].append(weeksData[k][i][interval][j]) else: store_n[interval][j].append(weeksData[k][i][interval][j]) #print(store_n) for inn in store_n: f.write("=====(%d %s)======\n" %(k,inn)) for num in range(len(store_n[inn])): #print (num+1, len(store_n[inn][num+1])) store_n[inn][num+1].sort() size_num = len(store_n[inn][num+1]) f.write('%d\t%.2f\t%d\t%s\n' %(num+1,store_n[inn][num+1][int(size_num/2)], size_num,inn)) f.close() debugFile.close() ########################## ## main ########################## DB.setDBFile('wanfang.db') result = DB.listAll() for doctor in result: generateData(doctor[1])
# This Python file uses the following encoding: utf-8 import database as DB import datetime import json import sys import math #DB.setDBFile('wanfang.db') DB.setDBFile('vghtpe.db') def two_digit_number(number): number = int(number) if number < 10: return '0' + str(number) return str(number) def transfer_minute(second): out_sec = second%60 second = second/60 out_min = second%60 out_hr = second/60 return '%s:%s:%s' % (two_digit_number(out_hr), two_digit_number(out_min), two_digit_number(out_sec)) def printUsage(): print 'please enter command:' print 'list list all doctor name and info' print 'doc [name] list the doctor\'s pacient data' print ' -date [YYYY-MM-DD] list on the date' print ' -weekday [1-7] list with the same weekday' print ' -interval [M|A|N] list with the interval' print 'export [filePath] export all daoctor data'