def fill_gen_assign_workshop_attendee():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
workshop_attendees = []
cursor.execute("select distinct Attendees.AttendeeID, WorkshopReservations.WReservationID "
"from Attendees "
"inner join Participation on Participation.AttendeeID = Attendees.AttendeeID "
"inner join Reservations on Reservations.ReservationID = Participation.ReservationID "
"inner join WorkshopReservations on WorkshopReservations.ReservationID = Reservations.ReservationID")
row = cursor.fetchone()
while row:
workshop_attendees.append((row[0], row[1]))
row = cursor.fetchone()
filler = Connector()
workshop_attendees_size = len(workshop_attendees)
filler.apply_proc_multi('AssignParticipantToWorkshop', workshop_attendees, workshop_attendees_size)
conn.close()
def fill_gen_assign_workshop_attendee():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
workshop_attendees = []
cursor.execute(
"select distinct Attendees.AttendeeID, WorkshopReservations.WReservationID "
"from Attendees "
"inner join Participation on Participation.AttendeeID = Attendees.AttendeeID "
"inner join Reservations on Reservations.ReservationID = Participation.ReservationID "
"inner join WorkshopReservations on WorkshopReservations.ReservationID = Reservations.ReservationID"
)
row = cursor.fetchone()
while row:
workshop_attendees.append((row[0], row[1]))
row = cursor.fetchone()
filler = Connector()
workshop_attendees_size = len(workshop_attendees)
filler.apply_proc_multi('AssignParticipantToWorkshop', workshop_attendees,
workshop_attendees_size)
conn.close()
def fill_gen_assign_attendee():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
individual_participation = []
cursor.execute(
"select distinct Attendees.AttendeeID, Reservations.ReservationID "
"from Attendees "
"inner join Clients on Attendees.ClientID = Clients.ClientID "
"inner join Reservations on Reservations.ClientID = Clients.ClientID "
"inner join Individual on Individual.ClientID = Clients.ClientID")
row = cursor.fetchone()
while row:
individual_participation.append((row[0], row[1]))
row = cursor.fetchone()
company_participation = []
cursor.execute(
"select distinct Attendees.AttendeeID, Reservations.ReservationID "
"from Attendees "
"inner join Clients on Attendees.ClientID = Clients.ClientID "
"inner join Reservations on Reservations.ClientID = Clients.ClientID "
"inner join Company on Company.ClientID = Clients.ClientID")
row = cursor.fetchone()
while row:
company_participation.append((row[0], row[1]))
row = cursor.fetchone()
# Two list of (AttendeeID, ReservationID) to apply
# The following lines may cause declination of IDE control xD
# print(individual_participation)
# print(len(individual_participation))
# print(company_participation)
# print(len(company_participation))
# Those insertions causes error -> try block
filler = Connector()
individual_size = len(individual_participation)
filler.apply_proc_multi('AssignAttendee', individual_participation,
individual_size)
company_size = len(company_participation)
filler.apply_proc_multi('AssignAttendee', company_participation,
company_size)
conn.close()
def fill_gen_assign_attendee():
connector = Connector()
conn = connector.connect(secretpassword)
cursor = conn.cursor()
individual_participation = []
cursor.execute("select distinct Attendees.AttendeeID, Reservations.ReservationID "
"from Attendees "
"inner join Clients on Attendees.ClientID = Clients.ClientID "
"inner join Reservations on Reservations.ClientID = Clients.ClientID "
"inner join Individual on Individual.ClientID = Clients.ClientID")
row = cursor.fetchone()
while row:
individual_participation.append((row[0], row[1]))
row = cursor.fetchone()
company_participation = []
cursor.execute("select distinct Attendees.AttendeeID, Reservations.ReservationID "
"from Attendees "
"inner join Clients on Attendees.ClientID = Clients.ClientID "
"inner join Reservations on Reservations.ClientID = Clients.ClientID "
"inner join Company on Company.ClientID = Clients.ClientID")
row = cursor.fetchone()
while row:
company_participation.append((row[0], row[1]))
row = cursor.fetchone()
# Two list of (AttendeeID, ReservationID) to apply
# The following lines may cause declination of IDE control xD
# print(individual_participation)
# print(len(individual_participation))
# print(company_participation)
# print(len(company_participation))
# Those insertions causes error -> try block
filler = Connector()
individual_size = len(individual_participation)
filler.apply_proc_multi('AssignAttendee', individual_participation, individual_size)
company_size = len(company_participation)
filler.apply_proc_multi('AssignAttendee', company_participation, company_size)
conn.close()
