Пример #1
0
def _insert_or_update_title(id=None, rank=None, name=None, requirement=None, stamp=None):
    """称号の運営用
    新しく称号を追加、更新するために使う
    """
    now = datetime.now()
    session = Session()
    if not name or not requirement:
        print "称号名と取得条件を入力してください"
        return False
    title = session.query(Title).filter(Title.id == id).limit(1).first()
    try:
        if title:
            title.rank = rank
            title.stamp = stamp
            title.modified = now
            print "title update",
        else:
            title = Title(id, rank, name, requirement, stamp, now, now)
            session.add(title)
            print "title insert",
        print name
        session.flush()
        session.commit()
        session.close()
        return True
    except Exception, e:
        print e
        session.rollback()
        session.commit()
        session.close()
        return False