pg

func (*PostgresDatabase) AddFlight ¶

func (p *PostgresDatabase) AddFlight(ctx context.Context, flight model.Flight, includeDefaultPassengers bool) (model.FlightId, error)

func (*PostgresDatabase) AddPassengerForUser ¶ added in v0.1.1

func (p *PostgresDatabase) AddPassengerForUser(ctx context.Context, user model.UserId, passenger model.Passenger) error

func (*PostgresDatabase) AddPassengerToFlight ¶ added in v0.1.1

func (p *PostgresDatabase) AddPassengerToFlight(ctx context.Context, flightId model.FlightId, user model.UserId, passenger model.UserId) error

func (*PostgresDatabase) DeleteFlight ¶

func (p *PostgresDatabase) DeleteFlight(ctx context.Context, flight model.Flight) error

func (*PostgresDatabase) GetFilghtDetail ¶ added in v0.2.2

func (p *PostgresDatabase) GetFilghtDetail(ctx context.Context, user model.UserId, flight_id model.FlightId) (model.Flight, error)

getFlightDetailSql string = "SELECT origin, destination, tail, flight_date, added, user_id FROM flights WHERE id = $1"

func (*PostgresDatabase) GetFlightsAsPassenger ¶ added in v0.1.1

func (p *PostgresDatabase) GetFlightsAsPassenger(ctx context.Context, passenger model.UserId) ([]model.Flight, error)

func (*PostgresDatabase) GetFlightsForUser ¶

func (p *PostgresDatabase) GetFlightsForUser(ctx context.Context, user model.UserId) ([]model.Flight, error)

func (*PostgresDatabase) GetPassengersForFlightUser ¶ added in v0.2.1

func (p *PostgresDatabase) GetPassengersForFlightUser(ctx context.Context, flight model.FlightId, user model.UserId) ([]model.UserId, error)

func (*PostgresDatabase) GetPassengersForUser ¶ added in v0.1.1

func (p *PostgresDatabase) GetPassengersForUser(ctx context.Context, user model.UserId) ([]model.Passenger, error)

func (*PostgresDatabase) GetTailDetails ¶

func (p *PostgresDatabase) GetTailDetails(ctx context.Context, tail model.PlaneTail, user model.UserId) (model.PlaneDetail, error)

func (*PostgresDatabase) RemovePassengerForUser ¶ added in v0.1.1

func (p *PostgresDatabase) RemovePassengerForUser(ctx context.Context, user model.UserId, passenger model.UserId) error

func (*PostgresDatabase) RemovePassengerFromFlight ¶ added in v0.1.1

func (p *PostgresDatabase) RemovePassengerFromFlight(ctx context.Context, flight model.FlightId, user model.UserId, passenger model.UserId) error

func (*PostgresDatabase) SetDefaultStatusForPassengerOfUser ¶ added in v0.1.1

func (p *PostgresDatabase) SetDefaultStatusForPassengerOfUser(ctx context.Context, user model.UserId, passenger model.UserId, defaultStatus bool) error

func (*PostgresDatabase) UpdateFlight ¶

func (p *PostgresDatabase) UpdateFlight(ctx context.Context, flight model.Flight) error