import recdb
import os
import MySQLdb
+import dbSQLite
class DB_MySQL():
dbname=""
self.close_db(db)
def add_rectime(self,type="", chtxt="", title="", btime="", etime="", deltatime="", deltaday="", opt=""):
db = self.connect_db()
- db[1].execute('insert into rectime (type,chtxt,title,btime,etime,deltatime,deltaday,opt) values (%s,%s,%s,%s,%s,%s,%s,%s)', (type, chtxt, title, btime, etime, deltatime, deltaday, opt))
+ db[1].execute('INSERT IGNORE into rectime (type,chtxt,title,btime,etime,deltatime,deltaday,opt) values (%s,%s,%s,%s,%s,%s,%s,%s)', (type, chtxt, title, btime, etime, deltatime, deltaday, opt))
##db.commit()
self.close_db(db)
def del_rectime(self,type="", title="", chtxt="", btime=""):
ret['btime']=btime
ret['etime']=etime
ret['opt']=opt
+ ret['deltatime']=""
+ ret['deltaday']=""
if deltatime == None:
deltatime="3"
if deltaday == None:
except:
""
try:
- db[1].execute("create table tv (bctype VARCHAR(20),channel VARCHAR(20) NOT NULL,start VARCHAR(20),stop VARCHAR(20),title VARCHAR(100),exp VARCHAR(200),UNIQUE unitv(bctype,channel,start,stop,title))")
+ db[1].execute("create table tv (bctype VARCHAR(20),channel VARCHAR(100) NOT NULL,start VARCHAR(30),stop VARCHAR(30),title VARCHAR(100),exp VARCHAR(200),UNIQUE unitv(bctype,channel,start,stop,title))")
except:
""
#db.commit()
db=self.connect_db()
db[1].executemany('INSERT IGNORE INTO ch VALUES (%s,%s,%s)', chlists)
self.close_db(db)
+ def import_from_SQLite(self,dbpath):
+ dbb=dbSQLite.DB_SQLite(dbpath)
+ dbl=dbb.select_all_rectime()
+ for db in dbl:
+ self.add_rectime(db['type'],db['chtxt'],db['title'],db['btime'],db['etime'],db['deltatime'],db['deltaday'],db['opt'])
+
\ No newline at end of file
btxt=bt.strftime("%Y-%m-%d %H:%M:%S")
etxt=et.strftime("%Y-%m-%d %H:%M:%S")
recdb.everyreserv(title,chtxt,btxt,etxt,deltatime,opt,deltaday)
- elif dt<30*60*60:
+ elif dt<120*60:
recdb.keyreserv(title,chtxt,btime,etime,deltatime,opt)
recdb.del_reckey(recdb.REC_KEYWORD_EVERY_SOME_DAYS, title, chtxt, btime)
bt=bt+dd