import mysql.connector
import datetime
import time
import random as rn

date = (datetime.datetime.now()).replace(second = 0, microsecond = 0)
czas = 43200
zakres = ['zakres' + str(i + 1) for i in range(100)]
opis = ['opis nr. ' + str(i + 1) for i in range(100)]
status = [i for i in range(1, 100)]
motocykl = [i for i in range(1, czas + 1)]

conn = mysql.connector.connect(user='root', password='', host = 'localhost', database = '23510152_marta')
mycursor = conn.cursor()
start_time = time.time()

# wypelnienie tabeli losowymi wartosciami
for i in range(czas):
    date += datetime.timedelta(minutes = 20)
    end_date = date + datetime.timedelta(minutes = 20)

    insertstmt=("INSERT INTO motocykl_wizyta VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')"
    % (i+1, date, end_date, motocykl[i], rn.choice(zakres), rn.randint(10, 2500), rn.choice(opis), rn.randint(10, 2500), rn.choice(status)))
    mycursor.execute(insertstmt)

elapsed_time = time.time() - start_time
conn.commit()

print ("Czas wykonania: %s" % elapsed_time)

mycursor.close()
conn.close()