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