db

type CreatePackageParams struct {
	ID            string `json:"id"`
	Name          string `json:"name"`
	Description   string `json:"description"`
	Price         int64  `json:"price"`
	StripePriceID string `json:"stripe_price_id"`
}

type CreatePackageTxInput struct {
	Name        string `json:"name"`
	Description string `json:"description"`
	Price       int64  `json:"price"`
}

type CreatePackageTxResult struct {
	Message string `json:"message"`
}

type CreateSubscriptionUserParams struct {
	ID       int64  `json:"id"`
	Username string `json:"username"`
	Email    string `json:"email"`
	StripeID string `json:"stripe_id"`
}

type CreateUserPackageParams struct {
	ID        string             `json:"id"`
	UserID    int64              `json:"user_id"`
	PackageID string             `json:"package_id"`
	Status    SubscriptionStatus `json:"status"`
	StartDate time.Time          `json:"start_date"`
	EndDate   time.Time          `json:"end_date"`
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type GetUserPackagesRow struct {
	ID            string             `json:"id"`
	UserID        int64              `json:"user_id"`
	PackageID     string             `json:"package_id"`
	Status        SubscriptionStatus `json:"status"`
	StartDate     time.Time          `json:"start_date"`
	EndDate       time.Time          `json:"end_date"`
	ID_2          int64              `json:"id_2"`
	Username      string             `json:"username"`
	Email         string             `json:"email"`
	StripeID      string             `json:"stripe_id"`
	CreatedAt     time.Time          `json:"created_at"`
	ID_3          string             `json:"id_3"`
	Name          string             `json:"name"`
	Description   string             `json:"description"`
	Price         int64              `json:"price"`
	StripePriceID string             `json:"stripe_price_id"`
}

type NullSubscriptionStatus struct {
	SubscriptionStatus SubscriptionStatus
	Valid              bool // Valid is true if SubscriptionStatus is not NULL
}

type Package struct {
	ID            string `json:"id"`
	Name          string `json:"name"`
	Description   string `json:"description"`
	Price         int64  `json:"price"`
	StripePriceID string `json:"stripe_price_id"`
}

type Querier interface {
	CreatePackage(ctx context.Context, arg CreatePackageParams) (Package, error)
	CreateSubscriptionUser(ctx context.Context, arg CreateSubscriptionUserParams) (User, error)
	CreateUserPackage(ctx context.Context, arg CreateUserPackageParams) (UsersPackage, error)
	DeletePackage(ctx context.Context, id string) error
	DeleteSubscriptionUser(ctx context.Context, id int64) error
	DeleteUserPackage(ctx context.Context, id string) error
	GetPackage(ctx context.Context, id string) (Package, error)
	GetPackages(ctx context.Context) ([]Package, error)
	GetSubscriptionUserByStripeId(ctx context.Context, stripeID string) (User, error)
	GetSubscriptionUsers(ctx context.Context) ([]User, error)
	GetUserPackages(ctx context.Context) ([]GetUserPackagesRow, error)
	UpdatePackage(ctx context.Context, arg UpdatePackageParams) (Package, error)
	UpdateSubscriptionUser(ctx context.Context, arg UpdateSubscriptionUserParams) (User, error)
	UpdateUserPackage(ctx context.Context, arg UpdateUserPackageParams) (UsersPackage, error)
}

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

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

type SubscribePackageTxInput struct {
	CustomerID            string
	SubscriptionPackageID string
}

type SubscribePackageTxOutput struct {
	Message string
}

type SubscriptionStatus string

type TxSubscriptionsStore interface {
	Querier
	CreatePackageTx(ctx context.Context, args CreatePackageTxInput) (CreatePackageTxResult, error)
	SubscribePackageTx(ctx context.Context, args SubscribePackageTxInput) (SubscribePackageTxOutput, error)
}

type UpdatePackageParams struct {
	Name        sql.NullString `json:"name"`
	Description sql.NullString `json:"description"`
	Price       sql.NullInt64  `json:"price"`
	ID          string         `json:"id"`
}

type UpdateSubscriptionUserParams struct {
	Username sql.NullString `json:"username"`
	Email    sql.NullString `json:"email"`
	StripeID sql.NullString `json:"stripe_id"`
	ID       int64          `json:"id"`
}

type UpdateUserPackageParams struct {
	PackageID sql.NullString         `json:"package_id"`
	Status    NullSubscriptionStatus `json:"status"`
	StartDate sql.NullTime           `json:"start_date"`
	EndDate   sql.NullTime           `json:"end_date"`
	ID        string                 `json:"id"`
}

type User struct {
	ID        int64     `json:"id"`
	Username  string    `json:"username"`
	Email     string    `json:"email"`
	StripeID  string    `json:"stripe_id"`
	CreatedAt time.Time `json:"created_at"`
}

type UsersPackage struct {
	ID        string             `json:"id"`
	UserID    int64              `json:"user_id"`
	PackageID string             `json:"package_id"`
	Status    SubscriptionStatus `json:"status"`
	StartDate time.Time          `json:"start_date"`
	EndDate   time.Time          `json:"end_date"`
}