From 19ff79ad544e774a3959058f3c382cb2d823bb88 Mon Sep 17 00:00:00 2001 From: girst Date: Sat, 19 Sep 2020 15:25:55 +0200 Subject: [PATCH] store length when pinning videos --- app/common/common.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/app/common/common.py b/app/common/common.py index 371ef66..02f50a7 100644 --- a/app/common/common.py +++ b/app/common/common.py @@ -309,12 +309,13 @@ def store_video_metadata(video_id): if meta: meta = video_metadata(meta) c.execute(""" - INSERT OR IGNORE INTO videos (id, channel_id, title, published, crawled) - VALUES (?, ?, ?, datetime(?), datetime(?)) + INSERT OR IGNORE INTO videos (id, channel_id, title, length, published, crawled) + VALUES (?, ?, ?, ?, datetime(?), datetime(?)) """, ( video_id, meta['channel_id'], meta['title'], + meta['length'], meta['published'], meta['published'], )) -- 2.39.3