def update_intimacy(token, ftk, intimacy): try: session.query(Friend).filter(Friend.ftk == ftk, Friend.token == token).update( {Friend.intimacy: intimacy}) session.commit() except InvalidRequestError: session.rollback()
def update_sn(token, sn): try: session.query(User).filter(User.token == token).update({User.sn: sn}) session.commit() except InvalidRequestError: session.rollback() except Exception as e: print(e)
def do_save(code, content, url, image): try: ut = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) qrcode = Qrcode(code, content, url, image, ut) session.add(qrcode) session.commit() except InvalidRequestError: session.rollback()
def add_new_version_file(file_name, version, check_sum): adt = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) try: firmware = Firmware(file_name, version, check_sum, adt) session.add(firmware) session.commit() except InvalidRequestError: session.rollback()
async def update_token(old_token, new_token): try: session.query(Friend).filter(Friend.ftk == old_token).update( {Friend.ftk: new_token}) session.query(Friend).filter(Friend.token == old_token).update( {Friend.token: new_token}) session.commit() except InvalidRequestError: session.rollback()
def del_friend(token, ftk): try: session.query(Friend).filter(Friend.ftk == ftk, Friend.token == token).delete() session.query(Friend).filter(Friend.token == ftk, Friend.ftk == token).delete() session.commit() except InvalidRequestError: session.rollback() pass
def update_user(token, name, image): user = None try: session.query(User).filter(User.token == token).update({User.name: name, User.image: image}) session.commit() user = session.query(User).filter(User.token == token).first() except InvalidRequestError: session.rollback() except Exception as e: print(e) return user
def add_new_version(project, version_name, base_code, version_code, file_type, file_name, apk_check_sum, patch_check_sum): adt = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) try: version = Version(project, version_name, base_code, version_code, file_type, file_name, apk_check_sum, patch_check_sum, adt) session.add(version) session.commit() except InvalidRequestError: session.rollback()