3 # Rec10 TS Recording Tools
4 # Copyright (C) 2009-2010 Yukikaze
18 path = str(os.path.dirname(os.path.abspath(__file__))) + "/"
19 tmppath = configreader.getpath("tmp")+"/"
23 recdblist.printutf8(chtxt)
24 tnow = datetime.datetime.now()
26 lastup = datetime.datetime.strptime(chdb.chtxtsearch(chtxt)[0]['update'], "%Y-%m-%d %H:%M:%S")
28 lastup = datetime.datetime.strptime("2009-04-01 00:00:00", "%Y-%m-%d %H:%M:%S")
30 dt = dt.days * 24 * 60 + dt.seconds
32 ts2epg.write(os.path.join(tmppath, chtxt + "epgdata.xml"), chdb.chtxtsearch(chtxt)['ch'])
33 xml2db_dom.xml2db_dom(os.path.join(tmppath, chtxt + "epgdata.xml"), chdb.chtxtsearch(chtxt)['bctype'])
35 bctypel = chdb.bctypesearch(bctype)
38 ts2epg.write(tmppath + bctype + "epgdata.xml", chdb.bctypesearch(bctype)['ch'])
39 xml2db_dom.xml2db_dom(tmppath + bctype + "epgdata.xml", bctype)
40 shutil.copyfile(tmppath + bctype + "epgdata.xml", tmppath + bctype + "epgdata.bak.xml")
42 rec10d.rec10db.update_by_bctype_epg_ch(bctype)
43 except Exception, inst:
44 print "error occurs in updatebc(epgdb)"
47 xml2db_dom.xml2db_dom(tmppath + bctype + "epgdata.bak.xml", bctype)
48 rec10d.rec10db.update_status_by_bctype_epg_ch(bctype, "2")
49 def updatebc_bak(bctype):
51 update epg data by .bak file
53 xml2db_dom.xml2db_dom(tmppath + bctype + "epgdata.bak.xml", bctype)
54 def searchtime2(titletxt, timet, deltatime, chtxt):
55 time = datetime.datetime.strptime(timet, "%Y-%m-%d %H:%M:%S")
57 deltatime = int(deltatime)
58 beforetime = time.strftime("%Y%m%d%H%M%S")
59 aftertime = time + datetime.timedelta(hours=deltatime)
60 aftertime = aftertime.strftime("%Y%m%d%H%M%S")
61 one = ["", "", "", "","","",""]
63 d = rec10d.rec10db.select_by_time_ngram_epg_timeline(beforetime, aftertime, chtxt)
64 for chtxtt, title, start, stop ,exp,longexp,category in d:
65 #recdblist.printutf8(chtxtt+":"+title+":"+start+":"+stop)
66 p = n_gram.bigram(titletxt, title)
68 btime = btime[0:4] + "-" + btime[4:6] + "-" + btime[6:8] + " " + btime[8:10] + ":" + btime[10:12] + ":00"
70 etime = etime[0:4] + "-" + etime[4:6] + "-" + etime[6:8] + " " + etime[8:10] + ":" + etime[10:12] + ":00"
71 bt = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")
73 dt = 24 * 60 * 60 * dt.days + dt.seconds + 1
75 dt = 1000-1000 * dt / (7 * 24 * 60 * 60)
79 one = [chtxtt, title, btime, etime,exp,longexp,category]
82 recdblist.printutf8(title + ":" + str(p) + u"点")
86 def searchtime_auto(keytxt, timet, deltatime):
87 time = datetime.datetime.strptime(timet, "%Y-%m-%d %H:%M:%S")
89 deltatime = int(deltatime)
90 beforetime = time.strftime("%Y%m%d%H%M%S")
91 aftertime = time + datetime.timedelta(hours=deltatime)
92 aftertime = aftertime.strftime("%Y%m%d%H%M%S")
93 d = rec10d.rec10db.select_by_time_keyword_auto_suggest_epg_timeline(keytxt,beforetime, aftertime)
94 for chtxtt, title, start, stop ,exp,longexp,category in d:
96 btime = btime[0:4] + "-" + btime[4:6] + "-" + btime[6:8] + " " + btime[8:10] + ":" + btime[10:12] + ":00"
98 etime = etime[0:4] + "-" + etime[4:6] + "-" + etime[6:8] + " " + etime[8:10] + ":" + etime[10:12] + ":00"
99 ret.append([chtxtt, title, btime, etime,exp,longexp,category])
101 def count_schedule(btime,etime):
103 return rec num (int return[0]:TE /int return[1]:BS/CS)
114 dls = rec10d.rec10db.select_bytime_all_timeline(btime, etime)
116 btd = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")
117 etd = datetime.datetime.strptime(etime, "%Y-%m-%d %H:%M:%S")
119 dd1 = datetime.datetime.strptime(dl['btime'], "%Y-%m-%d %H:%M:%S")
120 dd2 = datetime.datetime.strptime(dl['etime'], "%Y-%m-%d %H:%M:%S")
127 times = list(set(times))
131 for i in xrange(0, len(times)-2, 1):
134 btime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")
135 etime1 = et1.strftime("%Y-%m-%d %H:%M:%S")
136 ret1 = rec10d.rec10db.count_schedule_timeline(btime1, etime1)
137 if retcount[0] < ret1[0]:
138 retcount[0] = ret1[0]
139 if retcount[1] < ret1[1]:
140 retcount[1] = ret1[1]
143 def search_schedule(btime,etime):
145 return rec num (int return[0]:TE /int return[1]:BS/CS)
156 dls = rec10d.rec10db.select_bytime_all_timeline(btime, etime)
158 btd = datetime.datetime.strptime(btime, "%Y-%m-%d %H:%M:%S")
159 etd = datetime.datetime.strptime(etime, "%Y-%m-%d %H:%M:%S")
161 dd1 = datetime.datetime.strptime(dl['btime'], "%Y-%m-%d %H:%M:%S")
162 dd2 = datetime.datetime.strptime(dl['etime'], "%Y-%m-%d %H:%M:%S")
169 times = list(set(times))
173 for i in xrange(0, len(times)-2, 1):
176 btime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")
177 etime1 = et1.strftime("%Y-%m-%d %H:%M:%S")
178 ret1 = rec10d.rec10db.search_schedule_timeline(btime1, etime1)
183 def count_epgschedule(epgbtime,epgetime):
185 return rec num (int return[0]:TE /int return[1]:BS/CS)
196 dls = rec10d.rec10db.select_byepgtime_all_timeline(epgbtime, epgetime)
198 btd = datetime.datetime.strptime(epgbtime, "%Y-%m-%d %H:%M:%S")
199 etd = datetime.datetime.strptime(epgetime, "%Y-%m-%d %H:%M:%S")
201 dd1 = datetime.datetime.strptime(dl['epgbtime'], "%Y-%m-%d %H:%M:%S")
202 dd2 = datetime.datetime.strptime(dl['epgetime'], "%Y-%m-%d %H:%M:%S")
209 times = list(set(times))
213 for i in xrange(0, len(times)-2, 1):
216 epgbtime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")
217 epgetime1 = et1.strftime("%Y-%m-%d %H:%M:%S")
218 ret1 = rec10d.rec10db.count_epgschedule_timeline(epgbtime1, epgetime1)
219 if retcount[0] < ret1[0]:
220 retcount[0] = ret1[0]
221 if retcount[1] < ret1[1]:
222 retcount[1] = ret1[1]
224 def search_epgschedule(epgbtime,epgetime):
226 return rec num (int return[0]:TE /int return[1]:BS/CS)
237 dls = rec10d.rec10db.select_byepgtime_all_timeline(epgbtime, epgetime)
239 btd = datetime.datetime.strptime(epgbtime, "%Y-%m-%d %H:%M:%S")
240 etd = datetime.datetime.strptime(epgetime, "%Y-%m-%d %H:%M:%S")
242 dd1 = datetime.datetime.strptime(dl['epgbtime'], "%Y-%m-%d %H:%M:%S")
243 dd2 = datetime.datetime.strptime(dl['epgetime'], "%Y-%m-%d %H:%M:%S")
250 times = list(set(times))
254 for i in xrange(0, len(times)-2, 1):
257 epgbtime1 = bt1.strftime("%Y-%m-%d %H:%M:%S")
258 epgetime1 = et1.strftime("%Y-%m-%d %H:%M:%S")
259 ret1 = rec10d.rec10db.search_epgschedule_timeline(epgbtime1, epgetime1)