我得到一个获取错误绑定参数3 -可能不支持的类型,如何将此表修复为sqlite的正确格式?

tkclm6bt  于 2023-06-23  发布在  SQLite
关注(0)|答案(1)|浏览(115)

表中的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的正确格式?

agxfikkp

agxfikkp1#

下面的东西应该把它整理出来:

cursor.execute(insert_query, (
                                str(snippet['publishedAt']),
                                str(snippet['title']),
                                str(snippet['channelId']),
                                str(snippet['thumbnails']),
                                str(snippet['channelTitle']),
                                statistics.get('viewCount', 0),
                                statistics.get('likeCount', 0),
                                statistics.get('dislikeCount', 0),
                                statistics.get('favoriteCount', 0),
                                content_details['duration'],
                                video_id,
                                transcript,
                            ))
                            ))

相关问题