db

type City struct {
	CityId   int    `json:"city_id"`
	CityName string `json:"city_name"`
}

type CityTour struct {
	Id     int `json:"id"`
	TourId int `json:"tour_id"`
	CityId int `json:"city_id"`

	CityTourPrice float64 `json:"city_tour_price"`

	DateFrom string `json:"date_from"`
	DateTo   string `json:"date_to"`

	TicketArrivalId   int `json:"ticket_arrival_id"`
	TicketDepartureId int `json:"ticket_departure_id"`

	HotelId int `json:"hotel_id"`
}

type CityTourData struct {
	Id int `json:"city_tour_id"`

	CountryName   string `json:"country_name"`
	CityId        int    `json:"city_id"`
	CityName      string `json:"city_name"`
	CityTourPrice string `json:"city_tour_price"`

	DateFrom string `json:"date_from"`
	DateTo   string `json:"date_to"`

	TicketArrivalId   int `json:"ticket_arrival_id"`
	TicketDepartureId int `json:"ticket_departure_id"`

	HotelId int `json:"hotel_id"`
}

type CityTourTicketData struct {
	ArrivalTicket   TicketData `json:"arrival_ticket"`
	DepartureTicket TicketData `json:"departure_ticket"`
}

type CityTourTicketIdData struct {
	TicketArrivalId   int `json:"ticket_arrival_id"`
	TicketDepartureId int `json:"ticket_departure_id"`
}

type CityToursEvent struct {
	CtId    int `json:"ct_id"`
	EventId int `json:"event_id"`
}

type CityToursRestBooking struct {
	CtId int `json:"ct_id"`
	RbId int `json:"rb_id"`
}

type Event struct {
	EventId          int    `json:"event_id"`
	EventName        string `json:"event_name"`
	EventDescription string `json:"event_description"`
	EventAddr        string `json:"event_addr"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`

	EventStart string  `json:"event_start"`
	EventEnd   string  `json:"event_end"`
	Price      string  `json:"price"`
	Rating     float64 `json:"rating"`

	MaxPersons int      `json:"max_persons"`
	CurPersons int      `json:"cur_persons"`
	Languages  []string `json:"languages"`
}

type EventData struct {
	Id        int    `json:"event_id"`
	EventName string `json:"event_name"`

	EventStart string  `json:"event_start"`
	EventEnd   string  `json:"event_end"`
	Price      string  `json:"price"`
	Rating     float64 `json:"rating"`

	MaxPersons int `json:"max_persons"`
	CurPersons int `json:"cur_persons"`
}

type EventFeedItem struct {
	EventId   int    `json:"event_id"`
	EventName string `json:"event_name"`

	EventStart string  `json:"event_start"`
	EventEnd   string  `json:"event_end"`
	Rating     float64 `json:"rating"`

	MaxPersons int `json:"max_persons"`
	CurPersons int `json:"cur_persons"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`
}

type EventsFilterParameters struct {
	Limit     int    `form:"limit"`
	Offset    int    `form:"offset"`
	OrderBy   string `form:"order_by"`
	OrderType string `form:"order_type"`

	EventName  string  `form:"event_name"`
	From       string  `form:"from"`
	To         string  `form:"to"`
	RatingFrom float64 `form:"rating_from"`
	RatingTo   float64 `form:"rating_to"`
	PriceFrom  float64 `form:"price_from"`
	PriceTo    float64 `form:"price_to"`

	CityName string `form:"city_name"`
}

type Hotel struct {
	HotelId          int    `json:"hotel_id"`
	HotelName        string `json:"hotel_name"`
	HotelDescription string `json:"hotel_description"`
	HotelAddr        string `json:"hotel_addr"`

	Stars       int     `json:"stars"`
	HotelRating float64 `json:"hotel_rating"`
	AvgPrice    string  `json:"average_price"`

	NearSea bool `json:"near_sea"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`
}

type HotelData struct {
	Id        int    `json:"hotel_id"`
	HotelName string `json:"hotel_name"`

	Stars       int     `json:"stars"`
	HotelRating float64 `json:"hotel_rating"`
}

type HotelFeedItem struct {
	HotelId     int     `json:"hotel_id"`
	HotelName   string  `json:"hotel_name"`
	Stars       int     `json:"stars"`
	HotelRating float64 `json:"hotel_rating"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`
}

type HotelFilterParameters struct {
	Limit     int    `form:"limit"`
	Offset    int    `form:"offset"`
	OrderBy   string `form:"order_by"`
	OrderType string `form:"order_type"`

	HotelName  string  `form:"hotel_name"`
	StarsFrom  int     `form:"stars_from"`
	StarsTo    int     `form:"stars_to"`
	RatingFrom float64 `form:"rating_from"`
	RatingTo   float64 `form:"rating_to"`
	PriceFrom  float64 `form:"price_from"`
	PriceTo    float64 `form:"price_to"`

	NearSea  bool   `form:"near_sea"`
	CityName string `form:"city_name"`
}

type PostgresRepository struct {
	// contains filtered or unexported fields
}

type Repository interface {
	Open() error

	CreateUser(user *User) error
	GetUserByEmail(email string) *User

	GetUser(userId int) *UserData
	GetUserPassword(userId int) (string, error)
	GetTours(userId int) []TourData
	GetCityTours(tourId int) []CityTourData

	GetUserEvents(cityTourId int) []EventData
	GetRestaurantBookings(cityTourId int) []RestaurantBookingData
	GetUserTickets(cityTourId int) *CityTourTicketData
	GetUserHotel(cityTourId int) *HotelData

	CreateTour(tour *Tour) error
	CreateCityTour(cityTour *CityTour) error
	CreateCityTourEvent(cityTourEvent *CityToursEvent) error
	CreateRestaurantBooking(restaurantBooking *RestaurantBookingDTO) error

	UpdateUser(user *User) error
	UpdateTour(tour *Tour) error
	UpdateCityTour(cityTour *CityTour) error
	UpdateRestaurantBooking(restaurantBooking *RestaurantBooking) error

	DeleteUser(userId int) error
	DeleteTour(tourId int) error
	DeleteCityTour(cityTourId int) error
	DeleteRestaurantBooking(restaurantBookingId int) error

	GetCities() ([]City, error)
	GetHotel(id int) (*Hotel, error)
	GetEvent(id int) (*Event, error)
	GetRestaurant(id int) (*Restaurant, error)
	GetTicket(id int) (*Ticket, error)

	GetHotels(filter HotelFilterParameters) ([]HotelFeedItem, error)
	GetEvents(filter EventsFilterParameters) ([]EventFeedItem, error)
	GetRestaurants(filter RestaurantFilterParameters) ([]RestaurantFeedItem, error)
	GetTickets(filter TicketFilterParameters) ([]TicketFeedItem, error)
	// contains filtered or unexported methods
}

type Restaurant struct {
	RestaurantId int `json:"restaurant_id"`

	RestName        string `json:"restaurant_name"`
	RestDescription string `json:"restaurant_description"`
	RestAddr        string `json:"restaurant_addr"`

	AvgPrice   string  `json:"average_price"`
	RestRating float64 `json:"rating"`

	ChildMenu   bool `json:"child_menu"`
	SmokingRoom bool `json:"smoking_room"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`
}

type RestaurantBooking struct {
	Id           int    `json:"id"`
	RestaurantId int    `json:"restaurant_id"`
	BookingTime  string `json:"booking_time"`
}

type RestaurantBookingDTO struct {
	CtId         int    `json:"id"`
	RestaurantId int    `json:"restaurant_id"`
	BookingTime  string `json:"booking_time"`
}

type RestaurantBookingData struct {
	Id           int `json:"restaurant_booking_id"`
	RestaurantId int `json:"restaurant_id"`

	BookingTime    string `json:"booking_time"`
	RestaurantName string `json:"restaurant_name"`

	AveragePrice string  `json:"average_price"`
	Rating       float64 `json:"rating"`
}

type RestaurantFeedItem struct {
	RestaurantId   int     `json:"restaurant_id"`
	RestaurantName string  `json:"restaurant_name"`
	Rating         float64 `json:"rating"`

	CountryName string `json:"country_name"`
	CityName    string `json:"city_name"`
}

type RestaurantFilterParameters struct {
	Limit     int    `form:"limit"`
	Offset    int    `form:"offset"`
	OrderBy   string `form:"order_by"`
	OrderType string `form:"order_type"`

	RestaurantName string  `form:"restaurant_name"`
	RatingFrom     float64 `form:"rating_from"`
	RatingTo       float64 `form:"rating_to"`
	PriceFrom      float64 `form:"price_from"`
	PriceTo        float64 `form:"price_to"`

	ChildMenu   bool `form:"child_menu"`
	SmokingRoom bool `form:"smoking_room"`

	CityName string `form:"city_name"`
}

type Ticket struct {
	TicketId int `json:"ticket_id"`

	CompanyName   string  `json:"company_name"`
	CompanyRating float64 `json:"company_rating"`

	OrigStationName string `json:"orig_station_name"`
	OrigStationAddr string `json:"orig_station_addr"`
	OrigCountryName string `json:"orig_country_name"`
	OrigCityName    string `json:"orig_city_name"`

	DestStationName string `json:"dest_station_name"`
	DestStationAddr string `json:"dest_station_addr"`
	DestCityName    string `json:"dest_city_name"`
	DestCountryName string `json:"dest_country_name"`

	TransportType string `json:"transport_type"`
	Price         string `json:"price"`
	TicketDate    string `json:"ticket_date"`
}

type TicketData struct {
	Id            int    `json:"ticket_id"`
	TransportType string `json:"transport_type"`
	Price         string `json:"price"`
	Date          string `json:"date"`

	OrigCountryName string `json:"orig_country_name"`
	OrigCityName    string `json:"orig_city_name"`
	DestCountryName string `json:"dest_country_name"`
	DestCityName    string `json:"dest_city_name"`

	CompanyName   string  `json:"company_name"`
	CompanyRating float64 `json:"company_rating"`
}

type TicketFeedItem struct {
	TicketId      int    `json:"ticket_id"`
	TransportType string `json:"transport_type"`
	Price         string `json:"price"`
	Date          string `json:"date"`

	OrigCountryName string `json:"orig_country_name"`
	OrigCityName    string `json:"orig_city_name"`
	DestCountryName string `json:"dest_country_name"`
	DestCityName    string `json:"dest_city_name"`
}

type TicketFilterParameters struct {
	Limit     int    `form:"limit"`
	Offset    int    `form:"offset"`
	OrderBy   string `form:"order_by"`
	OrderType string `form:"order_type"`

	TransportType string  `form:"transport_type"`
	DateFrom      string  `form:"date_from"`
	DateTo        string  `form:"date_to"`
	PriceFrom     float64 `form:"price_from"`
	PriceTo       float64 `form:"price_to"`

	OrigCityName string `form:"orig_city_name"`
	DestCityName string `form:"dest_city_name"`
}

type Tour struct {
	Id     int `json:"id"`
	UserId int `json:"user_id"`

	TourName  string  `json:"tour_name"`
	TourPrice float64 `json:"tour_price"`

	TourDateFrom string `json:"tour_date_from"`
	TourDateTo   string `json:"tour_date_to"`
}

type TourData struct {
	Id int `json:"tour_id"`

	TourName  string `json:"tour_name"`
	TourPrice string `json:"tour_price"`

	TourDateFrom string `json:"tour_date_from"`
	TourDateTo   string `json:"tour_date_to"`
}

type User struct {
	Id       int    `json:"id"`
	Email    string `json:"email"`
	Password string `json:"password"`

	FirstName string `json:"first_name"`
	LastName  string `json:"last_name"`

	PhotoUrl string `json:"photo_url"`
}

type UserData struct {
	Id        int    `json:"user_id"`
	FirstName string `json:"first_name"`
	LastName  string `json:"last_name"`
	PhotoUrl  string `json:"photo_url"`
}