def insert_donor_data_into_table():
database_connector, cursor = connect_to_server()
cursor.execute("USE BloodDonationStorage")
if new_donor.donation_date == "":
new_donor.donation_date = "0000-00-00"
insert = """INSERT INTO Donor(First_name,Last_name, Weight, Gender, Date_of_birth, Donation_date, Sickness, ID_number,
Expiration_date, Blood_type, Email_address, Mobile_number, Hemoglobin_level)
VALUES('{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}')""".format(
new_donor.first_name,
new_donor.last_name,
new_donor.weight,
new_donor.gender,
new_donor.date_of_birth,
new_donor.donation_date,
new_donor.sickness,
new_donor.id_number,
new_donor.exp_date,
new_donor.blood_type,
new_donor.email_address,
new_donor.mobile_number,
new_donor.hemoglobin_level,
)
cursor.execute(insert)
database_connector.commit()
new_donor.donation_date = None
def insert_event_data_into_table():
database_connector, cursor = connect_to_server()
cursor.execute("USE BloodDonationStorage")
insert = """INSERT INTO Event(ID_number, Date_of_Event,Start_time, End_time, Zip_code, City, Address, Available_beds, Planned_donors, Max_donor_numbers,
Successful_donations)
VALUES('{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}')""".format(
new_event.event_id,
new_event.date_of_event,
new_event.start_time,
new_event.end_time,
new_event.zip_code,
new_event.city,
new_event.address,
new_event.available_beds,
new_event.planned_donors,
new_event.max_donor_number,
new_event.successful_donations
)
cursor.execute(insert)
database_connector.commit()
