rec10/trunk/src/recdb.py

   1 #!/usr/bin/python
   2 # coding: UTF-8
   3 # Rec10 TS Recording Tools
   4 # Copyright (C) 2009-2010 Yukikaze
   5 import chdb
   6 import rec10d
   7 import recdblist
   8
   9 def recreserv(title, chtxt, btime, etime, opt):#optにはa(アニメ)d(副音声)v(xvid)
  10     rec_reckey("res", title, chtxt, btime, etime, opt)
  11 def auto_keyreserv(keyword, chtxt, btime, etime, deltatime, opt):
  12     rec10d.rec10db.add_timeline(type=recdblist.REC_AUTO_KEYWORD, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt)
  13 def keyreserv(keyword, chtxt, btime, etime, deltatime, opt):
  14     rec10d.rec10db.add_timeline(type=recdblist.REC_KEYWORD, chtxt=chtxt, title=keyword, btime=btime, etime=etime, deltatime=deltatime, opt=opt)
  15 def everyreserv(keyword, chtxt, btime, etime, deltatime, opt, deltaday,count):
  16     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)
  17 def rec_reckey(type, title, chtxt, btime, etime, opt):
  18     rec10d.rec10db.add_timeline(type=type, chtxt=chtxt, title=title, btime=btime, etime=etime, opt=opt)
  19 def del_reckey(type, title, chtxt, btime):
  20     rec10d.rec10db.del_timeline(type=type, title=title, chtxt=chtxt, btime=btime)
  21 def add_auto_keyword(chtxt,title,btime,etime):
  22     rec10d.rec10db.add_auto_timeline_keyword(chtxt, title, btime, etime)
  23 def add_auto_bayes(chtxt,title,btime,etime,point):
  24     rec10d.rec10db.add_auto_timeline_bayes(chtxt, title, btime, etime,point)
  25 def getnow(dhour):
  26     dhour = int(dhour)
  27     dminutes = 60 * dhour
  28     dminutes = str(dminutes)
  29     return rec10d.rec10db.select_bytime_timeline(dminutes)
  30 def getnow_minutes(dminutes):
  31     return rec10d.rec10db.select_bytime_timeline(dminutes)
  32 def countRecNow(dhour):
  33     d = getnow(dhour)
  34     ret = 0
  35     for i in d:
  36         t = i['type']
  37         if t == "key" or t == "keyevery" or t == "rec" or t == "res":
  38             ret = ret + 1
  39     return ret
  40 def countRecNow_minutes(dminutes):
  41     d = getnow_minutes(dminutes)
  42     ret = 0
  43     for i in d:
  44         t = i['type']
  45         if t == "key" or t == "keyevery" or t == "rec" or t == "res":
  46             ret = ret + 1
  47     return ret
  48 def countRecNow_minutes_BSCS(dminutes):
  49     d = getnow_minutes(dminutes)
  50     ret = 0
  51     for i in d:
  52         t = i['type']
  53         if t == "key" or t == "keyevery" or t == "rec" or t == "res":
  54             if len(chdb.getChCSchFromCHtxt(i['chtxt'])['ch']) > 2:
  55                 ret = ret + 1
  56     return ret
  57 def countRecNow_minutes_TE(dminutes):
  58     d = getnow_minutes(dminutes)
  59     ret = 0
  60     for i in d:
  61         t = i['type']
  62         if t == "key" or t == "keyevery" or t == "rec" or t == "res":
  63             if len(chdb.getChCSchFromCHtxt(i['chtxt'])['ch']) < 3:
  64                 ret = ret + 1
  65     return ret
  66 def delete_old(dhour):
  67     """
  68     delete keys except recdblist.REC_MISS_ENCODE and recdblist.REC_KEYWORD_EVERY_SOME_DAYS before dhour hours from now.
  69     """
  70     rec10d.rec10db.delete_old_timeline(dhour)
  71 def delete_old_auto_keyword(dhour):
  72     rec10d.rec10db.delete_old_auto_timeline_keyword(dhour)
  73 def delete_old_auto_bayes(dhour):
  74     rec10d.rec10db.delete_old_auto_timeline_bayes(dhour)
  75 def getAll():
  76     return rec10d.rec10db.select_all_timeline()
  77 def rec_reclog(title,chtxt,btime,etime,opt,exp,longexp,category):
  78     rec10d.rec10db.add_in_timeline_log(chtxt,title,btime,etime,opt,exp,longexp,category)
  79 def get_key():
  80     return rec10d.rec10db.select_all_in_auto_jbk_key()
  81 def checkduplicate(title,chtxt,epgbtime,epgetime):
  82     tl=rec10dbselect_byepgtime_all_timeline(epgbtime,epgetime)
  83     dup=0
  84     for t in tl:
  85         if t["title"]==title and t["chtxt"]==chtxt:
  86             dup=1
  87     return dup