def main():
sql = '''SELECT show_title, chosen_hash FROM tracking WHERE complete is NULL'''
db = DB()
unfinished = db.run_sql(sql)
debug_command = '''export TR_TORRENT_NAME='%s'; export TR_TORRENT_DIR='%s'; export TR_TORRENT_HASH='%s'; python ~/projects/media-downloader/src/transmission_done.py'''
for show in unfinished:
print
print show[0]
print '-' * len(show[0])
command = debug_command % ('', '/home/sm/Shows', show[1])
print command
def __init__(self, criteria=1):
self.db = DB()
if criteria is None:
criteria = 1
if isinstance(criteria, int):
sqldata = self.db.get_downloaded_days(criteria)
elif isinstance(criteria, datetime.datetime):
sqldata = self.db.get_downloaded_date(criteria)
elif isinstance(criteria, str):
sqldata = self.db.get_downloaded_title(criteria)
self.sqldata = sqldata
class History:
def __init__(self, criteria=1):
self.db = DB()
if criteria is None:
criteria = 1
if isinstance(criteria, int):
sqldata = self.db.get_downloaded_days(criteria)
elif isinstance(criteria, datetime.datetime):
sqldata = self.db.get_downloaded_date(criteria)
elif isinstance(criteria, str):
sqldata = self.db.get_downloaded_title(criteria)
self.sqldata = sqldata
def episode(self, name, season, episode):
seep = ''
if season and episode:
seep = ' S{0:0>2}E{1:0>2}'.format(season, episode)
full = name + seep
return full
def exists(self, filename):
ok = 76
missing = 160
if filename is None:
return ''
elif os.path.exists(filename):
filename = filename
else:
filename = U.effects(['blackf', 'strikeon'], filename)
return filename
def format_date(self, date):
parsed = parser.parse(date)
new = parsed.strftime('%a %b/%d')
return new
def show(self):
for row in self.sqldata:
date = self.format_date(row[0])
name = U.snip(self.episode(row[1], row[4], row[5]), 25)
name = name.ljust(25)
filename = self.exists(row[2])
print '%s %s %s' % (date, name, filename)
def copy(self):
title = 'Copy files to %s' % Config.tv_dir
selected = self.display_list(title)
torrent_hash = selected[3]
torrent_dir, torrent_name = os.path.split(selected[2])
DownloadManager(torrent_hash, torrent_dir, torrent_name, debug=True)
def download(self):
title = 'Re-download'
selected = self.display_list(title, download=True)
torrent_hash = selected[3]
url = selected[-1]
search = Search(Config.providers[0])
downloaded_filename = search.download(chosen_show=url, destination=Config.staging)
def display_list(self, title, download=False):
sqldata = self.sqldata
data = [
[
'title',
['Date downloaded', 'Show name, episode', 'Local file'],
[16, 25, 0],
['<', '<', '<']
]
]
records = []
if download:
for i in sqldata:
records.append([
self.format_date(i[0]),
self.episode(i[1], i[4], i[5]),
i[6],
i[6]]
)
else:
for i in sqldata:
records.append([
self.format_date(i[0]),
self.episode(i[1], i[4], i[5]),
self.exists(i[2]),
i[3]]
)
data.append(records)
tbl = ConsoleTable(data)
tbl.set_title(title)
tbl.set_count(None)
tbl.is_postdownload = True
torrent_hash = tbl.generate()
selected = [i for i in data[1] if torrent_hash in i][0]
return selected
'''
