dbutil.py 文件源码

def lookup_course_review(db, review_id):
    # perform SQL query
    cur = db.cursor()
    qry = 'SELECT * FROM CourseReview WHERE Id = %s'
    cur.execute(qry, [review_id])

    # process results
    row = cur.fetchone()
    if row is None:
        log('W', 'record', 'CourseReview %d not found. Skipping.' % review_id)
        return None
    res = {}
    for idx, elem in enumerate(row):
        # encode strings (unicode strings due to utf-8)
        # if type(elem) == type(u''):
        #     elem = elem.replace('"', '\\"').replace('\n', '\\n')
        #     elem = elem.encode(encoding='utf-8')
        if TABLE_STRUCT['CourseReview'][idx] in MARKDOWN_FIELDS:
            elem = markdown(elem)
        res[TABLE_STRUCT['CourseReview'][idx]] = elem

    return res