scopus/rm-scopusid.py

# Remove scopus ID from publication database
#

import sys

# Mysql persistent data (Accout: scopus, $scopus$)
import pymysql.cursors
import pymysql

from config import *


if len(sys.argv) > 1:

    scopusid = sys.argv[1]

    # Connect to the database
    connection = pymysql.connect(host=db_host,user=db_user,password=db_pw,db=db_name,charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)

    try:
        with connection.cursor() as cursor:

            sql = "DELETE FROM publications WHERE scopusid=\"%s\" " % scopusid
            print sql;
            cursor.execute(sql)
            connection.commit()

    finally:
        connection.close()