def create_debs(debs):
session = Session()
try:
session.add_all(debs)
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def change_settings(user_id, value):
session = Session()
try:
session.query(tables.Settings).filter(
tables.Settings.user_id == user_id).update({'lite': value})
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def update_username(user_id, user_name):
session = Session()
try:
session.query(tables.User).filter(
tables.User.user_id == user_id).update({'user_name': user_name})
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def order_up(order_id, text):
session = Session()
try:
session.query(tables.Orders).filter(
tables.Orders.order_id == order_id).update(
{'text': text})
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def order_price_up(order_id, price):
session = Session()
try:
session.query(tables.Orders).filter(
tables.Orders.order_id == order_id).update(
{'price': price})
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def update_order_status(order_id, status, date):
session = Session()
try:
session.query(tables.Orders).filter(
tables.Orders.order_id == order_id).update(
{'status': status,
'date': date})
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def create_access(user_id, foreign_id):
session = Session()
access = tables.Access(user_id=user_id, access=foreign_id)
try:
session.add(access)
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def create_user(user_id, user_name):
session = Session()
user = tables.User(user_id=user_id, user_name=user_name)
access = tables.Access(user_id=user_id, access=user_id)
status = tables.UserStatus(user_id=user_id)
settings = tables.Settings(user_id=user_id)
try:
session.add(user)
session.add(access)
session.add(status)
session.add(settings)
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
def create_order(user_id, text):
session = Session()
user = session.query(tables.User).filter(
tables.User.user_id == user_id).first()
date = create_date()
order = tables.Orders(user_id=user_id,
user_name=user.user_name,
text=text,
created=date)
try:
session.add(order)
session.commit()
except Exception as e:
session.rollback()
raise e
finally:
session.close()
