MarechJ / hll_rcon_tool

Hell Let Loose Community RCON, CRCON for short. An alternative rcon client for HLL. It is a web application with many features, historical data, statistics, discord integrations, etc
MIT License
98 stars 69 forks source link

Merge foreign key IDs for duplicated player IDs #648

Closed cemathey closed 2 weeks ago

cemathey commented 2 weeks ago

Courtesy of SourceCode in the Discord.

I just translated this to use the SQLAlchemy session for running the textual SQL instead of the raw connection.

Ran it against a copy of our database that has duplicate records, looks like it works fine and it allows the player IDs to convert after the merging command runs.

Took about 8 seconds to run on our VPS.