gtfs

type Calendar struct {
	DataSetId int64  `db:"data_set_id"`
	ServiceId string `db:"service_id"`
	Monday    int
	Tuesday   int
	Wednesday int
	Thursday  int
	Friday    int
	Saturday  int
	Sunday    int
	StartDate *time.Time `db:"start_date"`
	EndDate   *time.Time `db:"end_date"`
}

type CalendarDate struct {
	DataSetId     int64  `db:"data_set_id"`
	ServiceId     string `db:"service_id"`
	Date          time.Time
	ExceptionType int `db:"exception_type"`
}

type DataSet struct {
	Id  int64
	URL string
	// ETag is the ETag header if available from the source web site for the gtfs file. Is empty if not available
	ETag string `db:"e_tag"`
	// LastModifiedTimestamp is the unix epoch seconds the source web site provided for the last time the gtfs file was modified
	// is 0 if not available
	LastModifiedTimestamp int64      `db:"last_modified_timestamp"`
	DownloadedAt          time.Time  `db:"downloaded_at"`
	SavedAt               *time.Time `db:"saved_at"`
	ReplacedAt            *time.Time `db:"replaced_at"`
}

type DataSetOperation struct {
	DS *DataSet
	Db *sqlx.DB
}

type DataSetTransaction struct {
	DS DataSet
	Tx *sqlx.Tx
}

type ObservedStopTime struct {
	//ObservedTime is the time the vehicle movement was seen
	ObservedTime time.Time `db:"observed_time"`
	//StopId is the stopId the vehicle moved from
	StopId string `db:"stop_id"`
	//NextStopId is the stopId the vehicle moved to
	NextStopId string `db:"next_stop_id"`
	VehicleId  string `db:"vehicle_id"`

	RouteId string `db:"route_id"`
	//ObservedAtStop is true when a gtfs-rt vehicle record indicated the vehicle was located at the stop the vehicle moved from
	ObservedAtStop bool `db:"observed_at_stop"`

	//ObservedAtNextStop is true when a gtfs-rt vehicle record indicated the vehicle was located at the stop the vehicle moved to
	ObservedAtNextStop bool `db:"observed_at_next_stop"`

	//TravelSeconds is the number of seconds the vehicle is assumed to have taken to move between the stops
	TravelSeconds    int  `db:"travel_seconds"`
	ScheduledSeconds *int `db:"scheduled_seconds"`
	//DataSetId identifies the DataSet used during this ObservedStopTime
	DataSetId int64     `db:"data_set_id" json:"data_set_id"`
	TripId    string    `db:"trip_id"`
	CreatedAt time.Time `db:"created_at"`
}

type ScheduleSlice struct {
	ServiceDate  time.Time
	StartSeconds int
	EndSeconds   int
}

type Shape struct {
	DataSetId         int64    `db:"data_set_id" json:"data_set_id"`
	ShapeId           string   `db:"shape_id" json:"shape_id"`
	ShapePtLat        float64  `db:"shape_pt_lat" json:"shape_pt_lat"`
	ShapePtLng        float64  `db:"shape_pt_lon" json:"shape_pt_lon"`
	ShapePtSequence   int      `db:"shape_pt_sequence" json:"shape_pt_sequence"`
	ShapeDistTraveled *float64 `db:"shape_dist_traveled" json:"shape_dist_traveled"`
}

type StopTime struct {
	DataSetId         int64   `db:"data_set_id" json:"data_set_id"`
	TripId            string  `db:"trip_id" json:"trip_id"`
	StopSequence      uint32  `db:"stop_sequence" json:"stop_sequence"`
	StopId            string  `db:"stop_id" json:"stop_id"`
	ArrivalTime       int     `db:"arrival_time" json:"arrival_time"`
	DepartureTime     int     `db:"departure_time" json:"departure_time"`
	ShapeDistTraveled float64 `db:"shape_dist_traveled" json:"shape_dist_traveled"`
	Timepoint         int     `db:"timepoint" json:"timepoint"`
}

type StopTimeInstance struct {
	StopTime
	FirstStop         bool `json:"first_stop"`
	ArrivalDateTime   time.Time
	DepartureDateTime time.Time
}

type Trip struct {
	DataSetId     int64   `db:"data_set_id" json:"data_set_id"`
	TripId        string  `db:"trip_id" json:"trip_id"`
	RouteId       string  `db:"route_id" json:"route_id"`
	ServiceId     string  `db:"service_id" json:"service_id"`
	TripHeadsign  *string `db:"trip_headsign" json:"trip_headsign"`
	TripShortName *string `db:"trip_short_name" json:"trip_short_name"`
	BlockId       string  `db:"block_id" json:"block_id"`
	ShapeId       string  `db:"shape_id" json:"shape_id"`
	StartTime     int     `db:"start_time" json:"start_time"`
	EndTime       int     `db:"end_time" json:"end_time"`
	TripDistance  float64 `db:"trip_distance" json:"trip_distance"`
}

type TripDeviation struct {
	Id                 int64
	CreatedAt          time.Time `db:"created_at" json:"created_at"`
	DeviationTimestamp time.Time `db:"deviation_timestamp" json:"deviation_timestamp"`
	//TripProgress is the distance of the trip that has been traversed.
	//a negative number indicates a position on a prior trip to this one
	TripProgress float64 `db:"trip_progress" json:"trip_progress"`
	//DataSetId identifies the DataSet used when this TripDeviation was calculated
	DataSetId int64  `db:"data_set_id" json:"data_set_id"`
	TripId    string `db:"trip_id" json:"trip_id"`
	VehicleId string `db:"vehicle_id" json:"vehicle_id"`
	AtStop    bool   `db:"at_stop" json:"at_stop"`
	Delay     int    `db:"delay"`
}

type TripInstance struct {
	Trip
	StopTimeInstances []*StopTimeInstance `json:"stop_time_instances"`
	Shapes            []*Shape            `json:"shapes"`
}

type TripInstanceBatchQueryResults struct {
	TripInstancesByTripId   map[string]*TripInstance
	MissingTripIds          []string
	ScheduleSliceOutOfRange []string
	MissingShapeIds         []string
}