From 34ffc73485e871868ec73ff9bde4339f4bc4c753 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 2 Dec 2021 17:54:48 -0800 Subject: issue-db: fixes to schema The primary key on release_counts was resulting in only one row per pubid. Also the 'year_in_sim' column was never being used. --- fatcat_scholar/issue_db.py | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) (limited to 'fatcat_scholar/issue_db.py') diff --git a/fatcat_scholar/issue_db.py b/fatcat_scholar/issue_db.py index 4d6fe04..d6bc3f9 100644 --- a/fatcat_scholar/issue_db.py +++ b/fatcat_scholar/issue_db.py @@ -99,7 +99,6 @@ class SimIssueRow: @dataclass class ReleaseCountsRow: sim_pubid: str - year_in_sim: bool release_count: int year: Optional[int] volume: Optional[str] @@ -109,7 +108,6 @@ class ReleaseCountsRow: self.sim_pubid, self.year, self.volume, - self.year_in_sim, self.release_count, ) @@ -190,7 +188,7 @@ class IssueDB: if not cur: cur = self.db.cursor() cur.execute( - "INSERT OR REPLACE INTO release_counts VALUES (?,?,?,?,?)", counts.tuple() + "INSERT OR REPLACE INTO release_counts VALUES (?,?,?,?)", counts.tuple() ) def pubid2container(self, sim_pubid: str) -> Optional[str]: @@ -368,7 +366,6 @@ class IssueDB: for agg in aggs: row = ReleaseCountsRow( sim_pubid=sim_pubid, - year_in_sim=False, # TODO release_count=agg["count"], year=agg["year"], volume=agg["volume"], -- cgit v1.2.3