# Rec10 TS Recording Tools
# Copyright (C) 2009 Yukikaze
import cgi
-import cgitb;cgitb.enable()
+#import cgitb;cgitb.enable()
import rec10web_dbMySQL
import rec10web_dbSQLite
import os
"""
return rec num (int return[0]:TE /int return[1]:BS/CS)
"""
+ def cmpare(x,y):
+ xt=datetime.datetime(*time.strptime(x,"%Y-%m-%d %H:%M:%S")[:-3])
+ yt=datetime.datetime(*time.strptime(y,"%Y-%m-%d %H:%M:%S")[:-3])
+ if xt>yt:
+ return -1
+ elif xt==yt:
+ return 0
+ else:
+ return 1
+ dls=database.schedule_rectime(btime,etime)
+ print dls
+ times=[]
+ for dl in dls:
+ times.append(datetime.datetime(*time.strptime(dl[4],"%Y-%m-%d %H:%M:%S")[:-3]))
+ times.append(datetime.datetime(*time.strptime(dl[5],"%Y-%m-%d %H:%M:%S")[:-3]))
+ print times
+ times=list(set(times))
+ print times
+ times=times.sort()
+ print times
+ #
+ """
#typet,bctypet, chtxtt,titlet,btime,etime
def rectime_count(btimeb,etimee,liststemp):
##btimeからetimeまでの中に入る数を数えるとともに
et=datetime.datetime(*time.strptime(etimee,"%Y-%m-%d %H:%M:%S")[:-3])
lists=liststemp
count=[0,0]#te,bscs
- bttemp
+ #bttemp
retlists=[]
for list in lists:
btt=datetime.datetime(*time.strptime(list[4],"%Y-%m-%d %H:%M:%S")[:-3])
count[1]=count[1]+1
elif list[1].find("te")>-1:
count[0]=count[0]+1
- """if ettemp>ett:
- ettemp=et"""
+ #if ettemp>ett:
+ # ettemp=et
if btt<et and ett>et:
btt=et
if btt>=et:
return [count,retlists]
#btime=dbt.strftime("%Y-%m-%d %H:%M:%S")
#etime=det.strftime("%Y-%m-%d %H:%M:%S")
- dls=database.schedule_rectime(btime,etime)
+ dis=database.schedule_rectime(btime,etime)
+ print dis
btemp=datetime.datetime(*time.strptime(dis[0][4],"%Y-%m-%d %H:%M:%S")[:-3])
etemp=datetime.datetime(*time.strptime(dis[0][5],"%Y-%m-%d %H:%M:%S")[:-3])
retcount=[0,0]
+ retend=0
while retend==0:
btemp=datetime.datetime(*time.strptime(dis[0][4],"%Y-%m-%d %H:%M:%S")[:-3])
etemp=datetime.datetime(*time.strptime(dis[0][5],"%Y-%m-%d %H:%M:%S")[:-3])
- for dl in dls:
+ for dl in dis:
btemptt=datetime.datetime(*time.strptime(dl[4],"%Y-%m-%d %H:%M:%S")[:-3])
etemptt=datetime.datetime(*time.strptime(dl[5],"%Y-%m-%d %H:%M:%S")[:-3])
if btemp>btemptt:
etemp=etemptt
bt2=btemp.strftime("%Y-%m-%d %H:%M:%S")
et2=etemp.strftime("%Y-%m-%d %H:%M:%S")
- ret2=rectime_count(bt2,et2,dls)
+ ret2=rectime_count(bt2,et2,dis)
+ print bt2+":"+et2
+ print ret2[0]
if retcount[0]<ret2[0][0]:
retcount[0]=ret2[0][0]
if retcount[1]<ret2[0][1]:
retcount[1]=ret2[0][1]
- dls=ret2[1]
+ dis=ret2[1]
if len(dis)==0:
break
elif dis[0][4]==btime:
break
- return retcount
+ return retcount"""
def change_reserv(id,type,keyword,chtxt,btime,etime,deltatime,opt,deltaday):
"""
idはテキスト
db[1].execute(dbexe,(btime,etime))
rets=[]
for typet,bctypet, chtxtt, titlet,btimet,etimet in db[1].fetchall():
- ret=[typet,bctypet,chtxtt,titlet,btimet,etimet]
+ ret=[typet,bctypet,chtxtt,titlet,btimet.strftime("%Y-%m-%d %H:%M:%S"),etimet.strftime("%Y-%m-%d %H:%M:%S")]
rets.append(ret)
self.close_db(db)
return rets