表中的sqlite。我想是tumbnails。有人能让我知道什么是使用jpg链接
CREATE TABLE youtube_video (
id INTEGER PRIMARY KEY AUTOINCREMENT,
published_at TEXT,
title TEXT,
channel_id TEXT,
thumbnails TEXT,
channel_title TEXT,
view_count INTEGER,
like_count INTEGER,
dislike_count INTEGER,
favorite_count INTEGER,
duration TEXT,
video_id TEXT,
transcript TEXT
);
在pycharm中添加数据到sqlite表的代码。cursor.execute(insert_query,(
cursor.execute(insert_query, (
snippet['publishedAt'],
snippet['title'],
snippet['channelId'],
snippet['thumbnails'],
snippet['channelTitle'],
statistics.get('viewCount', 0),
statistics.get('likeCount', 0),
statistics.get('dislikeCount', 0),
statistics.get('favoriteCount', 0),
content_details['duration'],
video_id,
transcript,
))
))
我得到一个获取错误绑定参数3 -可能不支持的类型。如何将此表修复为sqlite的正确格式?
1条答案
按热度按时间agxfikkp1#
下面的东西应该把它整理出来: