def get_post(post_id):
conn = get_db_connection()
post = conn.execute('SELECT * FROM posts WHERE id = ?',
(post_id, )).fetchone()
conn.close()
if post is None:
abort(404)
return post
def create(id_, name, thumbnail, published_at):
db = get_db_connection()
db.execute(
"INSERT INTO playlists (id, name, thumbnail,published_at) "
"VALUES (?, ?, ?, ?)",
(id_, name, thumbnail, published_at),
)
db.commit()
def create(id_, name, email, profile_pic):
db = get_db_connection()
db.execute(
"INSERT INTO user (id, name, email, profile_pic) "
"VALUES (?, ?, ?, ?)",
(id_, name, email, profile_pic),
)
db.commit()
def index():
if current_user.is_authenticated:
conn = get_db_connection()
playlists = conn.execute('SELECT * FROM playlists').fetchall()
conn.close()
return render_template('index.html',
playlists=playlists,
name=current_user.name,
profile_pic=current_user.profile_pic)
else:
return render_template("new_login.html")
def get(playlist_id):
db = get_db_connection()
playlist = db.execute("SELECT * FROM playlists WHERE id = ?",
(playlist_id, )).fetchone()
if not playlist:
return None
playlist = Playlist(id_=playlist[0],
name=playlist[1],
thumbnail=playlist[2],
published_at=playlist[3])
return playlist
def get(user_id):
db = get_db_connection()
user = db.execute("SELECT * FROM user WHERE id = ?",
(user_id, )).fetchone()
if not user:
return None
user = User(id_=user[0],
name=user[1],
email=user[2],
profile_pic=user[3])
return user
def playlist(playlist_id):
# Get playlist details
yt_uri, yt_headers, yt_body = client.add_token(
"https://www.googleapis.com/youtube/v3/playlistItems?part=contentDetails,snippet,status,id&playlistId="
+ playlist_id + "&maxResults=50")
playlist_details_response = requests.get(yt_uri,
headers=yt_headers,
data=yt_body)
# Get playlist name from local DB
conn = get_db_connection()
playlist_name = conn.execute('SELECT name FROM playlists WHERE id = "' +
playlist_id + '"').fetchone()['name']
conn.close()
print(playlist_name)
return render_template('playlist.html',
playlist_id=playlist_id,
playlist_name=playlist_name,
name=current_user.name,
profile_pic=current_user.profile_pic,
videos=playlist_details_response.json()["items"])