From 40028e146227b3e656f7d10b8cb3c32e6fde2e83 Mon Sep 17 00:00:00 2001 From: Omar Roth Date: Tue, 4 Sep 2018 09:57:40 -0500 Subject: Update SQL and remove migration points --- src/invidious/videos.cr | 9 ++------- 1 file changed, 2 insertions(+), 7 deletions(-) (limited to 'src') diff --git a/src/invidious/videos.cr b/src/invidious/videos.cr index e0bcd64c..ca776d30 100644 --- a/src/invidious/videos.cr +++ b/src/invidious/videos.cr @@ -376,13 +376,11 @@ def get_video(id, db, refresh = true) video = fetch_video(id) video_array = video.to_a - # MIGRATION POINT - video_array = video_array[0..-2] - args = arg_array(video_array[1..-1], 2) db.exec("UPDATE videos SET (info,updated,title,views,likes,dislikes,wilson_score,\ - published,description,language,author,ucid, allowed_regions, is_family_friendly, genre)\ + published,description,language,author,ucid, allowed_regions, is_family_friendly,\ + genre, genre_url)\ = (#{args}) WHERE id = $1", video_array) rescue ex db.exec("DELETE FROM videos * WHERE id = $1", id) @@ -393,9 +391,6 @@ def get_video(id, db, refresh = true) video = fetch_video(id) video_array = video.to_a - # MIGRATION POINT - video_array = video_array[0..-2] - args = arg_array(video_array) db.exec("INSERT INTO videos VALUES (#{args}) ON CONFLICT (id) DO NOTHING", video_array) -- cgit v1.2.3