示例#1
0
            flight = Flight(
                destination_airport=destination,
                departure_airport=departure,
                departure_time=dateutil.parser.parse(line['time']),
                code=line['flight']
            )

            db.session.add(flight)
            db.session.commit()

            # print 'imported destination, departure, line
            print 'EI VIRHE'
        except sqlalchemy.orm.exc.NoResultFound:
            print 'VIRHE'
            # airport = Airport(
            #     name=line[u'name'],
            #     code=line[u'iata']
            # )
            # db.session.add(airport)

            # u'destination': u'LEQ',
            # u'flight': u'5Y* 8',
            # u'departure': u'ISC',
            # u'time': u'2015-11-06T06:54:00.000Z'


with app.app_context():
    import_airports()
    import_routes()