def fill_gen_add_payment():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute("select ReservationID, ToPay, ReservationDate from Reservations")
row = cursor.fetchone()
ratio = [i / 10 for i in range(1, 11)]
c = Connector()
cn = c.connect(secretpassword)
while row:
reservationid = row[0]
topay = row[1]
date = row[2]
money_deposited = math.floor(int(topay) * random.choice(ratio))
(y, m, d) = date.split("-")
begin = dt.date(int(y), int(m), int(d)).toordinal()
book_ord = dt.datetime.fromordinal(begin + random.randint(1, 7))
date_of_payment = "/".join((str(book_ord.year), str(book_ord.month), str(book_ord.day)))
result = (reservationid, money_deposited, date_of_payment)
print("Add Payment " + str(result))
c.apply_proc('GeneratorAddPayment', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_payment():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute(
"select ReservationID, ToPay, ReservationDate from Reservations")
row = cursor.fetchone()
ratio = [i / 10 for i in range(1, 11)]
c = Connector()
cn = c.connect(secretpassword)
while row:
reservationid = row[0]
topay = row[1]
date = row[2]
money_deposited = math.floor(int(topay) * random.choice(ratio))
(y, m, d) = date.split("-")
begin = dt.date(int(y), int(m), int(d)).toordinal()
book_ord = dt.datetime.fromordinal(begin + random.randint(1, 7))
date_of_payment = "/".join(
(str(book_ord.year), str(book_ord.month), str(book_ord.day)))
result = (reservationid, money_deposited, date_of_payment)
print("Add Payment " + str(result))
c.apply_proc('GeneratorAddPayment', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_book_places_for_workshop():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute("select Reservations.ReservationID, WorkshopID, MaxSpots "
"from DaysOfConf "
"inner join Workshops on Workshops.DayID = DaysOfConf.DayID "
"inner join Reservations on Reservations.DayID = DaysOfConf.DayID")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
reservationid = row[0]
workshopid = row[1]
maxspots = math.floor(row[2] / 3)
result = (reservationid, workshopid, maxspots)
print("Add Workshop Reservation " + str(result))
c.apply_proc('BookPlacesForWorkshop', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_attendees():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute("select company.clientid, spotsreserved from company "
"inner join clients on clients.clientid = company.clientid "
"inner join reservations on reservations.clientid = clients.clientid")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
clientid = row[0]
spots_reserved = row[1]
for reservation in range(spots_reserved):
name, surname = getNameSurname()
result = (clientid, name, surname)
print("Add Attendee " + str(result))
c.apply_proc('AddAttendee', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_book_places_for_workshop():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute(
"select Reservations.ReservationID, WorkshopID, MaxSpots "
"from DaysOfConf "
"inner join Workshops on Workshops.DayID = DaysOfConf.DayID "
"inner join Reservations on Reservations.DayID = DaysOfConf.DayID")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
reservationid = row[0]
workshopid = row[1]
maxspots = math.floor(row[2] / 3)
result = (reservationid, workshopid, maxspots)
print("Add Workshop Reservation " + str(result))
c.apply_proc('BookPlacesForWorkshop', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_attendees():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute(
"select company.clientid, spotsreserved from company "
"inner join clients on clients.clientid = company.clientid "
"inner join reservations on reservations.clientid = clients.clientid")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
clientid = row[0]
spots_reserved = row[1]
for reservation in range(spots_reserved):
name, surname = getNameSurname()
result = (clientid, name, surname)
print("Add Attendee " + str(result))
c.apply_proc('AddAttendee', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_book_places_for_day():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
clients = []
clients_getter = conn.cursor()
clients_getter.execute("select clientid from clients")
clients_ids = clients_getter.fetchone()
while clients_ids:
clients.append(clients_ids[0])
clients_ids = clients_getter.fetchone()
cursor.execute(
"select DayId, conferences.DateFrom, Spots "
"from DaysOfConf "
"inner join Conferences on conferences.ConferenceId = daysofconf.ConferenceId"
)
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
dayid = row[0]
date = row[1]
spots_avail = row[2]
(y, m, d) = date.split("-")
begin = dt.date(int(y), int(m), int(d)).toordinal()
for reservation in range(3):
client = random.choice(clients)
spots = random.randint(1, int(spots_avail / 4))
book_ord = dt.datetime.fromordinal(begin - random.randint(15, 80))
date_of_book = "/".join(
(str(book_ord.year), str(book_ord.month), str(book_ord.day)))
result = (dayid, client, spots, date_of_book)
print("Book spots for the day " + str(result))
c.apply_proc('GeneratorBookPlacesForDay', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_book_places_for_day():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
clients = []
clients_getter = conn.cursor()
clients_getter.execute("select clientid from clients")
clients_ids = clients_getter.fetchone()
while clients_ids:
clients.append(clients_ids[0])
clients_ids = clients_getter.fetchone()
cursor.execute("select DayId, conferences.DateFrom, Spots "
"from DaysOfConf "
"inner join Conferences on conferences.ConferenceId = daysofconf.ConferenceId")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
dayid = row[0]
date = row[1]
spots_avail = row[2]
(y, m, d) = date.split("-")
begin = dt.date(int(y), int(m), int(d)).toordinal()
for reservation in range(3):
client = random.choice(clients)
spots = random.randint(1, int(spots_avail/4))
book_ord = dt.datetime.fromordinal(begin - random.randint(15, 80))
date_of_book = "/".join((str(book_ord.year), str(book_ord.month), str(book_ord.day)))
result = (dayid, client, spots, date_of_book)
print("Book spots for the day " + str(result))
c.apply_proc('GeneratorBookPlacesForDay', result)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_thresholds():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute("select * from conferences")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
idconf = row[0]
dayofconf = row[2]
for threshold in range(3):
res = gen_add_thresholds(idconf, threshold, dayofconf)
c.apply_proc('AddPrice', res)
print(res)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_thresholds():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
cursor.execute("select * from conferences")
row = cursor.fetchone()
c = Connector()
cn = c.connect(secretpassword)
while row:
idconf = row[0]
dayofconf = row[2]
for threshold in range(3):
res = gen_add_thresholds(idconf, threshold, dayofconf)
c.apply_proc('AddPrice', res)
print(res)
row = cursor.fetchone()
conn.close()
cn.close()
def fill_gen_add_workshop():
connector = Connector()
conn = connector.connect(secretpassword)
workshop_types_id = []
workshop_getter = conn.cursor()
workshop_getter.execute("select WorkshopTypeID from WorkshopType")
types_row = workshop_getter.fetchone()
while types_row:
workshop_types_id.append(types_row[0])
types_row = workshop_getter.fetchone()
days_id = []
days_getter = conn.cursor()
days_getter.execute("select DayID from DaysOfConf")
days_row = days_getter.fetchone()
while days_row:
days_id.append(days_row[0])
days_row = days_getter.fetchone()
conn.close()
print(workshop_types_id)
print(days_id)
c = Connector()
cn = c.connect(secretpassword)
for day in days_id:
workshop = random.choice(workshop_types_id)
start = random.choice(["14:00:00", "15:00:00", "16:00:00"])
end = random.choice(["18:00:00", "19:00:00", "20:00:00"])
spots = random.choice([5, 10, 15, 20])
price = random.randint(2, 15) * 10
result = (workshop, day, start, end, spots, price)
print("Add Workshop " + str(result))
c.apply_proc('AddWorkshop', result)
cn.close()
def fill_gen_add_workshop():
connector = Connector()
conn = connector.connect(secretpassword)
workshop_types_id = []
workshop_getter = conn.cursor()
workshop_getter.execute("select WorkshopTypeID from WorkshopType")
types_row = workshop_getter.fetchone()
while types_row:
workshop_types_id.append(types_row[0])
types_row = workshop_getter.fetchone()
days_id = []
days_getter = conn.cursor()
days_getter.execute("select DayID from DaysOfConf")
days_row = days_getter.fetchone()
while days_row:
days_id.append(days_row[0])
days_row = days_getter.fetchone()
conn.close()
print(workshop_types_id)
print(days_id)
c = Connector()
cn = c.connect(secretpassword)
for day in days_id:
workshop = random.choice(workshop_types_id)
start = random.choice(["14:00:00", "15:00:00", "16:00:00"])
end = random.choice(["18:00:00", "19:00:00", "20:00:00"])
spots = random.choice([5, 10, 15, 20])
price = random.randint(2, 15) * 10
result = (workshop, day, start, end, spots, price)
print("Add Workshop " + str(result))
c.apply_proc('AddWorkshop', result)
cn.close()
