diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-04-02 18:38:03 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-04-02 18:38:03 -0500 |
| commit | 8d66493c016853937c4595b4c380ec03c5aa1b3c (patch) | |
| tree | 81d11410f3f653d68e85bc2f6f9ab1355bff22ae /src/helpers.cr | |
| parent | a54f59ad742af9c8d86a7fe947a48857813609d7 (diff) | |
| download | invidious-8d66493c016853937c4595b4c380ec03c5aa1b3c.tar.gz invidious-8d66493c016853937c4595b4c380ec03c5aa1b3c.tar.bz2 invidious-8d66493c016853937c4595b4c380ec03c5aa1b3c.zip | |
Remove string interpolation from SQL queries
Diffstat (limited to 'src/helpers.cr')
| -rw-r--r-- | src/helpers.cr | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/src/helpers.cr b/src/helpers.cr index 47652163..b0c61d27 100644 --- a/src/helpers.cr +++ b/src/helpers.cr @@ -553,8 +553,6 @@ def fetch_channel(id, client, db) db.exec("UPDATE users SET notifications = notifications || $1 \ WHERE updated < $2 AND $3 = ANY(subscriptions) AND $1 <> ALL(notifications)", video_id, published, ucid) - # UPDATE users SET notifications = notifications || ARRAY['Os9Rypn2rEQ'] WHERE updated < '2018-03-24 20:48:46' AND 'UCSc16oMxxlcJSb9SXkjwMjA' = ANY(subscriptions) AND 'Os9Rypn2rEQ' <> ALL (notifications); - # TODO: Update record on conflict db.exec("INSERT INTO channel_videos VALUES (#{args})\ ON CONFLICT (id) DO NOTHING", video_array) |