Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- import datetime
- import time
- import random as rn
- date = datetime.datetime.now()
- 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()
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement