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()