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()