postgres

package

Go to main page

Versions in this module

v0

v0.2.3

Jun 30, 2025

v0.2.2

Oct 9, 2024

v0.2.1

Oct 1, 2024

Changes in this version

+ type Config struct

+ DBName string

+ Host string

+ Password string

+ Port int

+ SSLMode string

+ User string

+ type Store struct

+ Q *Queries

+ func (pgs *Store) GetMigrater(cfg Config) (*PostgresStoreMigrater, error)

v0.2.0

Sep 26, 2024

v0.1.4

Nov 30, 2023

v0.1.3

Aug 24, 2023

v0.1.2

Jun 27, 2023

v0.1.1

Jun 27, 2023

Changes in this version

type Queries

+ func (q *Queries) CouponExists(ctx context.Context, id string) (bool, error)

+ func (q *Queries) DeleteAllCoupons(ctx context.Context) error

+ func (q *Queries) DeleteCoupon(ctx context.Context, id string) error

+ func (q *Queries) UpdateSubscriptionDiscount(ctx context.Context, arg UpdateSubscriptionDiscountParams) error

+ func (q *Queries) UpsertCoupons(ctx context.Context, arg UpsertCouponsParams) error

+ type StripeCoupon struct

+ AmountOff sql.NullInt64

+ AppliesTo pqtype.NullRawMessage

+ Created int64

+ Currency sql.NullString

+ Duration string

+ DurationInMonths sql.NullInt64

+ ID string

+ Livemode bool

+ MaxRedemptions sql.NullInt64

+ Metadata pqtype.NullRawMessage

+ Name string

+ Object string

+ PercentOff sql.NullFloat64

+ RedeemBy sql.NullInt64

+ TimesRedeemed sql.NullInt64

+ UpdatedAt time.Time

+ Valid bool

type StripeSubscription

+ DiscountCoupon sql.NullString

+ DiscountDeleted sql.NullBool

+ DiscountEnd sql.NullInt64

+ DiscountID sql.NullString

+ DiscountPromotionCode sql.NullString

+ DiscountStart sql.NullInt64

+ type UpdateSubscriptionDiscountParams struct

+ DiscountCoupon sql.NullString

+ DiscountDeleted sql.NullBool

+ DiscountEnd sql.NullInt64

+ DiscountID sql.NullString

+ DiscountPromotionCode sql.NullString

+ DiscountStart sql.NullInt64

+ type UpsertCouponsParams struct

+ AmountOff sql.NullInt64

+ AppliesTo pqtype.NullRawMessage

+ Created int64

+ Currency sql.NullString

+ Duration string

+ DurationInMonths sql.NullInt64

+ ID string

+ Livemode bool

+ MaxRedemptions sql.NullInt64

+ Metadata pqtype.NullRawMessage

+ Name string

+ Object string

+ PercentOff sql.NullFloat64

+ RedeemBy sql.NullInt64

+ TimesRedeemed sql.NullInt64

+ Valid bool

type UpsertSubscriptionParams

+ DiscountCoupon sql.NullString

+ DiscountDeleted sql.NullBool

+ DiscountEnd sql.NullInt64

+ DiscountID sql.NullString

+ DiscountPromotionCode sql.NullString

+ DiscountStart sql.NullInt64

v0.1.0

Jun 26, 2023

v0.0.1

Jun 26, 2023

Changes in this version

+ func BuildConnectionDSN(dbname string) string

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type PostgresStore struct

+ Q *Queries

+ func NewPostgresStore() *PostgresStore

+ func NewPostgresTestStore() (*PostgresStore, func())

+ func (pgs *PostgresStore) GetMigrater() (*PostgresStoreMigrater, error)

+ type PostgresStoreMigrater struct

+ func (mig *PostgresStoreMigrater) Close() error

+ func (mig *PostgresStoreMigrater) Down() error

+ func (mig *PostgresStoreMigrater) Force(version int) error

+ func (mig *PostgresStoreMigrater) List() ([]string, error)

+ func (mig *PostgresStoreMigrater) SetLogger(logger migrate.Logger)

+ func (mig *PostgresStoreMigrater) To(version uint) error

+ func (mig *PostgresStoreMigrater) Up() error

+ func (mig *PostgresStoreMigrater) Version() (uint, bool, error)

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CustomerExists(ctx context.Context, id string) (bool, error)

+ func (q *Queries) DeleteAllCustomers(ctx context.Context) error

+ func (q *Queries) DeleteAllPrices(ctx context.Context) error

+ func (q *Queries) DeleteAllProducts(ctx context.Context) error

+ func (q *Queries) DeleteAllSubscriptions(ctx context.Context) error

+ func (q *Queries) DeleteCurrentSyncState(ctx context.Context) error

+ func (q *Queries) DeletePrice(ctx context.Context, id string) error

+ func (q *Queries) DeleteProduct(ctx context.Context, id string) error

+ func (q *Queries) GetCurrentSyncState(ctx context.Context) (StripeSyncState, error)

+ func (q *Queries) PriceExists(ctx context.Context, id string) (bool, error)

+ func (q *Queries) ProductExists(ctx context.Context, id string) (bool, error)

+ func (q *Queries) SetSyncState(ctx context.Context, lastEvent int64) error

+ func (q *Queries) UpsertCustomer(ctx context.Context, arg UpsertCustomerParams) error

+ func (q *Queries) UpsertPrice(ctx context.Context, arg UpsertPriceParams) error

+ func (q *Queries) UpsertProduct(ctx context.Context, arg UpsertProductParams) error

+ func (q *Queries) UpsertSubscription(ctx context.Context, arg UpsertSubscriptionParams) error

+ func (q *Queries) UpsertSubscriptionItem(ctx context.Context, arg UpsertSubscriptionItemParams) error

+ func (q *Queries) WithTx(tx *sql.Tx) *Queries

+ type StripeCustomer struct

+ Address pqtype.NullRawMessage

+ Balance sql.NullInt64

+ Created int64

+ Currency sql.NullString

+ DefaultSource sql.NullString

+ Deleted bool

+ Delinquent bool

+ Description sql.NullString

+ Discount pqtype.NullRawMessage

+ Email sql.NullString

+ ID string

+ InvoicePrefix string

+ InvoiceSettings pqtype.NullRawMessage

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ Name sql.NullString

+ NextInvoiceSequence int64

+ Object string

+ Phone sql.NullString

+ PreferredLocales []string

+ Shipping pqtype.NullRawMessage

+ TaxExempt string

+ UpdatedAt time.Time

+ type StripePrice struct

+ Active bool

+ BillingScheme string

+ Created int64

+ Currency string

+ ID string

+ Livemode bool

+ LookupKey sql.NullString

+ Metadata pqtype.NullRawMessage

+ Nickname sql.NullString

+ Object string

+ Product string

+ Recurring pqtype.NullRawMessage

+ TiersMode sql.NullString

+ TransformQuantity pqtype.NullRawMessage

+ Type string

+ UnitAmount sql.NullInt64

+ UnitAmountDecimal sql.NullFloat64

+ UpdatedAt time.Time

+ type StripeProduct struct

+ Active bool

+ Created int64

+ Description sql.NullString

+ ID string

+ Images []string

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ Name string

+ Object string

+ PackageDimensions pqtype.NullRawMessage

+ Shippable bool

+ StatementDescriptor sql.NullString

+ UnitLabel sql.NullString

+ Updated int64

+ UpdatedAt time.Time

+ Url sql.NullString

+ type StripeSubscription struct

+ ApplicationFeePercent sql.NullFloat64

+ BillingCycleAnchor int64

+ BillingThresholds pqtype.NullRawMessage

+ CancelAt sql.NullInt64

+ CancelAtPeriodEnd bool

+ CanceledAt sql.NullInt64

+ CollectionMethod string

+ Created int64

+ CurrentPeriodEnd int64

+ CurrentPeriodStart int64

+ Customer string

+ DaysUntilDue sql.NullInt64

+ DefaultPaymentMethod sql.NullString

+ DefaultSource sql.NullString

+ DefaultTaxRates pqtype.NullRawMessage

+ Discount pqtype.NullRawMessage

+ EndedAt sql.NullInt64

+ ID string

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ NextPendingInvoiceItemInvoice sql.NullInt64

+ Object string

+ PauseCollection pqtype.NullRawMessage

+ PendingInvoiceItemInterval pqtype.NullRawMessage

+ PendingSetupIntent sql.NullString

+ PendingUpdate pqtype.NullRawMessage

+ Schedule sql.NullString

+ StartDate int64

+ Status string

+ TransferData pqtype.NullRawMessage

+ TrialEnd sql.NullInt64

+ TrialStart sql.NullInt64

+ UpdatedAt time.Time

+ type StripeSubscriptionItem struct

+ BillingThresholds pqtype.NullRawMessage

+ Created int64

+ ID string

+ Metadata pqtype.NullRawMessage

+ Object string

+ Price string

+ Quantity int64

+ Subscription string

+ TaxRates pqtype.NullRawMessage

+ type StripeSyncState struct

+ ID string

+ LastEvent int64

+ type UpsertCustomerParams struct

+ Address pqtype.NullRawMessage

+ Balance sql.NullInt64

+ Created int64

+ Currency sql.NullString

+ Deleted bool

+ Delinquent bool

+ Description sql.NullString

+ Discount pqtype.NullRawMessage

+ Email sql.NullString

+ ID string

+ InvoicePrefix string

+ InvoiceSettings pqtype.NullRawMessage

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ Name sql.NullString

+ NextInvoiceSequence int64

+ Object string

+ Phone sql.NullString

+ PreferredLocales []string

+ Shipping pqtype.NullRawMessage

+ TaxExempt string

+ type UpsertPriceParams struct

+ Active bool

+ BillingScheme string

+ Created int64

+ Currency string

+ ID string

+ Livemode bool

+ LookupKey sql.NullString

+ Metadata pqtype.NullRawMessage

+ Nickname sql.NullString

+ Object string

+ Product string

+ Recurring pqtype.NullRawMessage

+ TiersMode sql.NullString

+ TransformQuantity pqtype.NullRawMessage

+ Type string

+ UnitAmount sql.NullInt64

+ UnitAmountDecimal sql.NullFloat64

+ type UpsertProductParams struct

+ Active bool

+ Created int64

+ Description sql.NullString

+ ID string

+ Images []string

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ Name string

+ Object string

+ PackageDimensions pqtype.NullRawMessage

+ Shippable bool

+ StatementDescriptor sql.NullString

+ UnitLabel sql.NullString

+ Updated int64

+ Url sql.NullString

+ type UpsertSubscriptionItemParams struct

+ BillingThresholds pqtype.NullRawMessage

+ Created int64

+ ID string

+ Metadata pqtype.NullRawMessage

+ Object string

+ Price string

+ Quantity int64

+ Subscription string

+ TaxRates pqtype.NullRawMessage

+ type UpsertSubscriptionParams struct

+ ApplicationFeePercent sql.NullFloat64

+ BillingCycleAnchor int64

+ BillingThresholds pqtype.NullRawMessage

+ CancelAt sql.NullInt64

+ CancelAtPeriodEnd bool

+ CanceledAt sql.NullInt64

+ CollectionMethod string

+ Created int64

+ CurrentPeriodEnd int64

+ CurrentPeriodStart int64

+ Customer string

+ DaysUntilDue sql.NullInt64

+ DefaultTaxRates pqtype.NullRawMessage

+ Discount pqtype.NullRawMessage

+ EndedAt sql.NullInt64

+ ID string

+ Livemode bool

+ Metadata pqtype.NullRawMessage

+ NextPendingInvoiceItemInvoice sql.NullInt64

+ Object string

+ PauseCollection pqtype.NullRawMessage

+ PendingInvoiceItemInterval pqtype.NullRawMessage

+ PendingUpdate pqtype.NullRawMessage

+ StartDate int64

+ Status string

+ TransferData pqtype.NullRawMessage

+ TrialEnd sql.NullInt64

+ TrialStart sql.NullInt64

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL