rec10/trunk/src/recdb.py

   1 #!/usr/bin/python
   2 # coding: UTF-8
   3 # Rec10 TS Recording Tools
   4 # Copyright (C) 2009 Yukikaze
   5 import recdb
   6 import rec10d
   7 """
   8 task names
   9 """
  10 global REC_RESERVE
  11 global REC_FINAL_RESERVE
  12 global REC_END
  13 global REC_ENCODE_GRID
  14 global REC_ENCODE_LOCAL
  15 global REC_ENCODE_QUE
  16 global REC_MIXING_SOUND
  17 global REC_MISS_ENCODE
  18 global REC_KEYWORD
  19 global REC_KEYWORD_EVERY_SOME_DAYS
  20 global REC_FIN_DECODE
  21 global REC_FIN_LOCAL
  22 global REC_MISS_DECODE
  23 global REC_TS_DECODING
  24 global REC_TS_RECORDING
  25 REC_RESERVE="res"
  26 REC_FINAL_RESERVE="rec"
  27 REC_END="end"
  28 REC_ENCODE_GRID="grid"
  29 REC_ENCODE_LOCAL="local"
  30 REC_ENCODE_QUE="ts2avi"
  31 REC_MIXING_SOUND="mixsound"
  32 REC_MISS_ENCODE="miss"
  33 REC_KEYWORD="key"
  34 REC_KEYWORD_EVERY_SOME_DAYS="keyevery"
  35 REC_FIN_DECODE="tsfin"
  36 REC_FIN_LOCAL="fin_local"
  37 REC_MISS_DECODE="tsmiss"
  38 REC_TS_DECODING="tsdecoding"
  39 REC_TS_RECORDING="tsrecording"
  40
  41 def recreserv(title,chtxt,btime,etime,opt):#optにはa(アニメ)d(副音声)v(xvid)
  42     rec_reckey("res",title,chtxt,btime,etime,opt)
  43 def keyreserv(keyword,chtxt,btime,etime,deltatime,opt):
  44     rec10d.rec10db.add_rectime(type=recdb.REC_KEYWORD,chtxt=chtxt,title=keyword,btime=btime,etime=etime,deltatime=deltatime,opt=opt)
  45 def everyreserv(keyword,chtxt,btime,etime,deltatime,opt,deltaday):
  46     rec10d.rec10db.add_rectime(type=recdb.REC_KEYWORD_EVERY_SOME_DAYS,chtxt=chtxt,title=keyword,btime=btime,etime=etime,deltatime=deltatime,opt=opt,deltaday=deltaday)
  47 def rec_reckey(type,title,chtxt,btime,etime,opt):
  48     rec10d.rec10db.add_rectime(type=type,chtxt=chtxt,title=title,btime=btime,etime=etime,opt=opt)
  49 def del_reckey(type,title,chtxt,btime):
  50     rec10d.rec10db.del_rectime(type=type,title=title,chtxt=chtxt,btime=btime)
  51 def getnow(dhour):
  52     return rec10d.rec10db.select_bytime_rectime(dhour)
  53 def countRecNow(dhour):
  54     d=getnow(dhour)
  55     ret=0
  56     for i in d:
  57         t=i['type']
  58         if t=="key" or t=="keyevery" or t=="rec" or t=="ret":
  59             ret=ret+1
  60     return ret
  61 def delete_old(dhour):
  62     """
  63     delete keys except recdb.REC_MISS_ENCODE and recdb.REC_KEYWORD_EVERY_SOME_DAYS before dhour hours from now.
  64     """
  65     rec10d.rec10db.delete_old_rectime(dhour)
  66 def getall():
  67     return rec10d.rec10db.select_all_rectime()