19 lines
504 B
Python
19 lines
504 B
Python
import uuid
|
|
import sqlite3
|
|
|
|
|
|
users = ["user1", "user2", "user3", "user4"]
|
|
keys = []
|
|
|
|
for user in users:
|
|
keys.append([user,str(uuid.uuid4())])
|
|
|
|
|
|
database_connection = sqlite3.connect("api_credentials.db")
|
|
database_cursor = database_connection.cursor()
|
|
database_cursor.execute("CREATE TABLE IF NOT EXISTS credentials_table (user TEXT, key TEXT)")
|
|
|
|
for pair in keys:
|
|
database_cursor.execute('INSERT INTO credentials_table VALUES(?, ?)', pair)
|
|
database_connection.commit()
|
|
database_connection.close() |