guardian / guardian/google-ad-database-processing-scripts

Missing col in sqlite table?

未关闭
#2 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Python
星标
15
派生
4
PR 合并指标
30 天内没有已合并 PR

描述

Looks like scraperwiki is looking for a "video_type" col - which doesn't automatically exist in the scraperwiki.sqlite file (at least not mine)

(manually adding that field allows script to run btw)

```
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: video_type
[SQL: select * from aus_ads where Ad_Type='Video' AND video_type IS NULL]

```

Cols I do automatically have:

Ad_ID
Ad_URL
Ad_Type
Regions
Advertiser_ID
Advertiser_Name
Ad_Campaigns_List
Date_Range_Start
Date_Range_End
Num_of_Days
Impressions
Spend_USD
First_Served_Timestamp
Last_Served_Timestamp
Age_Targeting
Gender_Targeting
Geo_Targeting_Included
Geo_Targeting_Excluded
Spend_Range_Min_USD
Spend_Range_Max_USD
Spend_Range_Min_AUD
Spend_Range_Max_AUD

贡献指南

这个仓库没有索引到贡献指南

调研方向

No source file or test is named. Start by locating the scraper code that runs the aus_ads query shown in the report and inspect how the scraperwiki.sqlite schema is created or updated. Reproduce the missing-column failure, then verify that processing the Video records works without manually adding video_type.

由索引模型根据 Issue 内容生成。

评估

技术栈
python, sqlite
领域
databases
Issue 类型
缺陷
难度
3/5
预计耗时
1-2 天
活跃度
停滞
描述清晰度
基本清楚
新手友好度
35/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。