Fix where clause for scraping new wikis

cicalese · cicalese · commit 3e1fb041873f · 2024-01-17T21:26:50.000Z
diff --git a/scripts/lib/scraper.py b/scripts/lib/scraper.py
@@ -54,7 +54,7 @@ def last_versions_match(session, last_sr_id, skin_versions, extension_versions):
 		return False, None
 
 	stmt = select(Extension).where(Extension.w8y_ex_vr_id == vr_id)
-	extensions = session.scalars(stmt)
+	last_extensions = session.scalars(stmt)
 	count = 0
 	for extension in last_extensions:
 		name = extension.w8y_ex_name
diff --git a/scripts/scrape.py b/scripts/scrape.py
@@ -21,7 +21,7 @@ def get_wikis(session, new_wikis):
 	if new_wikis:
 		stmt = select(Wiki).where(
 			and_(
-				Wiki.w8y_wi_last_sr_id.is_not(None),
+				Wiki.w8y_wi_last_sr_id.is_(None),
 				Wiki.w8y_wi_is_defunct == False
 			)
 		)

Original file line number	Diff line number	Diff line change
`@@ -21,7 +21,7 @@ def get_wikis(session, new_wikis):`
`21`	`21`	`if new_wikis:`
`22`	`22`	`stmt = select(Wiki).where(`
`23`	`23`	`and_(`
`24`		`- Wiki.w8y_wi_last_sr_id.is_not(None),`
	`24`	`+ Wiki.w8y_wi_last_sr_id.is_(None),`
`25`	`25`	`Wiki.w8y_wi_is_defunct == False`
`26`	`26`	`)`
`27`	`27`	`)`