johannes/transport-accessibility
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases 1 Wiki Activity

Changed ids to always increase as automatic primary keys

Browse Source
This commit is contained in:
Johannes Randerath 2024-06-01 01:28:32 +02:00
parent 0a196d6b15
commit 9a4879a67d
4 changed files with 95 additions and 7 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

38
transport_accessibility/pt_map/migrations/0003_alter_calendar_service_id_and_more.py Normal file
View File

@ -0,0 +1,38 @@
# Generated by Django 5.0.6 on 2024-05-31 23:10
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
('pt_map', '0002_alter_calendardate_unique_together_and_more'),
]
operations = [
migrations.AlterField(
model_name='calendar',
name='service_id',
field=models.IntegerField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='fareattribute',
name='fare_id',
field=models.IntegerField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='feedinfo',
name='feed_id',
field=models.IntegerField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='route',
name='route_id',
field=models.IntegerField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='trip',
name='trip_id',
field=models.IntegerField(primary_key=True, serialize=False),
),
]

48
transport_accessibility/pt_map/migrations/0004_alter_agency_agency_id_alter_calendar_service_id_and_more.py Normal file
View File

@ -0,0 +1,48 @@
# Generated by Django 5.0.6 on 2024-05-31 23:14
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
('pt_map', '0003_alter_calendar_service_id_and_more'),
]
operations = [
migrations.AlterField(
model_name='agency',
name='agency_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='calendar',
name='service_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='fareattribute',
name='fare_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='feedinfo',
name='feed_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='route',
name='route_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='stop',
name='stop_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
migrations.AlterField(
model_name='trip',
name='trip_id',
field=models.BigAutoField(primary_key=True, serialize=False),
),
]

14
transport_accessibility/pt_map/models.py
View File

@ -1,7 +1,7 @@
from django.db import models
class Agency(models.Model):
agency_id = models.IntegerField(primary_key=True)
agency_id = models.BigAutoField(primary_key=True)
agency_name = models.CharField(max_length=250)
agency_url = models.URLField()
agency_phone = models.CharField(max_length=15)
@ -9,7 +9,7 @@ class Agency(models.Model):
agency_fare_url = models.URLField()
class Stop(models.Model):
stop_id = models.IntegerField(primary_key=True)
stop_id = models.BigAutoField(primary_key=True)
stop_code = models.CharField(max_length=50)
stop_name = models.CharField(max_length=250)
tts_stop_name = models.CharField(max_length=250)
@ -27,7 +27,7 @@ class Stop(models.Model):
class Route(models.Model):
route_id = models.CharField(max_length=255, primary_key=True)
route_id = models.BigAutoField(primary_key=True)
agency = models.ForeignKey(Agency, on_delete=models.CASCADE)
route_short_name = models.CharField(max_length=255)
route_long_name = models.CharField(max_length=255)
@ -38,7 +38,7 @@ class Route(models.Model):
route_text_color = models.CharField(max_length=6, blank=True, null=True)
class Trip(models.Model):
trip_id = models.CharField(max_length=255, primary_key=True)
trip_id = models.BigAutoField(primary_key=True)
route = models.ForeignKey(Route, on_delete=models.CASCADE)
service_id = models.CharField(max_length=255)
trip_headsign = models.CharField(max_length=255, blank=True, null=True)
@ -65,7 +65,7 @@ class StopTime(models.Model):
unique_together = (('trip', 'stop_sequence'),)
class Calendar(models.Model):
service_id = models.CharField(max_length=255, primary_key=True)
service_id = models.BigAutoField(primary_key=True)
monday = models.BooleanField()
tuesday = models.BooleanField()
wednesday = models.BooleanField()
@ -86,7 +86,7 @@ class CalendarDate(models.Model):
class FareAttribute(models.Model):
fare_id = models.CharField(max_length=255, primary_key=True)
fare_id = models.BigAutoField(primary_key=True)
price = models.FloatField()
currency_type = models.CharField(max_length=255)
payment_method = models.IntegerField()
@ -134,4 +134,4 @@ class FeedInfo(models.Model):
feed_start_date = models.DateField(blank=True, null=True)
feed_end_date = models.DateField(blank=True, null=True)
feed_version = models.CharField(max_length=255, blank=True, null=True)
feed_id = models.CharField(max_length=255, primary_key=True)
feed_id = models.BigAutoField(primary_key=True)

2
transport_accessibility/pt_map/views.py
View File

@ -1,6 +1,8 @@
from django.shortcuts import render
from django.http import HttpResponse
from .models import Agency, Stop, Route, Trip, StopTime, Calendar, CalendarDate, FareAttribute, FareRule, Shape, Frequency, Transfer, FeedInfo
def index(request):
return HttpResponse("Test")