It works! Thank you very much Simon, I really appreciate that. You saved me a lot of nerves. I would buy you a beer if I could.
So, in general we can say that only second calling style works in my example. Regards. W dniu czwartek, 11 lipca 2019 16:35:25 UTC+2 użytkownik Simon King napisał: > > Here are the docs for the Update.values() method: > > > https://docs.sqlalchemy.org/en/13/core/dml.html#sqlalchemy.sql.expression.Update.values > > > Note that it supports two main calling styles, either keyword arguments: > > .values(name_column='cat') > > ...or passing a dictionary: > > .values({'name_column': 'cat'}) > > Since you want to choose the column dynamically, you can use the > dictionary style: > > updatevalues = {custom_column: value} > query = AIRPORT.update().values(updatevalues) > > Hope that helps, > > Simon > > On Thu, Jul 11, 2019 at 3:00 PM Mirek Morek <[email protected] > <javascript:>> wrote: > > > > Hello everyone, > > I have a following question: > > > > I use sqlalchemy within my python method as follows: > > > > > > I want to be able to replace 'custom_column' with parameter passed in > the method. The same way as it works fine for airport_sys_id, > project_sys_id and value. > > > > For example I want to pass in my method (1, 2, name_column, cat) and > receive as follows: > > > > query = AIRPORT.update(). \ > > where(AIRPORT.c.airport_sys_id == 1). \ > > where(AIRPORT.c.project_sys_id == 2). \ > > values(name_column=cat) > > > > I searched all I could but with no success. I would be extremely > thankful for your support. Regards. > > > > > > -- > > 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 [email protected] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/67448673-060d-449c-9dd9-19d5049c0c72%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/11786218-4161-4d41-b4e1-6faa7a31611b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
