Mercurial > buscompiler / file comparison
comparison: datamodel.py
datamodel.py
- changeset 2
- 7378b802ddf8
- parent 1
- f9788970fa46
equal
deleted
inserted
replaced
| 1:f9788970fa46 | 2:7378b802ddf8 |
|---|---|
| 37 stop_region_major = sqlalchemy.Column(sqlalchemy.Boolean) | 37 stop_region_major = sqlalchemy.Column(sqlalchemy.Boolean) |
| 38 | 38 |
| 39 class GtfsRegion(GtfsBase): | 39 class GtfsRegion(GtfsBase): |
| 40 # Not a gtfs data set, but the Gtfs prefix added for consistency | 40 # Not a gtfs data set, but the Gtfs prefix added for consistency |
| 41 __tablename__ = 'regions' | 41 __tablename__ = 'regions' |
| 42 region_name = sqlalchemy.Column(sqlalchemy.String, primary_key = True) | 42 ref = sqlalchemy.Column(sqlalchemy.String, primary_key = True) |
| 43 region_name_fi = sqlalchemy.Column(sqlalchemy.String, nullable = False) | |
| 43 region_name_sv = sqlalchemy.Column(sqlalchemy.String) | 44 region_name_sv = sqlalchemy.Column(sqlalchemy.String) |
| 44 region_name_en = sqlalchemy.Column(sqlalchemy.String) | 45 region_name_en = sqlalchemy.Column(sqlalchemy.String) |
| 45 region_name_ja = sqlalchemy.Column(sqlalchemy.String) | 46 region_name_ja = sqlalchemy.Column(sqlalchemy.String) |
| 46 region_short_name = sqlalchemy.Column(sqlalchemy.String) | 47 region_short_name_fi = sqlalchemy.Column(sqlalchemy.String) |
| 47 region_short_name_sv = sqlalchemy.Column(sqlalchemy.String) | 48 region_short_name_sv = sqlalchemy.Column(sqlalchemy.String) |
| 48 region_short_name_en = sqlalchemy.Column(sqlalchemy.String) | 49 region_short_name_en = sqlalchemy.Column(sqlalchemy.String) |
| 49 region_short_name_ja = sqlalchemy.Column(sqlalchemy.String) | 50 region_short_name_ja = sqlalchemy.Column(sqlalchemy.String) |
| 50 region_internal_name = sqlalchemy.Column(sqlalchemy.String) | 51 region_internal_name_fi = sqlalchemy.Column(sqlalchemy.String) |
| 51 region_internal_name_sv = sqlalchemy.Column(sqlalchemy.String) | 52 region_internal_name_sv = sqlalchemy.Column(sqlalchemy.String) |
| 52 region_internal_name_en = sqlalchemy.Column(sqlalchemy.String) | 53 region_internal_name_en = sqlalchemy.Column(sqlalchemy.String) |
| 53 region_internal_name_ja = sqlalchemy.Column(sqlalchemy.String) | 54 region_internal_name_ja = sqlalchemy.Column(sqlalchemy.String) |
| 54 municipality = sqlalchemy.Column(sqlalchemy.String, nullable = False) | 55 municipality = sqlalchemy.Column(sqlalchemy.String, nullable = False) |
| 55 external = sqlalchemy.Column(sqlalchemy.Boolean) | 56 external = sqlalchemy.Column(sqlalchemy.Boolean) |
| 57 | |
| 58 class GtfsStopTime(GtfsBase): | |
| 59 __tablename__ = 'stop_times' | |
| 60 trip_id = sqlalchemy.Column( | |
| 61 sqlalchemy.String, | |
| 62 sqlalchemy.ForeignKey(GtfsTrip.id), | |
| 63 primary_key = True, | |
| 64 ) | |
| 65 stop_id = sqlalchemy.Column( | |
| 66 sqlalchemy.String, | |
| 67 sqlalchemy.ForeignKey(GtfsStop.stop_id), | |
| 68 nullable = False, | |
| 69 ) | |
| 70 stop_sequence = sqlalchemy.Column( | |
| 71 sqlalchemy.Integer, | |
| 72 primary_key = True, | |
| 73 ) | |
| 74 arrival_time = sqlalchemy.Column(sqlalchemy.Interval, nullable = False) | |
| 75 departure_time = sqlalchemy.Column(sqlalchemy.Interval, nullable = False) | |
| 76 shape_distance_traveled = sqlalchemy.Column(sqlalchemy.Numeric) | |
| 77 destination = sqlalchemy.Column(sqlalchemy.String) | |
| 78 stop = sqlalchemy.orm.relationship( | |
| 79 'GtfsStop', | |
| 80 foreign_keys = 'GtfsStopTime.stop_id', | |
| 81 ) | |
| 82 trip = sqlalchemy.orm.relationship( | |
| 83 'GtfsTrip', | |
| 84 foreign_keys = 'GtfsStopTime.trip_id', | |
| 85 ) |
