put text() in there: func.discounted_price(text("packages.*"))
On Sep 8, 2014, at 9:59 AM, Tyler Bondy <ty.bo...@gmail.com> wrote: > 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. -- 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.