47 lines
1.2 KiB
Python
47 lines
1.2 KiB
Python
import traceback
|
|
import sqlite3
|
|
import totaldl
|
|
import praw
|
|
|
|
r = praw.Reddit('')
|
|
r.login('', '')
|
|
|
|
sql = sqlite3.connect('!!testdata.db')
|
|
cur = sql.cursor()
|
|
cur2 = sql.cursor()
|
|
|
|
cur.execute('CREATE TABLE IF NOT EXISTS totaldl_urls(url TEXT)')
|
|
cur.execute('CREATE INDEX IF NOT EXISTS urlindex ON totaldl_urls(url)')
|
|
sql.commit()
|
|
cur.execute('SELECT * FROM posts WHERE self=0 AND url IS NOT NULL')
|
|
while True:
|
|
item = cur.fetchone()
|
|
if item is None:
|
|
break
|
|
|
|
url = item[7]
|
|
if 'youtube.com' in url and '?v=' not in url:
|
|
continue
|
|
cur2.execute('SELECT * FROM totaldl_urls WHERE url=?', [url])
|
|
if cur2.fetchone():
|
|
continue
|
|
title = item[6]
|
|
for character in '\\/?:*"><|.':
|
|
title = title.replace(character, '')
|
|
if len(title) > 35:
|
|
title = title[:34] + '-'
|
|
try:
|
|
filepath = totaldl.handle_master(url, customname=title)
|
|
if filepath is None:
|
|
continue
|
|
filepath = filepath.replace('\\', '/')
|
|
filepath = filepath.split('/')[-1]
|
|
if '.mp4' in filepath:
|
|
filepath = 'http://syriancivilwar.pw/Videos/' + filepath
|
|
submission = r.get_info(thing_id=item[1])
|
|
submission.add_comment('[Mirror](%s)' % filepath)
|
|
print(filepath)
|
|
except:
|
|
traceback.print_exc()
|
|
cur2.execute('INSERT INTO totaldl_urls VALUES(?)', [url])
|
|
sql.commit() |