rec10/branches/0.4/src/dbviewer.py

   1 #!/usr/bin/python
   2 # coding: UTF-8
   3 # Rec10 TS Recording Tools
   4 # Copyright (C) 2009 Yukikaze
   5 import recdb
   6 import sqlite3
   7 import os
   8 dbpath=str(os.path.dirname(os.path.abspath(__file__)))+"/"+"ch.db"
   9 tasks=recdb.getall()
  10 db=sqlite3.connect(dbpath)
  11
  12
  13 print "チャンネルデータ"
  14 for bctype, ontv, chtxt, ch, csch ,updatetime in db.execute("SELECT bctype,ontv,chtxt,ch,csch,updatetime FROM chdata"):
  15     print (bctype+","+ontv+","+chtxt+","+ch+","+csch+","+updatetime)
  16 db.close()
  17 print "録画予約"
  18 for task in tasks:
  19         #value=line.split(",")
  20         if task["type"]=="res":#"res,"+chtxt+","+title+","+btime+","+etime+","+opt
  21             chtxt=task['chtxt']
  22             title=task['title']
  23             btime=task['btime']
  24             etime=task['etime']
  25             opt=task['opt']
  26             print "録画予約"+","+chtxt+","+title+","+btime+","+etime+","+opt
  27         elif task["type"]=="key":#"key,"+chtxt+","+keyword+","+btime+","+deltatime+","+opt
  28             chtxt=task['chtxt']
  29             #title=task['title']
  30             btime=task['btime']
  31             #etime=task['etime']
  32             keyword=task['title']
  33             deltatime=task['deltatime']
  34             opt=task['opt']
  35             print "検索予約"+","+chtxt+","+keyword+","+btime+","+deltatime+","+opt
  36         elif task["type"]=="keyevery":#"keyevery,"+chtxt+","+keyword+","+btime+","+deltatime+","+opt+","+deltaday
  37             chtxt=task['chtxt']
  38             #title=task['title']
  39             btime=task['btime']
  40             #etime=task['etime']
  41             keyword=task['title']
  42             deltatime=task['deltatime']
  43             opt=task['opt']
  44             deltaday=task['deltaday']
  45             print "隔日予約"+","+chtxt+","+keyword+","+btime+","+deltatime+","+opt+","+deltaday
  46         elif task["type"]=="rec":#"rec,"+chtxt+","+title+","+btime+","+etime+","+opt
  47             chtxt=task['chtxt']
  48             title=task['title']
  49             print title
  50             btime=task['btime']
  51             etime=task['etime']
  52             #keyword=task['keyword']
  53             #deltatime==task['deltatime']
  54             opt=task['opt']
  55             print "予約最終"+","+chtxt+","+title+","+btime+","+etime+","+opt
  56