def findSSAN(patronID):
# function to get a users SSAN (bannerID) based on patronID
# returns String NONE if value is None (alumni users, etc)
# added to allow for banner id to go in summary, as per TKT-193
ssan = "NONE";
# make connection to the database
dsn = cx_Oracle.makedsn(db_host,db_port,db_SID)
con = cx_Oracle.connect(user=db_user,password=db_password,dsn=dsn)
cur = con.cursor()
# run the query
query = """
SELECT
pt.ssan
FROM
patron pt
WHERE
pt.patron_id IN ({pID})
"""
cur.execute(query.format(pID=patronID));
try:
ssan = cur.fetchone()[0]
except:
ssan = "NONE"
if ssan == None:
ssan = "NONE"
else:
ssan = "@" + ssan[1:]
return ssan;
评论列表
文章目录