databases
databases copied to clipboard
How to execute multiple queries into multiple tables?
I was trying to do something like this where the table name is part of the values in execute_many but it doesn't work...
queries = []
for name in unformatted:
value = user_data[name]['value']
leaderboard = name.replace("-",'_')
queries.append(
{
"table":leaderboard,
"uuid":uuid,
"user":user,
"prefix":prefix,
"suffix":suffix,
"value":value
}
)
await lb_db.execute_many(query="""
INSERT INTO :table VALUES
(:uuid,:user,:prefix,:suffix, :value)
ON CONFLICT(uuid) DO UPDATE SET
user = :user, prefix = :prefix, suffix = :suffix, value = :value
""", values=queries)