Inserting into dynamic column name using SQLAlchemy

Question

How do you insert values into a dynamic column name in SQLAlchemy? I am trying to insert values into a table using dynamic column names that are passed into the function.

I have tried:

        field_id = "column_name"

        query = (
            insert(
                TableName
            )
            .values(
                getattr(TableName.c, field_id)=value
            )
        )

But that tells me I can't assign a value to an expression

SyntaxError: expression cannot contain assignment, perhaps you meant \"==\"?"

snakecharmerb · Accepted Answer · 2022-12-08 09:54:35Z

1

You need to create a dictionary, and then unpack it, like this:

insert(tablename).values(**{field_id: 'foo'})

answered Dec 8, 2022 at 9:54

snakecharmerb

57.1k13 gold badges136 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Paul Bradbury Over a year ago

Great thank-you, that worked a charm, I was being a bit dumb.

Collectives™ on Stack Overflow

Inserting into dynamic column name using SQLAlchemy

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related