dbexe = db[1].execute("\
SELECT keyword,auto,opt \
FROM in_auto_jbk_key \
- ")
+vim ")
ret = []
if dbexe > 0:
ret = db[1].fetchall()
UPDATE timeline INNER JOIN epg_ch ON timeline.chtxt=epg_ch.chtxt SET timeline.chtxt=CONCAT('BS_',epg_ch.ch) WHERE substring(epg_ch.bctype,1,2) = 'bs'")
db[1].execute("\
UPDATE timeline INNER JOIN epg_ch ON timeline.chtxt=epg_ch.chtxt SET timeline.chtxt=CONCAT('CS_',epg_ch.csch) WHERE substring(epg_ch.bctype,1,2) = 'cs'")
+ try:
+ db[1].execute("\
+ ALTER TABLE epg_ch DROP ontv")
+ except:
+ ""
db[1].execute("\
- ALTER TABLE epg_ch DROP ontv")
- db[1].execute("\
- ALTER TABLE epg_ch ADD logo0 BLOG,\
- ADD logo1 BLOG,\
- ADD logo2 BLOG,\
- ADD logo3 BLOG,\
- ADD logo4 BLOG,\
- ADD logo5 BLOG,\
+ ALTER TABLE epg_ch ADD logo0 BLOB,\
+ ADD logo1 BLOB,\
+ ADD logo2 BLOB,\
+ ADD logo3 BLOB,\
+ ADD logo4 BLOB,\
+ ADD logo5 BLOB\
")
db[1].execute("\
ALTER TABLE in_auto_jbk_key ADD auto TINYINT DEFAULT 0")
-import tv2ts
#!/usr/bin/python
# coding: UTF-8
# Rec10 TS Recording Tools
# Copyright (C) 2009-2011 Yukikaze
#import sys
import epgdb
+import tv2ts
import os
import time
import tv2avi
ftpusr = "/home/ftpusr/ftp-tmp"
recordedpath = u"/home/ftpusr/ftp-video"
if __name__ == "__main__":
- ""
\ No newline at end of file
+ rec10d.rec10db.update_db_98to100()
\ No newline at end of file