db_cancel.py 文件源码

def add_cancel(subject, teacher, day, week, period, abstract, first, unique_hash):
    session = models.Session()
    qkou = session.query(models.Cancel)
    # utf-8?????????????
    subject = subject.encode('utf-8')
    teacher = teacher.encode('utf-8')
    day = day.encode('utf-8')
    week = week.encode('utf-8')
    period = period.encode('utf-8')
    abstract = abstract.encode('utf-8')
    first = first.encode('utf-8')
    unique_hash = unique_hash.encode('utf-8')
    newcancel = models.Cancel(
        subject, teacher, day, week, period, abstract, first, unique_hash, now)
    try:
        ex_cancel = qkou.filter(
            models.Cancel.unique_hash == unique_hash).first()
        if ex_cancel is None:
            # ?????
            log.debug('???: %s … [??]', subject)
            session.add(newcancel)
            session.commit()
            new_id = newcancel.id
            return new_id
        else:
            # ?????
            log.debug('???: %s … [??]', subject)
            # ???????????????
            ex_cancel.up_time = now
            session.commit()
            return False
    except Exception as e:
        session.rollback()
        log.exception(e)
        return False
    finally:
        session.close()