Hi
I have a model definition
class Product(db.Model):
__tablename__ = "products"
id = db.Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
sku = db.Column(db.String(255), nullable=False, unique=True, index=True)
Product.base_price = column_property(
cast(func.get_product_price(), Numeric(15, 5)).label("base_price")
)
get_product_price is postgres function
CREATE OR REPLACE FUNCTION public.get_product_price()
> RETURNS numeric AS
> $BODY$
> BEGIN
> return 100;
> END;
> $BODY$
> LANGUAGE plpgsql VOLATILE
> COST 100;
If I execute the query as
Product.query.order_by(Product.base_price.asc()).all()
it all works great.
The problem is if I want to pass the product to function
CREATE OR REPLACE FUNCTION public.get_product_price(product products)
> RETURNS numeric AS
> $BODY$
> -- do something with product
> BEGIN
> return 100;
> END;
> $BODY$
> LANGUAGE plpgsql VOLATILE
> COST 100;
Is it possible to pass the reference/alias to product to function? I tried
with alias but without any success.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/071cec63-88d8-4660-bfe0-e5317924493e%40googlegroups.com.
