blob: 837b0a1e0db906267890dbdcfc269d0c16bd53a8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
from db import cursor
import uuid
tables = {
"users": "user_id",
"games": "game_id"
}
def new_uuid(table_name):
temp_uuid = str(uuid.uuid4())
column_name = tables[table_name]
# check if id is already taken
if cursor.execute(f"select {column_name} from {table_name} where {column_name} = ?", [temp_uuid]).fetchone():
return new_uuid(table_name)
else:
return temp_uuid
|