3 # Rec10 TS Recording Tools
4 # Copyright (C) 2009 Yukikaze
9 #db.execute('create table rectime
10 #(type TEXT,chtxt TEXT,title TEXT,btime TEXT,etime TEXT,deltatime TEXT,deltaday TEXT,opt TEXT,id INTEGER PRIMARY KEY,UNIQUE(type,chtxt,title,btime,deltaday))')
11 path=str(os.path.dirname(os.path.abspath(__file__)))+"/"
13 def __inif__(self,value):
15 db=sqlite3.connect(dbpath)
17 db.execute('create table rectime (type TEXT,chtxt TEXT,title TEXT,btime TEXT,etime TEXT,deltatime TEXT,deltaday TEXT,opt TEXT,id INTEGER PRIMARY KEY,UNIQUE(type,chtxt,title,btime,deltaday))')
20 def connect_db(tout=10):
26 return sqlite3.connect(dbpath,timeout=tout*1000)
29 def add_rectime(type="",chtxt="",title="",btime="",etime="",deltatime="",deltaday="",opt=""):
34 db.execute('insert into rectime values (?,?,?,datetime(?),datetime(?),?,?,?)',(type,chtxt,title,btime,etime,deltatime,deltaday,opt)
36 except sqlite3.OperationalError:
41 def del_rectime(type="",title="",chtxt="",btime=""):
46 db.execute("delete from rectime where type = ? AND title = ? AND chtxt = ? AND btime = datetime(?)",(type,title,chtxt,btime))
48 except sqlite3.OperationalError:
53 def select_all_rectime():
56 for typet, chtxt, title, btime, etime, deltatime ,deltaday ,opt in db.execute("SELECT type, chtxt, title, btime, etime, deltatime ,deltaday ,opt FROM rectime"):
60 ret['title']=title.encode('utf-8')
69 ret['deltatime']=deltatime
70 elif typet=='keyevery':
71 ret['deltatime']=deltatime
72 ret['deltaday']=deltaday
76 def select_bytime_rectime(dhour):
79 for typet, chtxt, title, btime, etime, deltatime ,deltaday ,opt in db.execute("SELECT type, chtxt, title, DATETIME(btime), DATETIME(etime), deltatime ,deltaday ,opt FROM rectime WHERE btime < datetime(\'now\',\'localtime\',\'+"+dhour+" hours\') AND btime >datetime(\'now\',\'localtime\',\'-"+dhour+" hours\')"):
83 ret['title']=title.encode('utf-8')
87 if deltatime==None or deltatime=="":
89 if deltaday==None or deltaday=="":
92 ret['deltatime']=deltatime
93 elif typet=='keyevery':
94 ret['deltatime']=deltatime
95 ret['deltaday']=deltaday
99 def delete_old_rectime(dhour):
101 db.execute("DELETE FROM rectime WHERE NOT ( type = ? OR type = ? ) AND btime < datetime(\'now\',\'localtime\',\'-"+dhour+" hours\')",(recdb.REC_MISS_ENCODE,recdb.REC_KEYWORD_EVERY_SOME_DAYS))
107 db.execute("delete from tv where bctype = ?",bctype)
111 db.execute('create table tv (bctype TEXT,channel TEXT NOT NULL,start TEXT,stop TEXT,title TEXT,desc TEXT)')
116 def add_tv(bctype,channel,start,stop,title,desc):
121 db.execute('insert into tv values (?,?,?,?,?,?)',(bctype,channel,start,stop,title,desc))
123 except sqlite3.OperationalError:
131 db.execute("delete from ch where bctype = ?",bctype)
135 db.execute('create table ch (bctype TEXT,channel TEXT NOT NULL,display TEXT)')
140 def add_ch(bctype,channel,display):
145 db.execute('insert into tv values (?,?,?)',(bctype,channel,display))
147 except sqlite3.OperationalError: