123456789101112131415161718192021222324252627282930313233 |
- # 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()
|