search

OpenTransitTools / gtfsdb

GTFS ORM using SQLAlchemy
Mozilla Public License 2.0
160 stars 45 forks source link

Debug messages from gtfsdb-load #17

Closed herbiehuff closed 8 years ago

herbiehuff commented 8 years ago

Hello,

I hope this is the right place to post this kind of question. When I run gtfsdb-load, I get a bunch of debug messages and I can't find any evidence that a sqlite database was created. Here's what I get. (I am using ipython, thus the ! to run shell commands).

In [34]: !gtfsdb-load https://code.google.com/transit/spec/sample-feed.zip
13:10:12,464 DEBUG [gtfsdb.model.gtfs] GTFS.load: https://code.google.com/transit/spec/sample-feed.zip
13:10:12,471 DEBUG [gtfsdb.model.route] RouteType.load (0 seconds)
13:10:12,474 DEBUG [gtfsdb.model.stop_feature] StopFeatureType.load (0 seconds)
13:10:12,474 DEBUG [gtfsdb.model.feed_info] FeedInfo.load (0 seconds)
13:10:12,475 DEBUG [gtfsdb.model.agency] Agency.load (0 seconds)
13:10:12,480 DEBUG [gtfsdb.model.calendar] Calendar.load (0 seconds)
13:10:12,482 DEBUG [gtfsdb.model.calendar] CalendarDate.load (0 seconds)
13:10:12,483 DEBUG [gtfsdb.model.route] Route.load (0 seconds)
13:10:12,485 DEBUG [gtfsdb.model.stop] Stop.load (0 seconds)
13:10:12,486 DEBUG [gtfsdb.model.stop_feature] StopFeature.load (0 seconds)
13:10:12,486 DEBUG [gtfsdb.model.transfer] Transfer.load (0 seconds)
13:10:12,486 DEBUG [gtfsdb.model.shape] Shape.load (0 seconds)
/Users/herbie/Library/Enthought/Canopy_64bit/User/lib/python2.7/site-packages/SQLAlchemy-1.1.2-py2.7-macosx-10.6-x86_64.egg/sqlalchemy/sql/sqltypes.py:596: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
13:10:12,489 DEBUG [gtfsdb.model.shape] Pattern.load (0 seconds)
13:10:12,491 DEBUG [gtfsdb.model.trip] Trip.load (0 seconds)
13:10:12,495 DEBUG [gtfsdb.model.stop_time] StopTime.load (0 seconds)
13:10:12,496 DEBUG [gtfsdb.model.frequency] Frequency.load (0 seconds)
13:10:12,498 DEBUG [gtfsdb.model.fare] FareAttribute.load (0 seconds)
13:10:12,500 DEBUG [gtfsdb.model.fare] FareRule.load (0 seconds)
13:10:12,930 DEBUG [gtfsdb.model.calendar] UniversalCalendar.load (0 seconds)
13:10:12,931 DEBUG [gtfsdb.model.gtfs] GTFS.load (0 seconds)

Any help or advice is much appreciated.

herbiehuff commented 8 years ago

Update: nevermind! I figured out that I was having problems specifying the right database_url.