18 lines
468 B
Python
18 lines
468 B
Python
import utils.sql_utils as sql_utils
|
|
import string, random
|
|
|
|
connection = sql_utils.connect_database('ubuntu-mariadb.home','admin','password','inventory')
|
|
|
|
cards = []
|
|
for i in range(0,100):
|
|
num = random.randint(0,100)
|
|
if not num in cards:
|
|
cards.append(num)
|
|
|
|
for index,value in enumerate(cards):
|
|
query = f'''
|
|
insert into access_cards (card_number,display_number) values ({index+1},{value})
|
|
'''
|
|
sql_utils.send_query(connection,query)
|
|
|
|
print("done") |