I have a PostgreSQL function discounted_price(packages%ROWTYPE), where
packages is a table. I would like to add a property on the model
corresponding
to the packages table which returns the result of the discounted_price
function.
Currently I have this which works:
@property
def discounted_price(self):
return connection.execute('select discounted_price(packages.*) from
packages '
'where package_id=' +
str(self.package_id)).first()
But I'd like to call the function with sqlalchemy.sql.func, I'm just unsure
of how to
pass the packages%ROWTYPE corresponding to the model instance. Something
like this:
@property
def discounted_price(self):
return connection.query(func.discounted_price(**I don't know what goes
here**))
Is it possible to do this?
--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
