try: dbc.execute(queries.ClearRecordsTable) dbc.execute(queries.ClearAthletesTable) dbc.execute(queries.CLEAR_TRAINERS_TABLE) with open(file, newline='') as f: dbc.executemany( queries.addRecordFromFile, InputDataSet(f).check_rec_format().get_data_per_row()) dbc.execute(queries.FillInAthletesTable) dbc.execute(queries.AddAthleteIdToStatRecord) dbc.execute(queries.FILL_IN_TRAINERS_TABLE) except Connection.Error as e: # print(dbc._last_executed) print("MySQL Error {0}: {1}".format(e.args[0], e.args[1])) else: db.commit() elif o in ("-d", ): q_object = get_duplicate_name() SelectResult(q_object).print_qresult() elif o in ("--by-name"): q_object = get_regdata_by_name(a) result = SelectResult(q_object).print_qresult().report_tofile( "duplicates.csv") elif o in ("--schools"): try: dbc.execute(queries.GET_SCHOOLS) SelectResult(dbc).print_qresult() except Connection.Error as e: print("MySQL Error {0}: {1}".format(e.args[0], e.args[1])) else: assert False, "unhandled option"
def _critical_commit(self): try: BaseConnection.commit(self) finally: self.exit_critical_phase_at_transaction_end()