emmo - IRC - 2013.12.12

gistfile1.py

conn = r.connect()

cursor = r.db('gbrl').table('race').get_all(14136, index='season_id') \
    .pluck({'results':['driver', 'position']}, 'time') \
    .order_by('time') \
        .map( lambda race:
            r.branch( # That's just a if
                # Check if Andrew is in the results
                race["results"]["driver"].contains("Andrew Vennaro"),
                race["results"].filter(lambda doc:
                    doc['driver'] == 'Andrew Vennaro'
                )[0]["position"], # The position of Andrew
                None # We didn't find Andrew in the results
            )
        ).run(conn)


for i in cursor:
    print i