0a17745389
Standardize formatting with black and apply ruff auto-fixes. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
33 lines
893 B
Python
33 lines
893 B
Python
import asyncio
|
|
import csv
|
|
import sys
|
|
|
|
from db_calls import *
|
|
|
|
|
|
async def main(argv):
|
|
with open("manual-updates.csv", "r") as file:
|
|
reader = csv.reader(file)
|
|
count = 0
|
|
for row in reader:
|
|
p_query = db_get("players", params=[("name", row[0]), ("cardset_id", 3)])
|
|
if p_query:
|
|
this_player = p_query["players"][0]
|
|
|
|
pos_1 = row[1]
|
|
pos_2 = row[2] if row[2] else False
|
|
pos_3 = row[3] if row[3] else False
|
|
|
|
db_patch(
|
|
"players",
|
|
object_id=this_player["player_id"],
|
|
params=[("pos_1", pos_1), ("pos_2", pos_2), ("pos_3", pos_3)],
|
|
)
|
|
count += 1
|
|
|
|
print(f'Just updated {count} record{"s" if count != 1 else ""}')
|
|
|
|
|
|
if __name__ == "__main__":
|
|
asyncio.run(main(sys.argv[1:]))
|