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