postgres

type Connection struct {
	Conn *pgxpool.Pool
	*Queries
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type InsertMovieParams struct {
	Name             string             `json:"name"`
	MovieTime        int16              `json:"movieTime"`
	Genres           []string           `json:"genres"`
	PremiereTime     pgtype.Timestamptz `json:"premiereTime"`
	PremiereFromDate pgtype.Date        `json:"premiereFromDate"`
	PremiereToDate   pgtype.Date        `json:"premiereToDate"`
}

type InsertSeatParams struct {
	TicketID   int64 `json:"ticketId"`
	SeatNumber int16 `json:"seatNumber"`
}

type InsertTicketParams struct {
	UserID       int64              `json:"userId"`
	MovieID      int64              `json:"movieId"`
	PremiereDate pgtype.Date        `json:"premiereDate"`
	PremiereTime pgtype.Timestamptz `json:"premiereTime"`
}

type InsertUserParams struct {
	FullName string `json:"fullName"`
	Email    string `json:"email"`
	Password string `json:"password"`
}

type Movie struct {
	ID               int64              `json:"id"`
	Name             string             `json:"name"`
	MovieTime        int16              `json:"movieTime"`
	Genres           []string           `json:"genres"`
	PremiereTime     pgtype.Timestamptz `json:"premiereTime"`
	PremiereFromDate pgtype.Date        `json:"premiereFromDate"`
	PremiereToDate   pgtype.Date        `json:"premiereToDate"`
}

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

type Seat struct {
	ID         int64 `json:"id"`
	TicketID   int64 `json:"ticketId"`
	SeatNumber int16 `json:"seatNumber"`
}

type SelectMovieReservedSeatsParams struct {
	MovieID      int64       `json:"movieId"`
	PremiereDate pgtype.Date `json:"premiereDate"`
}

type SelectMovieRow struct {
	ID               int64              `json:"id"`
	Name             string             `json:"name"`
	MovieTime        int16              `json:"movieTime"`
	Genres           []string           `json:"genres"`
	PremiereFromDate pgtype.Date        `json:"premiereFromDate"`
	PremiereToDate   pgtype.Date        `json:"premiereToDate"`
	PremiereTime     pgtype.Timestamptz `json:"premiereTime"`
}

type SelectMoviesRow struct {
	ID           int64              `json:"id"`
	Name         string             `json:"name"`
	PremiereTime pgtype.Timestamptz `json:"premiereTime"`
}

type SelectTicketParams struct {
	ID     int64 `json:"id"`
	UserID int64 `json:"userId"`
}

type SelectTicketRow struct {
	MovieID       int64              `json:"movieId"`
	MovieName     string             `json:"movieName"`
	MovieTime     int16              `json:"movieTime"`
	MovieGenres   []string           `json:"movieGenres"`
	ReservedAt    pgtype.Timestamptz `json:"reservedAt"`
	PremiereDate  pgtype.Date        `json:"premiereDate"`
	PremiereTime  pgtype.Timestamptz `json:"premiereTime"`
	ReservedSeats []int16            `json:"reservedSeats"`
}

type SelectUserTicketsRow struct {
	MovieID      int64              `json:"movieId"`
	TicketID     int64              `json:"ticketId"`
	MovieName    string             `json:"movieName"`
	PremiereDate pgtype.Date        `json:"premiereDate"`
	PremiereTime pgtype.Timestamptz `json:"premiereTime"`
}

type Ticket struct {
	ID           int64              `json:"id"`
	UserID       int64              `json:"userId"`
	MovieID      int64              `json:"movieId"`
	ReservedAt   pgtype.Timestamptz `json:"reservedAt"`
	PremiereDate pgtype.Date        `json:"premiereDate"`
	PremiereTime pgtype.Timestamptz `json:"premiereTime"`
}

type User struct {
	ID       int64  `json:"id"`
	FullName string `json:"fullName"`
	Email    string `json:"email"`
	Password string `json:"password"`
}