add logo search.

[rec10/rec10-git.git] / rec10 / trunk / src / chdb.py

diff --git a/rec10/trunk/src/chdb.py b/rec10/trunk/src/chdb.py
index 487c4c9..bfea9a4 100644 (file)
--- a/rec10/trunk/src/chdb.py
+++ b/rec10/trunk/src/chdb.py
@@ -1,86 +1,92 @@
 #!/usr/bin/python
 # coding: UTF-8
 # Rec10 TS Recording Tools
-# Copyright (C) 2009 Yukikaze
- # モジュール属性 argv を取得するため
+# Copyright (C) 2009-2011 Yukikaze
+    # モジュール属性 argv を取得するため
 import rec10d
 
-def ontvsearch(ontvin):
-    ret=[]
-    for datum in rec10d.rec10db.select_by_ontv_chdata(ontvin):
-        rett={'bctype':datum[0],'ontv':datum[1],'chtxt':datum[2],'ch':datum[3],'csch':datum[4],'update':datum[5]}
+def searchCHFromChtxt(chtxtin):
+    chtxtt=chtxtin.replace("_0","_%")
+    ret = []
+    for datum in rec10d.rec10db.select_by_chtxt_epg_ch(chtxtt):
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
         ret.append(rett)
-    if len(ret)==0:
+    if len(ret) == 0:
         ret.append(None)
     return ret[0]
-def chtxtsearch(chtxtin):
-    ret=[]
-    for datum in rec10d.rec10db.select_by_chtxt_chdata(chtxtin):
-        rett={'bctype':datum[0],'ontv':datum[1],'chtxt':datum[2],'ch':datum[3],'csch':datum[4],'update':datum[5]}
+def searchCHFromBctype(bctypein):
+    ret = []
+    for datum in rec10d.rec10db.select_by_bctype_epg_ch(bctypein):
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
         ret.append(rett)
-    if len(ret)==0:
+    if len(ret) == 0:
         ret.append(None)
     return ret[0]
-def bctypesearch(bctypein):
-    ret=[]
-    for datum in rec10d.rec10db.select_by_bctype_chdata(bctypein):
-        rett={'bctype':datum[0],'ontv':datum[1],'chtxt':datum[2],'ch':datum[3],'csch':datum[4],'update':datum[5]}
+def searchCHFromCh(chin):
+    ret = []
+    for datum in rec10d.rec10db.select_by_ch_epg_ch(chin):
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
         ret.append(rett)
-    if len(ret)==0:
+    if len(ret) == 0:
         ret.append(None)
     return ret[0]
-def chsearch(chin):
-    ret=[]
-    for datum in rec10d.rec10db.select_by_ch_chdata(chin):
-        rett={'bctype':datum[0],'ontv':datum[1],'chtxt':datum[2],'ch':datum[3],'csch':datum[4],'update':datum[5]}
+def searchCHFromCsch(cschin):
+    ret = []
+    for datum in rec10d.rec10db.select_by_csch_epg_ch(cschin):
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
         ret.append(rett)
-    if len(ret)==0:
+    if len(ret) == 0:
         ret.append(None)
     return ret[0]
-def getall():
-    ret=[]
-    for datum in rec10d.rec10db.select_all_chdata():
-        rett={'bctype':datum[0],'ontv':datum[1],'chtxt':datum[2],'ch':datum[3],'csch':datum[4],'update':datum[5]}
+def searchAllCHFromCh(chin):
+    ret = []
+    for datum in rec10d.rec10db.select_by_ch_epg_ch(chin):
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
         ret.append(rett)
-    if len(ret)==0:
+    if len(ret) == 0:
         ret.append(None)
-    return ret[0]
+    return ret
+def getAllCH():
+    ret = []
+    for datum in rec10d.rec10db.select_all_epg_ch():
+        rett = {'bctype':datum[0], 'chtxt':datum[1], 'ch':datum[2], 'csch':datum[3], 'update':datum[4], 'chname':datum[5], 'visible':datum[7]}
+        ret.append(rett)
+    if len(ret) == 0:
+        ret.append(None)
+    return ret
 def update():
-    ret=[]
-    CSupdate=0
-    CS2update=0
-    BSupdate=0
-    for datum in rec10d.rec10db.select_get_update_chdata("6"):
-        bctype=datum[0]
-        chtxt=datum[1]
-        if bctype=="cs1" or bctype==u"cs1":
-            if CSupdate==0:
+    ret = []
+    CSupdate = 0
+    CS2update = 0
+    BSupdate = 0
+    rec10d.rec10db.set_new_status("8")
+    for datum in rec10d.rec10db.select_get_update_epg_ch("6"):
+        bctype = datum[0]
+        if bctype == "cs1" or bctype == u"cs1":
+            if CSupdate == 0:
                 ret.append(u"cs1")
-                CSupdate=1
-                print "csの番組表取得開始"
-                rec10d.rec10db.update_by_bctype_chdata(bctype)
-        elif bctype=="cs2" or bctype==u"cs2":
-            if CS2update==0:
+                CSupdate = 1
+        elif bctype == "cs2" or bctype == u"cs2":
+            if CS2update == 0:
                 ret.append(u"cs2")
-                CS2update=1
-                print "cs2の番組表取得開始"
-                rec10d.rec10db.update_by_bctype_chdata(bctype)
-        elif bctype=="bs" or bctype==u"bs":
-            if BSupdate==0:
+                CS2update = 1
+        elif bctype == "bs" or bctype == u"bs":
+            if BSupdate == 0:
                 ret.append(u"bs")
-                BSupdate=1
-                print "bsの番組表取得開始"
-                rec10d.rec10db.update_by_bctype_chdata(bctype)
+                BSupdate = 1
+        else:
+            ret.append(bctype)
+    return ret
+def changeCHShow(chtxt,isshow):
+    rec10d.rec10db.change_visible_epg_ch(chtxt, isshow)
+def updateLogo():
+    ret=[]
+    BSCSUpdate=0
+    for datum in rec10d.rec10db.select_get_updatelogo_epg_ch("720"):
+        bctype=datus[0]
+        if bctype == "cs1" or bctype == u"cs1":
+            ret.append(u"bs")
+            BSCSUpdate=1
         else:
             ret.append(bctype)
-            print "取得開始"
-            rec10d.rec10db.update_by_bctype_and_chtxt_chdata(bctype,chtxt)
     return ret
-#def viewall():
-#    db=sqlite3.connect(dbpath)
-#    for bctype, ontv, chtxt, ch, csch ,updatetime in db.execute("SELECT bctype,ontv,chtxt,ch,csch,updatetime FROM chdata"):
-#        print (bctype+","+ontv+","+chtxt+","+ch+","+csch+","+updatetime)
-#    db.close()
-#def updateall():
-
-#print ontvsearch("1062.ontvjapan.com")