from objects import Session, Race session = Session() for race in session.query(Race): entry_result = repr(race.entries[0].result) marks = entry_result[1:-1].split(' ') race_result = repr(race.result) marks2 = race_result[1:-1].split(' ') if len(marks) != len(marks2): print(race.result) print(entry_result)
track_db = Track(name=track['name'], country=track['country'].strip(), abv=track['abv'].strip()) session.add(track_db) session.commit() if 'charts' in sys.argv: try: files = [sys.argv[2]] except IndexError: files = parse.all_files() for file_name in files: races = parse.chart(file_name) for race in races: track = (session.query(Track).filter( Track.name == race['track_name']).one()) race_db = Race(date=race['date'], race_number=race['race_number'], race_type=race['race_type'], track=track, registered=race['registered_state'], sex=race['sex'], age=race['age'], surface=race['surface'], distance=race['distance'], desc=race['race_desc'], code=race['desc2'], claiming_price=race['claiming_price'], purse=race['purse'], plus=race['purse_plus'], available_money=race['avail_money'],