sqlalchemy bulk update [closed]

Question

I use PostgreSQL 12 SQLAlchemy 1.4

I have a table with multiple columns and one column is a value which is computed in the python code before it's inserted. Now the factors in this computed value may change after a couple of months.

Table
--------------------------------------
player1 | country | date | rank | computed_score

I'm looking for an efficient way to loop over all rows and recompute that column. I have already looked through their examples and can efficiently fetch millions of rows https://docs.sqlalchemy.org/en/14/_modules/examples/performance/large_resultsets.html but how do I update each row efficiently?

Answer 1

Fastest way to do it is to do it on database.

Write a database function to calculate score run:

update table set computed_Score=calculate_score();