-#!/usr/bin/python
-# coding: UTF-8
-# Rec10 TS Recording Tools
-# Copyright (C) 2009 Yukikaze
-import os
-import time
-import sqlite3
-import chdb
-import datetime
-import ts2epg
-import xml2db
-import n_gram
-path=str(os.path.dirname(os.path.abspath(__file__)))+"/"
-tmppath=path
-def update(chtxt):
- print chtxt
- tnow=datetime.datetime.now()
- try:
- lastup=datetime.datetime.strptime(chdb.chtxtsearch(chtxt)[0]['update'],"%Y-%m-%d %H:%M:%S")
- except:
- lastup=datetime.datetime.strptime("2009-04-01 00:00:00","%Y-%m-%d %H:%M:%S")
- dt=tnow-lastup
- dt=dt.days*24*60+dt.seconds
- if dt>2*60*60:
- ts2epg.write(tmppath+"epgdate.xml",chdb.chtxtsearch(chtxt)['ch'])
- xml2db.xml2db(tmppath+"epgdate.xml",path+"ch.db",chdb.chtxtsearch(chtxt)['bctype'])
-def updatebc(bctype):
- bctypel=chdb.bctypesearch(bctype)
- print bctypel
- i=1
- while i<5:
- try:
- ts2epg.write(tmppath+"epgdate.xml",chdb.bctypesearch(bctype)['ch'])
- xml2db.xml2db(tmppath+"epgdate.xml",path+"ch.db",bctype)
- break
- except:
- i=i+1
-def updateall():
- update("hisch")
- update("nhk-k")
- update("nhk-s")
- update("me-tere")
- update("cbc")
- update("aichi")
- update("toukai")
- update("chukyo")
- update("bs-nhk-1")
-
-def search(titletxt):
- dbpath=path+"ch.db"
- db=sqlite3.connect(dbpath)
- #print dbpath
- ret=[]
- for ch, title, start, stop in db.execute("SELECT channel,title,start,stop FROM tv WHERE title LIKE \"%"+titletxt+"%\""):
- btime=start.replace(" +0900","")
- btime=btime[0:4]+"-"+btime[4:6]+"-"+btime[6:8]+" "+btime[8:10]+":"+btime[10:12]+":00"
- etime=stop.replace(" +0900","")
- etime=etime[0:4]+"-"+etime[4:6]+"-"+etime[6:8]+" "+etime[8:10]+":"+etime[10:12]+":00"
- try:
- chtxt=chdb.ontvsearch(ch)['chtxt']
- except:
- chtxt="Unknown"
- #print ch
- ret.append(chtxt+","+title.encode('utf-8')+","+btime+","+etime)
- db.close()
- return ret
-def searchtime(titletxt,time,deltatime):#時間以内のものだけを表示 deltatimeはhours
- dbpath=path+"ch.db"
- db=sqlite3.connect(dbpath)
- #print dbpath
- ret=[]
- deltatime=int(deltatime)
- for ch, title, start, stop in db.execute("SELECT channel,title,start,stop FROM tv WHERE title LIKE \"%"+titletxt+"%\""):
- btime=start.replace(" +0900","")
- btime=btime[0:4]+"-"+btime[4:6]+"-"+btime[6:8]+" "+btime[8:10]+":"+btime[10:12]+":00"
- etime=stop.replace(" +0900","")
- etime=etime[0:4]+"-"+etime[4:6]+"-"+etime[6:8]+" "+etime[8:10]+":"+etime[10:12]+":00"
- bt=datetime.datetime.strptime(btime,"%Y-%m-%d %H:%M:%S")
- t=datetime.datetime.strptime(time,"%Y-%m-%d %H:%M:%S")
- try:
- chtxt=chdb.ontvsearch(ch)['chtxt']
- except:
- chtxt="Unknown"
- #print ch
- dt=bt-t
- dt=dt.days*24*60*60+dt.seconds
- dt=abs(dt)
- if dt<deltatime*60*60:
- ret.append(chtxt+","+title.encode('utf-8')+","+btime+","+etime)
- print title
- db.close()
- return ret
-def searchtime2(titletxt,timet,deltatime,chtxt):
- time=datetime.datetime.strptime(timet,"%Y-%m-%d %H:%M:%S")
- dbpath=path+"ch.db"
- db=sqlite3.connect(dbpath)
- #print dbpath
- ret=[]
- deltatime=int(deltatime)
- beforetime=time.strftime("%Y%m%d%H%M%S")
- aftertime=time+datetime.timedelta(hours=deltatime)
- aftertime=aftertime.strftime("%Y%m%d%H%M%S")
- dbexe="SELECT chdata.chtxt,title,start,stop FROM tv INNER JOIN chdata WHERE chdata.ontv=tv.channel AND start >= \""+beforetime+"\" AND start <= \""+aftertime+"\" AND chdata.chtxt=\""+chtxt+"\""
- #print dbexe
- one={}
- tempt=0
- for chtxtt, title, start, stop in db.execute(dbexe):
- ret=[]
- p=n_gram.bigram(titletxt,title)
- btime=start
- btime=btime[0:4]+"-"+btime[4:6]+"-"+btime[6:8]+" "+btime[8:10]+":"+btime[10:12]+":00"
- etime=stop
- etime=etime[0:4]+"-"+etime[4:6]+"-"+etime[6:8]+" "+etime[8:10]+":"+etime[10:12]+":00"
- bt=datetime.datetime.strptime(btime,"%Y-%m-%d %H:%M:%S")
- et=datetime.datetime.strptime(etime,"%Y-%m-%d %H:%M:%S")
- dt=bt-time
- dt=24*60*60*dt.days+dt.seconds+1
- p=p*90
- dt=1000-1000*dt/(7*24*60*60)
- if p>0:
- p=p+dt
- print dt
- if p>tempt:
- one=chtxtt+","+title.encode('utf-8')+","+btime+","+etime
- tempt=p
- if p>0:
- print title+":"+str(p)+"点"
- db.close()
- ret.append(one)
- print ret
- return ret
+#!/usr/bin/python\r
+# coding: UTF-8\r
+# Rec10 TS Recording Tools\r
+# Copyright (C) 2009-2010 Yukikaze\r
+import datetime\r
+import os\r
+import shutil\r
+import time\r
+import os.path\r
+import traceback\r
+\r
+import chdb\r
+import n_gram\r
+import rec10d\r
+import ts2epg\r
+import xml2db_dom\r
+import configreader\r
+import recdblist\r
+path = str(os.path.dirname(os.path.abspath(__file__))) + "/"\r
+tmppath = configreader.getConfPath("tmp")+"/"\r
+if tmppath=="/":\r
+ tmppath=path\r
+def update(chtxt):\r
+ recdblist.printutf8(chtxt)\r
+ tnow = datetime.datetime.now()\r
+ try:\r
+ lastup = datetime.datetime.strptime(chdb.searchCHFromChtxt(chtxt)[0]['update'], "%Y-%m-%d %H:%M:%S")\r
+ except:\r
+ lastup = datetime.datetime.strptime("2009-04-01 00:00:00", "%Y-%m-%d %H:%M:%S")\r
+ dt = tnow-lastup\r
+ dt = dt.days * 24 * 60 + dt.seconds\r
+ if dt > 2 * 60 * 60:\r
+ ts2epg.writeEpgXML(os.path.join(tmppath, chtxt + "epgdata.xml"), chdb.searchCHFromChtxt(chtxt)['ch'])\r
+ xml2db_dom.xml2db_dom(os.path.join(tmppath, chtxt + "epgdata.xml"), chdb.searchCHFromChtxt(chtxt)['bctype'])\r
+def updatebc(bctype):\r
+ bctypel = chdb.searchCHFromBctype(bctype)\r
+ #print bctype\r
+ try:\r
+ ts2epg.writeEpgXML(tmppath + bctype + "epgdata.xml", chdb.searchCHFromBctype(bctype)['ch'])\r
+ xml2db_dom.xml2db_dom(tmppath + bctype + "epgdata.xml", bctype)\r
+ shutil.copyfile(tmppath + bctype + "epgdata.xml", tmppath + bctype + "epgdata.bak.xml")\r
+ time.sleep(5)\r
+ rec10d.rec10db.update_by_bctype_epg_ch(bctype)\r
+ except Exception, inst:\r
+ recdblist.addCommonlogEX("Error","updatebc(epgdb.py)", str(type(inst)), str(inst)+"\n"+traceback.format_exc(),log_level=200)\r
+ xml2db_dom.xml2db_dom(tmppath + bctype + "epgdata.bak.xml", bctype)\r
+ rec10d.rec10db.update_status_by_bctype_epg_ch(bctype, "2")\r
+def searchTime(titletxt, timet, deltatime, chtxt):\r
+ time = datetime.datetime.strptime(timet, "%Y-%m-%d %H:%M:%S")\r
+ ret = []\r
+ deltatime = int(deltatime)\r
+ beforetime = time.strftime("%Y%m%d%H%M%S")\r
+ beforetime = time - datetime.timedelta(hours=deltatime)\r
+ aftertime = time + datetime.timedelta(hours=deltatime)\r
+ beforetime = beforetime.strftime("%Y%m%d%H%M%S")\r
+ aftertime = aftertime.strftime("%Y%m%d%H%M%S")\r
+ one = ["", "", "", "","","",""]\r
+ tempt = 0\r
+ chtxtt=chtxt.replace("_0","_%")\r
+ d = rec10d.rec10db.select_by_time_ngram_epg_timeline(beforetime, aftertime, chtxtt)\r
+ for chtxtt, title, start, stop ,exp,longexp,category in d:\r
+ #recdblist.printutf8(chtxtt+":"+title+":"+start+":"+stop)\r
+ p = n_gram.bigram(titletxt, title)\r
+ btime = start\r
+ btime = btime[0:4] + "-" + btime[4:6] + "-" + btime[6:8] + " " + btime[8:10] + ":" + btime[10:12] + ":00"\r
+ etime = stop\r
+ etime = etime[0:4] + "-" + etime[4:6] + "-" + etime[6:8] + " " + etime[8:10] + ":" + etime[10:12] + ":00"\r
+ bt = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")\r
+ dt = bt-time\r
+ dt = abs(dt)\r
+ dt = 24 * 60 * 60 * dt.days + dt.seconds + 1\r
+ p = p * 90\r
+ dt = 1000-1000 * dt / (7 * 24 * 60 * 60)\r
+ if p > 0:\r
+ p = p + dt\r
+ if p > tempt:\r
+ one = [chtxtt, title, btime, etime,exp,longexp,category]\r
+ tempt = p\r
+ if p > 0:\r
+ #recdblist.printutf8(title + ":" + str(p) + u"点")\r
+ ""\r
+ ret = one\r
+ #print ret\r
+ return ret\r
+def searchTimeAuto(keytxt, timet, deltatime):\r
+ time = datetime.datetime.strptime(timet, "%Y-%m-%d %H:%M:%S")\r
+ ret = []\r
+ deltatime = int(deltatime)\r
+ beforetime = time.strftime("%Y%m%d%H%M%S")\r
+ aftertime = time + datetime.timedelta(hours=deltatime)\r
+ aftertime = aftertime.strftime("%Y%m%d%H%M%S")\r
+ d = rec10d.rec10db.select_by_time_keyword_auto_suggest_epg_timeline(keytxt,beforetime, aftertime)\r
+ for chtxtt, title, start, stop ,exp,longexp,category in d:\r
+ btime = start\r
+ btime = btime[0:4] + "-" + btime[4:6] + "-" + btime[6:8] + " " + btime[8:10] + ":" + btime[10:12] + ":00"\r
+ etime = stop\r
+ etime = etime[0:4] + "-" + etime[4:6] + "-" + etime[6:8] + " " + etime[8:10] + ":" + etime[10:12] + ":00"\r
+ ret.append([chtxtt, title, btime, etime,exp,longexp,category])\r
+ return ret\r
+def countSchedule(btime,etime):\r
+ """\r
+ return rec num (int return[0]:TE /int return[1]:BS/CS)\r
+ """\r
+ def cmpare(x, y):\r
+ xt = x\r
+ yt = y\r
+ if xt > yt:\r
+ return -1\r
+ elif xt == yt:\r
+ return 0\r
+ else:\r
+ return 1\r
+ dls = rec10d.rec10db.select_bytime_all_timeline(btime, etime)\r
+ times = []\r
+ btd = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")\r
+ etd = datetime.datetime.strptime(etime, "%Y-%m-%d %H:%M:%S")\r
+ for dl in dls:\r
+ dd1 = datetime.datetime.strptime(dl['btime'], "%Y-%m-%d %H:%M:%S")\r
+ dd2 = datetime.datetime.strptime(dl['etime'], "%Y-%m-%d %H:%M:%S")\r
+ if dd1 < btd:\r
+ dd1 = btd\r
+ if dd2 > etd:\r
+ dd2 = etd\r
+ times.append(dd1)\r
+ times.append(dd2)\r
+ times = list(set(times))\r
+ times.sort(cmpare)\r
+ times.reverse()\r
+ retcount = [0, 0]\r
+ for i in xrange(0, len(times)-2, 1):\r
+ bt1 = times[i]\r
+ et1 = times[i + 1]\r
+ btime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")\r
+ etime1 = et1.strftime("%Y-%m-%d %H:%M:%S")\r
+ ret1 = rec10d.rec10db.count_schedule_timeline(btime1, etime1)\r
+ if retcount[0] < ret1[0]:\r
+ retcount[0] = ret1[0]\r
+ if retcount[1] < ret1[1]:\r
+ retcount[1] = ret1[1]\r
+ return retcount\r
+\r
+def searchSchedule(btime,etime):\r
+ """\r
+ return rec num (int return[0]:TE /int return[1]:BS/CS)\r
+ """\r
+ def cmpare(x, y):\r
+ xt = x\r
+ yt = y\r
+ if xt > yt:\r
+ return -1\r
+ elif xt == yt:\r
+ return 0\r
+ else:\r
+ return 1\r
+ dls = rec10d.rec10db.select_bytime_all_timeline(btime, etime)\r
+ times = []\r
+ btd = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")\r
+ etd = datetime.datetime.strptime(etime, "%Y-%m-%d %H:%M:%S")\r
+ for dl in dls:\r
+ dd1 = datetime.datetime.strptime(dl['btime'], "%Y-%m-%d %H:%M:%S")\r
+ dd2 = datetime.datetime.strptime(dl['etime'], "%Y-%m-%d %H:%M:%S")\r
+ if dd1 < btd:\r
+ dd1 = btd\r
+ if dd2 > etd:\r
+ dd2 = etd\r
+ times.append(dd1)\r
+ times.append(dd2)\r
+ times = list(set(times))\r
+ times.sort(cmpare)\r
+ times.reverse()\r
+ ret=[]\r
+ for i in xrange(0, len(times)-2, 1):\r
+ bt1 = times[i]\r
+ et1 = times[i + 1]\r
+ btime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")\r
+ etime1 = et1.strftime("%Y-%m-%d %H:%M:%S")\r
+ ret1 = rec10d.rec10db.search_schedule_timeline(btime1, etime1)\r
+ ret.append(ret1)\r
+ ret = list(set(ret))\r
+ return ret\r
+\r
+def countEpgSchedule(epgbtime,epgetime):\r
+ """\r
+ return rec num (int return[0]:TE /int return[1]:BS/CS)\r
+ """\r
+ def cmpare(x, y):\r
+ xt = x\r
+ yt = y\r
+ if xt > yt:\r
+ return -1\r
+ elif xt == yt:\r
+ return 0\r
+ else:\r
+ return 1\r
+ dls = rec10d.rec10db.select_byepgtime_over_timeline(epgbtime, epgetime)\r
+ #print dls\r
+ times = []\r
+ btd = datetime.datetime.strptime(epgbtime, "%Y-%m-%d %H:%M:%S")\r
+ etd = datetime.datetime.strptime(epgetime, "%Y-%m-%d %H:%M:%S")\r
+ for dl in dls:\r
+ dd1 = datetime.datetime.strptime(dl['epgbtime'], "%Y-%m-%d %H:%M:%S")\r
+ dd2 = datetime.datetime.strptime(dl['epgetime'], "%Y-%m-%d %H:%M:%S")\r
+ if dd1 < btd:\r
+ dd1 = btd\r
+ if dd2 > etd:\r
+ dd2 = etd\r
+ times.append(dd1)\r
+ times.append(dd2)\r
+ times = list(set(times))\r
+ times.sort(cmpare)\r
+ times.reverse()\r
+ retcount = [0, 0]\r
+ for i in xrange(0, len(times)-1, 1):\r
+ bt1 = times[i]\r
+ et1 = times[i + 1]\r
+ epgbtime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")\r
+ epgetime1 = et1.strftime("%Y-%m-%d %H:%M:%S")\r
+ ret1 = rec10d.rec10db.count_epgschedule_timeline(epgbtime1, epgetime1)\r
+ if retcount[0] < ret1[0]:\r
+ retcount[0] = ret1[0]\r
+ if retcount[1] < ret1[1]:\r
+ retcount[1] = ret1[1]\r
+ return retcount\r
+def searchEpgSchedule(epgbtime,epgetime):\r
+ """\r
+ return rec num (int return[0]:TE /int return[1]:BS/CS)\r
+ """\r
+ def cmpare(x, y):\r
+ xt = x\r
+ yt = y\r
+ if xt > yt:\r
+ return -1\r
+ elif xt == yt:\r
+ return 0\r
+ else:\r
+ return 1\r
+ dls = rec10d.rec10db.select_byepgtime_all_timeline(epgbtime, epgetime)\r
+ times = []\r
+ btd = datetime.datetime.strptime(epgbtime, "%Y-%m-%d %H:%M:%S")\r
+ etd = datetime.datetime.strptime(epgetime, "%Y-%m-%d %H:%M:%S")\r
+ for dl in dls:\r
+ dd1 = datetime.datetime.strptime(dl['epgbtime'], "%Y-%m-%d %H:%M:%S")\r
+ dd2 = datetime.datetime.strptime(dl['epgetime'], "%Y-%m-%d %H:%M:%S")\r
+ if dd1 < btd:\r
+ dd1 = btd\r
+ if dd2 > etd:\r
+ dd2 = etd\r
+ times.append(dd1)\r
+ times.append(dd2)\r
+ times = list(set(times))\r
+ times.sort(cmpare)\r
+ times.reverse()\r
+ ret=[]\r
+ for i in xrange(0, len(times)-2, 1):\r
+ bt1 = times[i]\r
+ et1 = times[i + 1]\r
+ epgbtime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")\r
+ epgetime1 = et1.strftime("%Y-%m-%d %H:%M:%S")\r
+ ret1 = rec10d.rec10db.search_epgschedule_timeline(epgbtime1, epgetime1)\r
+ ret.append(ret1)\r
+ ret = list(set(ret))\r
+ return ret\r
OSDN Git Service
