autocirc.py 文件源码

python
阅读 20 收藏 0 点赞 0 评论 0

项目:autocirc 作者: cherveny 项目源码 文件源码
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;
评论列表
文章目录


问题


面经


文章

微信
公众号

扫码关注公众号