diff options
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/phenotypes_bulk_edit.py | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/scripts/phenotypes_bulk_edit.py b/scripts/phenotypes_bulk_edit.py index 4888924..20fa66b 100644 --- a/scripts/phenotypes_bulk_edit.py +++ b/scripts/phenotypes_bulk_edit.py @@ -85,37 +85,6 @@ def descriptions_differences(file_data, db_data) -> dict[str, str]: return diff -def __save_new_publications__(conn, publications, pubmed_ids) -> dict: - if len(publications) > 0: - with conn.cursor(cursorclass=DictCursor) as cursor: - cursor.executemany( - ("INSERT INTO " - "Publication( " - "PubMed_ID, Abstract, Authors, Title, Journal, Volume, Pages, " - "Month, Year" - ") " - "VALUES(" - "%(pubmed_id)s, %(abstract)s, %(authors)s, %(title)s, " - "%(journal)s, %(volume)s, %(pages)s, %(month)s, %(year)s" - ") " - "ON DUPLICATE KEY UPDATE " - "Abstract=VALUES(Abstract), Authors=VALUES(Authors), " - "Title=VALUES(Title), Journal=VALUES(Journal), " - "Volume=VALUES(Volume), Pages=VALUES(pages), " - "Month=VALUES(Month), Year=VALUES(Year)"), - publications) - - paramstr = ", ".join(["%s"] * len(pubmed_ids)) - cursor.execute( - ("SELECT Id, PubMed_ID FROM Publication " - f"WHERE PubMed_ID IN ({paramstr})"), - pubmed_ids) - return { - row["PubMed_ID"]: row["Id"] for row in cursor.fetchall() - } - return {} - - def publications_differences(conn, file_data, db_data, pubmed_ids) -> dict: """Compute differences in the publications.""" logger.info("Computing differences in publications.") |