diff options
| author | Samantaz Fox <coding@samantaz.fr> | 2021-11-30 02:24:24 +0100 |
|---|---|---|
| committer | Samantaz Fox <coding@samantaz.fr> | 2022-01-04 17:13:51 +0100 |
| commit | 3deafe9f8da2805ab19900fbdfb4e90d0a2cea03 (patch) | |
| tree | b9a9b815970e3427a7558f58abe3b72bf62a3e13 /src/invidious.cr | |
| parent | 998edba6f064eb4e09ca286ad33bfd967ef03e66 (diff) | |
| download | invidious-3deafe9f8da2805ab19900fbdfb4e90d0a2cea03.tar.gz invidious-3deafe9f8da2805ab19900fbdfb4e90d0a2cea03.tar.bz2 invidious-3deafe9f8da2805ab19900fbdfb4e90d0a2cea03.zip | |
Move DB queries related to playlists in a separate module (1/3)
Diffstat (limited to 'src/invidious.cr')
| -rw-r--r-- | src/invidious.cr | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/src/invidious.cr b/src/invidious.cr index 405fcadf..28d8ddac 100644 --- a/src/invidious.cr +++ b/src/invidious.cr @@ -816,11 +816,8 @@ post "/data_control" do |env| index: Random::Secure.rand(0_i64..Int64::MAX), }) - video_array = playlist_video.to_a - args = arg_array(video_array) - - PG_DB.exec("INSERT INTO playlist_videos VALUES (#{args})", args: video_array) - PG_DB.exec("UPDATE playlists SET index = array_append(index, $1), video_count = cardinality(index) + 1, updated = $2 WHERE id = $3", playlist_video.index, Time.utc, playlist.id) + Invidious::Database::PlaylistVideos.insert(playlist_video) + Invidious::Database::Playlists.update_video_added(playlist.id, playlist_video.index) end end end |