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'],
