for row in stopsReader:
try:
stops.append({
'stopId': int(row['stop_id']),
'stopName': row['stop_name'],
'location': [float(row['stop_lon']), float(row['stop_lat'])]
})
except ValueError:
pass
print str(len(stops)) + " stops"
db.insertStops(stops, curDate)
routes = []
routesReader = DictReader(zipFile.open("routes.txt"))
for row in routesReader:
try:
row['route_id'] = int(row['route_id'])
routes.append(row)
except ValueError:
pass
print str(len(routes)) + " routes"
db.insertRoutes(routes, curDate)
print "Generating Destinations Collection"
destinations = []
for trip in db.getFinalStops(curDate):
destinations.append({ 'tripId': trip['_id'],
'stopName': db.getStopName(trip['stopId'], curDate) })
print str(len(destinations)) + " destinations"
db.insertDestinations(destinations, curDate)
try:
stops.append(
{
"stopId": row["stop_id"],
"stopName": row["stop_name"],
"location": [float(row["stop_lat"]), float(row["stop_lon"])],
}
)
except ValueError:
pass
print str(len(stops)) + " stops"
db.insertStops(stops, curDate)
routes = []
routesReader = DictReader(zipFile.open("routes.txt"))
for row in routesReader:
try:
row["route_id"] = int(row["route_id"])
routes.append(row)
except ValueError:
pass
print str(len(routes)) + " routes"
db.insertRoutes(routes, curDate)
print "Generating Destinations Collection"
destinations = []
for trip in db.getFinalStops(curDate):
destinations.append({"tripId": trip["_id"], "stopName": db.getStopName(trip["stopId"], curDate)})
print str(len(destinations)) + " destinations"
db.insertDestinations(destinations, curDate)
