]>
git.gir.st - subscriptionfeed.git/blob - app/youtube/__init__.py
5 from urllib
.parse
import urlparse
6 #from flask_login import current_user, login_required
7 from flask_login
import LoginManager
, UserMixin
, current_user
, login_user
, logout_user
, login_required
8 from flask
import Blueprint
, render_template
, request
, redirect
, flash
, url_for
, jsonify
, g
9 from werkzeug
.exceptions
import NotFound
11 from ..common
.common
import *
14 frontend
= Blueprint('youtube', __name__
,
15 template_folder
='templates',
16 static_folder
='static',
17 static_url_path
='/static/yt')
21 return redirect(url_for('.feed'), code
=302)
23 @frontend.route('/feed/subscriptions')
24 # disabled for guest user: @login_required
26 if current_user
.is_anonymous
:
28 if 'welcome_message' in cf
['frontend']:
29 flash(cf
['frontend']['welcome_message'], "welcome")
31 token
= current_user
.token
32 page
= int(request
.args
.get('page', 0))
33 with sqlite3
.connect(cf
['global']['database']) as conn
:
36 SELECT videos.id, channel_id, name, title, length, livestream, published, playlist_videos.playlist_id, display
38 JOIN channels ON videos.channel_id = channels.id
39 LEFT JOIN playlist_videos ON (videos.id = playlist_videos.video_id)
40 LEFT JOIN flags ON (videos.id = flags.video_id) AND (flags.user = ?)
41 WHERE (channel_id IN (SELECT channel_id FROM subscriptions WHERE user=? AND type = 'channel')
42 OR playlist_videos.playlist_id IN (SELECT channel_id FROM subscriptions WHERE user=? AND type = 'playlist')
43 OR flags.display = 'pinned')
44 AND flags.display IS NOT 'hidden'
45 ORDER BY (display = 'pinned') DESC, crawled DESC
47 OFFSET 36*?""", (token
, token
, token
, page
))
50 'channel_id': channel_id
,
54 'livestream': livestream
,
55 'published': published
,
57 'pinned': display
== 'pinned',
58 } for (video_id
, channel_id
, author
, title
, length
, livestream
, published
, playlist
, display
) in c
.fetchall()]
59 return render_template('index.html.j2', rows
=rows
, page
=page
)
61 @frontend.route('/watch')
63 if current_user
.is_anonymous
:
66 token
= current_user
.token
68 if not 'v' in request
.args
:
69 return "missing video id", 400
72 'content-type': 'text/plain',
73 'Link': "<data:text/css,body%7Bcolor:%23eee;background:%23333%7D>; rel=stylesheet;"
76 video_id
= request
.args
.get('v')
77 sts
, algo
= get_cipher()
78 video_url
, stream_map
, metadata
, error
, errdetails
= get_video_info(video_id
, sts
, algo
)
80 extra
= {'geolocked':'local=1', 'livestream':'raw=0'}.get(error
,'')
81 invidious_url
= f
"https://invidious.snopyta.org/watch?v={video_id}&{extra}"
83 'banned': "Instance is being rate limited.",
84 'malformed': "Video ID is invalid.",
85 'geolocked': "This video is geolocked.",
86 'livestream': "Livestreams not yet supported.",
87 'exhausted': errdetails
or "Couldn't extract video URLs.",
91 # if the video is geolocked, and the proxy is enabled, we can still play it:
93 if error
== 'geolocked':
94 videoplayback
= url_for('proxy.videoplayback')
96 query
= urlparse(video_url
).query
97 video_url
= f
"{videoplayback}?{query}"
98 for s
in stream_map
['adaptive']:
99 query
= urlparse(s
['url']).query
100 s
['url'] = f
"{videoplayback}?{query}"
101 for s
in stream_map
['muxed']:
102 query
= urlparse(s
['url']).query
103 s
['url'] = f
"{videoplayback}?{query}"
108 show
= request
.args
.get("show")
111 msg
= errdetails
if error
=='player' else f
"{error.upper()}: {errdetails}"
112 return f
"{msg}\n\nRedirecting to Invidious.", 502, {
113 'Refresh': f
'2; URL={invidious_url}&raw=1',
115 return redirect(video_url
, code
=307)
117 if error
and not metadata
:
118 return {'error': True, error
: errdetails
}, 400 # TODO: better (test _CpR4o81XQc)
119 return jsonify(metadata
)
120 elif show
== "audio":
121 # sorting: we want to prioritize mp4a over opus, and sort by highest quality first
122 # todo: geolocking; prefer open format?
123 if error
and not metadata
:
124 msg
= errdetails
if error
=='player' else f
"{error.upper()}: {errdetails}"
125 return msg
, 400, plaintextheaders
# TODO: nicer
126 stream
= next(iter(sorted([
127 stream
for stream
in stream_map
['adaptive']
128 if stream
['mimeType'].startswith('audio/')],
129 key
=lambda stream
: ('opus' not in stream
['mimeType'],
130 stream
['bitrate']), reverse
=True)
132 return redirect(stream
)
134 if error
and not metadata
: # e.g. malformed, private/deleted video, ...
135 return errdetails
+ f
"<br>Try visiting <a href='{invidious_url}'>Invidious</a>.",400 # TODO: nicer
136 meta
= prepare_metadata(metadata
)
137 with sqlite3
.connect(cf
['global']['database']) as conn
:
141 SELECT 1 FROM subscriptions WHERE channel_id = ? AND user = ?
143 SELECT 1 FROM flags WHERE video_id = ? AND display = 'pinned' AND user = ?
144 ))""", (meta
['channel_id'], token
, video_id
, token
))
145 (is_subscribed
, is_pinned
) = c
.fetchone()
146 return render_template('watch.html.j2',
147 video_id
=video_id
, video_url
=video_url
, stream_map
=stream_map
,
148 video_error
=error
, errdetails
=errdetails
, invidious_url
=invidious_url
,
149 is_pinned
=is_pinned
, is_subscribed
=is_subscribed
,
152 @frontend.route('/embed/<video_id>')
154 return redirect(url_for('.watch', v
=video_id
, t
=request
.args
.get('start')))
156 @frontend.route('/<something>', strict_slashes
=False)
157 def plain_user_or_video(something
):
158 # yt.com interprets this as a username, but we also want to catch youtu.be
159 # short-urls. so we check if it's a channel by querying the RSS feed (this
160 # shoudn't be rate-limited); if that fails, check if it looks like a video
161 # id; or finally give up.
162 if '.' not in something
and channel_exists(something
):
163 # periods are not valid in usernames, vanity urls or ucids, but common
164 # in urls that get crawled by bots (e.g. index.php). failing early
165 # reduces the amount of invalid channel names getting looked up.
166 return redirect(url_for('.channel', channel_id
=something
))
167 elif re
.match(r
"^[-_0-9A-Za-z]{11}$", something
): # looks like a video id
168 return redirect(url_for('.watch', v
=something
, t
=request
.args
.get('t')))
170 # XXX: something == 'thethoughtemporium' -> 404s
171 raise NotFound("Note: some usernames not recognized; try searching it")
173 @frontend.route('/channel/<channel_id>/<subpage>')
174 @frontend.route('/user/<channel_id>/<subpage>')
175 @frontend.route('/c/<channel_id>/<subpage>')
176 @frontend.route('/channel/<channel_id>/')
177 @frontend.route('/user/<channel_id>/')
178 @frontend.route('/c/<channel_id>/')
179 def channel(channel_id
, _
=None):
180 token
= getattr(current_user
, 'token', 'guest')
182 if re
.match(r
"(UC[A-Za-z0-9_-]{22})", channel_id
):
183 xmlfeed
= fetch_xml("channel_id", channel_id
)
185 xmlfeed
= fetch_xml("user", channel_id
)
188 return "not found or something", 404 # XXX
189 title
, author
, videos
, channel_id
, _
= parse_xml(xmlfeed
)
191 with sqlite3
.connect(cf
['global']['database']) as conn
:
196 WHERE channel_id = ? AND user = ?
197 """, (channel_id
, token
))
198 (is_subscribed
,) = c
.fetchone()
200 return render_template('xmlfeed.html.j2', title
=author
, rows
=videos
,
201 is_subscribed
=is_subscribed
, channel_id
=channel_id
)
203 @frontend.route('/playlist')
205 playlist_id
= request
.args
.get('list')
207 return "bad list id", 400 # todo
209 xmlfeed
= fetch_xml("playlist_id", playlist_id
)
211 return "not found or something", 404 # XXX
212 title
, author
, videos
, _
, _
= parse_xml(xmlfeed
)
213 return render_template('xmlfeed.html.j2', title
=f
"{title} by {author}", rows
=videos
)
215 @frontend.route('/api/timedtext')
217 r
= requests
.get("https://www.youtube.com/api/timedtext", request
.args
.to_dict())
218 # Note: in srv1 format, xmlentities are double-encoded m( a smart quote is
219 # even worse: it's '&39;<smartquote>' wtf!? (at least vvt seems ok)
221 return "error: {r.text}", 400 # TODO: better
223 if request
.args
.get('fmt') == 'vtt' and request
.args
.get('kind') == 'asr':
224 # autocaptions are extremely confusing, and stuck in the lower-left corner. fix it up a bit
225 retval
= re
.sub(r
"<.+?>", "", retval
) # remove inline html-like markup that times each word/adds styles
226 retval
= retval
.replace("align:start position:0%", "") # let browser position the text itself
227 # each subtitle-line is repeated twice (first on the lower line, then
228 # on the next "frame" on the upper line). we want to remove the
229 # repetition, as that's confusing without word and line animations:
230 lines
= retval
.split('\n')
231 retval
= '\n'.join([line
for line
, prev
in zip(lines
, ['']+lines
) if not " --> " in prev
])
232 return retval
, {'Content-Type': r
.headers
.get("Content-Type")}
234 @frontend.route('/manage/subscriptions')
235 # disabled for guest user: @login_required
236 def subscription_manager():
237 if current_user
.is_anonymous
:
240 token
= current_user
.token
241 with sqlite3
.connect(cf
['global']['database']) as conn
:
242 #with conn.cursor() as c:
245 SELECT subscriptions.channel_id, name, type,
246 (subscribed_until < datetime('now')) AS obsolete
248 LEFT JOIN (SELECT name, id FROM channels
250 SELECT name, id FROM playlists
251 ) AS channels ON channels.id = subscriptions.channel_id
252 left JOIN websub ON channels.id = websub.channel_id
254 AND subscriptions.type IN ('channel', 'playlist')
255 ORDER BY obsolete=0, name COLLATE NOCASE ASC""", (token
,))
257 'channel_id': channel_id
,
258 'author': author
or channel_id
,
260 'subscribed_until': subscribed_until
261 } for (channel_id
, author
, type, subscribed_until
) in c
.fetchall()]
262 return render_template('subscription_manager.html.j2', rows
=rows
)
264 @frontend.route('/feed/subscriptions', methods
=['POST'])
267 token
= current_user
.token
268 action
= next(request
.form
.keys(), None)
269 if action
in ['pin', 'unpin', 'hide']:
270 video_id
= request
.form
.get(action
)
276 with sqlite3
.connect(cf
['global']['database']) as conn
:
278 store_video_metadata(video_id
) # only needed for pinning
280 INSERT OR REPLACE INTO flags (user, video_id, display)
282 """, (token
, video_id
, display
))
284 flash("unsupported action", "error")
285 return redirect(request
.url
, code
=303)
287 @frontend.route('/manage/subscriptions', methods
=['POST'])
289 def manage_subscriptions():
290 token
= current_user
.token
291 if 'subscribe' in request
.form
:
292 some_id
= request
.form
.get("subscribe")
293 match
= re
.search(r
"(UC[A-Za-z0-9_-]{22})", some_id
)
295 some_id
= match
.group(1)
298 match
= re
.search(r
"((?:PL|LL|EC|UU|FL|UL|OL)[A-Za-z0-9_-]{10,})", some_id
)
299 if match
: # NOTE: PL-playlists are 32chars, others differ in length.
300 some_id
= match
.group(1)
303 flash("not a valid/subscribable URI", "error")
304 return redirect(request
.url
, code
=303)
305 with sqlite3
.connect(cf
['global']['database']) as conn
:
306 #with conn.cursor() as c:
309 INSERT OR IGNORE INTO subscriptions (user, channel_id, type)
311 """, (token
, some_id
, id_type
))
312 # TODO: sql-error-handling, asynchronically calling update-subs.pl
314 elif 'unsubscribe' in request
.form
:
315 some_id
= request
.form
.get("unsubscribe")
316 with sqlite3
.connect(cf
['global']['database']) as conn
:
317 #with conn.cursor() as c:
320 DELETE FROM subscriptions
321 WHERE user = ? AND channel_id = ?
322 """, (token
, some_id
))
323 # TODO: sql-error-handling, report success
326 flash("unsupported action", "error")
328 return redirect(request
.url
, code
=303)
331 # reload cipher from database every 1 hour
332 if 'cipher' not in g
or time
.time() - g
.get('cipher_updated', 0) > 1 * 60 * 60:
333 with sqlite3
.connect(cf
['global']['database']) as conn
:
335 c
.execute("SELECT sts, algorithm FROM cipher")
336 g
.cipher
= c
.fetchone()
337 g
.cipher_updated
= time
.time()
341 #@frontend.teardown_appcontext
343 # db = g.pop('db', None)
349 @frontend.app_template_filter('format_date')
351 import datetime
# can't import at top level, because it is inherited from common
352 (y
,m
,d
) = (int(n
) for n
in s
.split('T')[0].split(' ')[0].split('-')) # iso-dates can seperate date from time with space or 'T'
353 M
= '_ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec'.split()
354 if y
== datetime
.datetime
.now().year
:
357 return f
"{M[m]} '{y%100}"
359 @frontend.app_template_filter('format_time')
366 return '%d:%02d:%02d' % (h
,m
,s
) if h
else '%02d:%02d' % (m
,s
)
368 @frontend.app_template_filter('timeoffset')
372 match
= re
.match(r
"^(\d+)s?$", s
) # e.g. 2040s
374 return match
.group(1)
375 match
= re
.match(r
"^(?:(\d+)h)?(?:(\d+)m)?(?:(\d+)s)?$", s
) # e.g. 34m, 1h23s
377 return ":".join([n
.zfill(2) for n
in match
.groups('0')])