def update_payment_status(payment_status, payment_id): s = Session() statustoupdate = {Payment.payment_status: payment_status} paymenttoupdate = s.query(Payment).filter( Payment.payment_yandex_id == payment_id) paymenttoupdate.update(statustoupdate) s.commit()
def get_payment_by_payment_id(payment_id): s = Session() return s.query(Payment).filter(Payment.payment_id == payment_id).first()
def get_payment_by_customer(customer): s = Session() return s.query(Payment).filter(Payment.payment_customer == customer).all()
def get_payment_status(status): s = Session() return s.query(Payment).filter(Payment.payment_status == status).first()
def add_payment(payment): s = Session() s.add(payment) s.commit()
def get_all_payments(): s = Session() return s.query(Payment).all
def get_products_by_type(type): s = Session() return s.query(Product).filter(Product.product_type == type).all()
def get_product_by_id(id): s = Session() return s.query(Product).filter(Product.id == id).first()
def get_all_products(): s = Session() return s.query(Product).all()
def add_product(product): # Session.Rollback s = Session() s.add(product) s.commit()