X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=rec10%2Ftrunk%2Fsrc%2Frecdb.py;h=0b9d625d5aab4c14937919fcb1049aa12e2c36d4;hb=c363a10d99acf08f3a298919ffd20c5f4660b666;hp=ebdfa5baad43051cc95470147859b516c3d1744d;hpb=c6d09b8884d77c8eff6e9540478e7fc4fd05177d;p=rec10%2Frec10-git.git diff --git a/rec10/trunk/src/recdb.py b/rec10/trunk/src/recdb.py index ebdfa5b..0b9d625 100644 --- a/rec10/trunk/src/recdb.py +++ b/rec10/trunk/src/recdb.py @@ -1,80 +1,83 @@ -#!/usr/bin/python -# coding: UTF-8 -# Rec10 TS Recording Tools -# Copyright (C) 2009 Yukikaze -import chdb -import rec10d -import recdblist - -def recreserv(title, chtxt, btime, etime, opt):#optにはa(アニメ)d(副音声)v(xvid) - rec_reckey("res", title, chtxt, btime, etime, opt) -def auto_keyreserv(keyword, chtxt, btime, etime, deltatime, opt): - rec10d.rec10db.add_timeline(type=recdblist.REC_AUTO_KEYWORD, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt) -def keyreserv(keyword, chtxt, btime, etime, deltatime, opt): - rec10d.rec10db.add_timeline(type=recdblist.REC_KEYWORD, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt) -def everyreserv(keyword, chtxt, btime, etime, deltatime, opt, deltaday): - rec10d.rec10db.add_timeline(type=recdblist.REC_KEYWORD_EVERY_SOME_DAYS, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt, deltaday=deltaday) -def rec_reckey(type, title, chtxt, btime, etime, opt): - rec10d.rec10db.add_timeline(type=type, chtxt=chtxt, title=title, btime=btime, etime=etime, opt=opt) -def del_reckey(type, title, chtxt, btime): - rec10d.rec10db.del_timeline(type=type, title=title, chtxt=chtxt, btime=btime) -def add_auto_keyword(chtxt,title,btime,etime): - rec10d.rec10db.add_auto_timeline_keyword(chtxt, title, btime, etime) -def add_auto_bayes(chtxt,title,btime,etime,point): - rec10d.rec10db.add_auto_timeline_bayes(chtxt, title, btime, etime,point) -def getnow(dhour): - dhour = int(dhour) - dminutes = 60 * dhour - dminutes = str(dminutes) - return rec10d.rec10db.select_bytime_timeline(dminutes) -def getnow_minutes(dminutes): - return rec10d.rec10db.select_bytime_timeline(dminutes) -def countRecNow(dhour): - d = getnow(dhour) - ret = 0 - for i in d: - t = i['type'] - if t == "key" or t == "keyevery" or t == "rec" or t == "res": - ret = ret + 1 - return ret -def countRecNow_minutes(dminutes): - d = getnow_minutes(dminutes) - ret = 0 - for i in d: - t = i['type'] - if t == "key" or t == "keyevery" or t == "rec" or t == "res": - ret = ret + 1 - return ret -def countRecNow_minutes_BSCS(dminutes): - d = getnow_minutes(dminutes) - ret = 0 - for i in d: - t = i['type'] - if t == "key" or t == "keyevery" or t == "rec" or t == "res": - if len(chdb.chtxtsearch(i['chtxt'])['ch']) > 2: - ret = ret + 1 - return ret -def countRecNow_minutes_TE(dminutes): - d = getnow_minutes(dminutes) - ret = 0 - for i in d: - t = i['type'] - if t == "key" or t == "keyevery" or t == "rec" or t == "res": - if len(chdb.chtxtsearch(i['chtxt'])['ch']) < 3: - ret = ret + 1 - return ret -def delete_old(dhour): - """ - delete keys except recdblist.REC_MISS_ENCODE and recdblist.REC_KEYWORD_EVERY_SOME_DAYS before dhour hours from now. - """ - rec10d.rec10db.delete_old_timeline(dhour) -def delete_old_auto_keyword(dhour): - rec10d.rec10db.delete_old_auto_timeline_keyword(dhour) -def delete_old_auto_bayes(dhour): - rec10d.rec10db.delete_old_auto_timeline_bayes(dhour) -def getall(): - return rec10d.rec10db.select_all_timeline() -def rec_reclog(title,chtxt,btime,etime,opt,exp,longexp,category): - rec10d.rec10db.add_in_timeline_log(chtxt,title,btime,etime,opt,exp,longexp,category) -def get_key(): - return rec10d.rec10db.select_all_in_auto_jbk_key() \ No newline at end of file +#!/usr/bin/python +# coding: UTF-8 +# Rec10 TS Recording Tools +# Copyright (C) 2009-2010 Yukikaze +import chdb +import rec10d +import recdblist + +def reserveKeyword(keyword, chtxt, btime, etime, deltatime, opt): + rec10d.rec10db.add_timeline(type=recdblist.REC_KEYWORD, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt) +def reserveEverydayKeyword(keyword, chtxt, btime, etime, deltatime, opt, deltaday,count): + rec10d.rec10db.add_timeline(type=recdblist.REC_KEYWORD_EVERY_SOME_DAYS, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt, deltaday=deltaday,counter=count) +def reserveReckey(type, title, chtxt, btime, etime, opt): + rec10d.rec10db.add_timeline(type=type, chtxt=chtxt, title=title, btime=btime, etime=etime, opt=opt) +def deleteReckey(type, title, chtxt, btime): + rec10d.rec10db.del_timeline(type=type, title=title, chtxt=chtxt, btime=btime) +def reserveAutoKeyword(chtxt,title,btime,etime): + rec10d.rec10db.add_auto_timeline_keyword(chtxt, title, btime, etime) +def addAutoBayesKeyword(chtxt,title,btime,etime,point): + rec10d.rec10db.add_auto_timeline_bayes(chtxt, title, btime, etime,point) +def getProgramsInTheseHours(dhour): + dhour = int(dhour) + dminutes = 60 * dhour + dminutes = str(dminutes) + return rec10d.rec10db.select_bytime_timeline(dminutes) +def getProgramsInTheseMinutes(dminutes): + return rec10d.rec10db.select_bytime_timeline(dminutes) +def countRecNow(dhour): + d = getProgramsInTheseHours(dhour) + ret = 0 + for i in d: + t = i['type'] + if t == "key" or t == "keyevery" or t == "rec" or t == "res": + ret = ret + 1 + return ret +def countRecNow_minutes(dminutes): + d = getProgramsInTheseMinutes(dminutes) + ret = 0 + for i in d: + t = i['type'] + if t == "key" or t == "keyevery" or t == "rec" or t == "res": + ret = ret + 1 + return ret +def countRecNow_minutes_BSCS(dminutes): + d = getProgramsInTheseMinutes(dminutes) + ret = 0 + for i in d: + t = i['type'] + if t == "key" or t == "keyevery" or t == "rec" or t == "res": + if len(chdb.searchCHFromChtxt(i['chtxt'])['ch']) > 2: + ret = ret + 1 + return ret +def countRecNow_minutes_TE(dminutes): + d = getProgramsInTheseMinutes(dminutes) + ret = 0 + for i in d: + t = i['type'] + if t == "key" or t == "keyevery" or t == "rec" or t == "res": + if len(chdb.searchCHFromChtxt(i['chtxt'])['ch']) < 3: + ret = ret + 1 + return ret +def deleteOldProgramBeforeTheseHours(dhour): + """ + delete keys except recdblist.REC_MISS_ENCODE and recdblist.REC_KEYWORD_EVERY_SOME_DAYS before dhour hours from now. + """ + rec10d.rec10db.delete_old_timeline(dhour) +def delete_old_auto_keyword(dhour): + rec10d.rec10db.delete_old_auto_timeline_keyword(dhour) +def delete_old_auto_bayes(dhour): + rec10d.rec10db.delete_old_auto_timeline_bayes(dhour) +def getAll(): + return rec10d.rec10db.select_all_timeline() +def addRecLogProgram(title,chtxt,btime,etime,opt,exp,longexp,category): + rec10d.rec10db.add_in_timeline_log(chtxt,title,btime,etime,opt,exp,longexp,category) +def getAllJbkKeyword(): + return rec10d.rec10db.select_all_in_auto_jbk_key() +def checkDuplicated(title,chtxt,epgbtime,epgetime): + tl=rec10dbselect_byepgtime_all_timeline(epgbtime,epgetime) + dup=0 + for t in tl: + if t["title"]==title and t["chtxt"]==chtxt: + dup=1 + return dup