# 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'
