X-Git-Url: http://git.osdn.net/view?p=rec10%2Frec10-git.git;a=blobdiff_plain;f=dist%2Ftrunk%2Frec10%2Frecdb.py;fp=dist%2Ftrunk%2Frec10%2Frecdb.py;h=b080755467f32ddc699becb30e80d039b3077bbe;hp=0000000000000000000000000000000000000000;hb=13e65e890a6dd60705bacc22b893ce5c899b7001;hpb=9b4c01d4fac3cef067298b660c72fe3755616a7e

diff --git a/dist/trunk/rec10/recdb.py b/dist/trunk/rec10/recdb.py
new file mode 100755
index 0000000..b080755
--- /dev/null
+++ b/dist/trunk/rec10/recdb.py
@@ -0,0 +1,95 @@
+#!/usr/bin/python
+# coding: UTF-8
+# Rec10 TS Recording Tools
+# Copyright (C) 2009-2011 Yukikaze
+import chdb
+import n_gram
+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):
+    tcount=count
+    if tcount<0:
+        tcount=-1
+    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=tcount)
+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=rec10d.rec10db.select_byepgtime_all_timeline(epgbtime,epgetime)
+    nel=rec10d.rec10db.select_bytime_all_timeline(epgbtime, epgetime)
+    dup=0
+    for t in tl:
+        if t["title"]==title and t["chtxt"]==chtxt:
+            dup=1
+        elif n_gram.trigram(t["title"],title)> 500 and t["chtxt"]==chtxt:
+            dup=1
+    for t in nel:
+        if t["title"]==title and t["chtxt"]==chtxt:
+            dup=1
+        elif n_gram.trigram(t["title"],title)> 500 and t["chtxt"]==chtxt:
+            dup=1
+    return dup