dbpath=str(os.path.dirname(os.path.abspath(__file__)))+"/"+"ch.db"
db=sqlite3.connect(dbpath)
+"""
+task names
+"""
global REC_RESERVE
-REC_RESERVE="res"
global REC_FINAL_RESERVE
-REC_FINAL_RESERVE="rec"
global REC_END
-REC_END="end"
global REC_ENCODE_GRID
-REC_ENCODE_GRID="grid"
global REC_ENCODE_LOCAL
-REC_ENCODE_LOCAL="local"
global REC_ENCODE_QUE
-REC_ENCODE_QUE="ts2avi"
global REC_MIXING_SOUND
-REC_MIXING_SOUND="mixsound"
global REC_MISS_ENCODE
-REC_MISS_ENCODE="miss"
global REC_KEYWORD
-REC_KEYWORD="key"
global REC_KEYWORD_EVERY_SOME_DAYS
-REC_KEYWORD_EVERY_SOME_DAYS="keyevery"
global REC_FIN_DECODE
-REC_FIN_DECODE="tsfin"
+global REC_FIN_LOCAL
global REC_MISS_DECODE
-REC_MISS_DECODE="tsmiss"
global REC_TS_DECODING
+REC_RESERVE="res"
+REC_FINAL_RESERVE="rec"
+REC_END="end"
+REC_ENCODE_GRID="grid"
+REC_ENCODE_LOCAL="local"
+REC_ENCODE_QUE="ts2avi"
+REC_MIXING_SOUND="mixsound"
+REC_MISS_ENCODE="miss"
+REC_KEYWORD="key"
+REC_KEYWORD_EVERY_SOME_DAYS="keyevery"
+REC_FIN_DECODE="tsfin"
+REC_FIN_LOCAL="fin_local"
+REC_MISS_DECODE="tsmiss"
REC_TS_DECODING="tsdecoding"
try:
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))')