def add_sites():
PATH = str(Path(__file__).parent)
sites = Knead(PATH + "/data/zomergasten/guest-sites.csv").data()
for site in sites:
qid = site["qid"]
url = site["url"]
name = site["guest"]
print()
print(f"Now handling {qid} / {name}")
item = WikidataItem(qid)
claims = item.get_claims()
if Props.OFFICIAL_WEBSITE in claims:
print("Already got a site, skip")
continue
item.add_url_claim(
Props.OFFICIAL_WEBSITE,
url,
qualifiers=[item.get_item_claim(Props.LANGUAGE_WORK, Items.DUTCH)],
references=[
item.get_claim(Props.RETRIEVED, wbtime_now()),
item.get_url_claim(
Props.REF_URL,
"https://www.vpro.nl/programmas/zomergasten/a-z.html"),
item.get_item_claim(Props.LANGUAGE_WORK, Items.DUTCH)
])
def add_party_data(row):
print("----" * 20)
print()
print(row)
title = row["title"]
qid = row["qid"]
if skiplist.has(qid):
print(f"In skiplist, skipping")
return
item = WikidataItem(qid)
if Props.NR_OF_SEATS in item.get_claims():
print("Got seats already, skipping party")
return
for key, val in row.items():
if not key.isdigit():
continue
year = int(key)
if val == "":
continue
seats = int(val)
print(f"{title} ({qid}) had {seats} seats in {year}")
item.add_quantity_claim(
Props.NR_OF_SEATS,
seats,
qualifiers=[
item.get_item_claim(Props.LEGISLATIVE_BODY,
Items.NL_LOWER_HOUSE),
item.get_claim(Props.START_TIME, WbTime(year=year))
],
references=[
item.get_item_claim(Props.IMPORTED_FROM, Items.WIKIPEDIA_NL),
item.get_url_claim(Props.WM_IMPORT_URL, WP_PERMALINK)
])
skiplist.add(qid)
def add_item(data, qid=None):
name = data["name"]
location = data["location"]
desc = {
"label_en": f"Stolperstein dedicated to {name}",
"label_nl": f"Stolperstein ter herinnering aan {name}",
"description_en": f"stumbling stone in {location}, the Netherlands",
"description_nl": f"struikelsteen in {location}",
"aliases_nl": [
f"struikelsteen ter herinnering aan {name}",
]
}
print(desc)
if qid:
print("HAS QID")
item = WikidataItem(qid)
else:
item = WikidataItem(
summary=f"Creating new item for a Stolperstein for {name}",
labels={
"en": desc["label_en"],
"nl": desc["label_nl"]
},
descriptions={
"en": desc["description_en"],
"nl": desc["description_nl"]
},
aliases={"nl": desc["aliases_nl"]})
# These are the same for all stolpersteine
# item.add_item_claim(Props.INSTANCE_OF, Items.STOLPERSTEIN)
# item.add_item_claim(Props.PART_OF, Items. STOLPERSTEINE_PROJECT)
# item.add_item_claim(Props.COUNTRY, Items.NETHERLANDS)
# item.add_item_claim(Props.CREATOR, Items.GUNTER_DEMNIG)
# item.add_item_claim(Props.MATERIAL_USED, Items.BRASS)
# # These are not
# item.add_commonsmedia(Props.IMAGE, data["image"])
# item.add_item_claim(Props.LOCATED_IN, data["location_qid"])
# item.add_coordinate(Props.COORDINATES, [data["lat"], data["lon"]])
# item.add_monoling_claim(Props.INSCRIPTION, data["inscription"], "nl")
# I hate this f*****g hack
def get_ref():
# Check if we have an url, that's a reference
if data["url"]:
return [
item.get_claim(Props.RETRIEVED, wbtime_now()),
item.get_url_claim(Props.REF_URL, data["url"]),
item.get_item_claim(Props.LANGUAGE_WORK, Items.DUTCH)
]
else:
return None
# Inception and opening
date = partial_date_to_wbtime(data["inception"])
item.add_time_claim(Props.INCEPTION, date, references=get_ref())
item.add_item_claim(Props.SIG_EVENT,
Items.OPENING_CEREMONY,
qualifiers=[item.get_claim(Props.POINT_IN_TIME, date)],
references=get_ref())
# Street as item
item.add_item_claim(Props.LOCATED_ON_STREET,
data["street_qid"],
qualifiers=[
item.get_string_claim(Props.STREET_NUMBER,
data["street_nr"])
])
# Street as address
address = data["street"] + " " + data["street_nr"] + ", " + data["location"]
item.add_monoling_claim(Props.STREET_ADDRESS, address, "nl")
item.add_item_claim(
Props.COMMEMORATES,
"somevalue",
qualifiers=[item.get_monoling_claim(Props.NAME, name, "nl")])