db

package
v0.0.0-...-37663e7 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 18, 2025 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type DBTX

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 DeleteSubscriptionParams

type DeleteSubscriptionParams struct {
	Email string    `json:"email"`
	Token uuid.UUID `json:"token"`
}

type FrequencyEnum

type FrequencyEnum string
const (
	FrequencyEnumHourly FrequencyEnum = "hourly"
	FrequencyEnumDaily  FrequencyEnum = "daily"
)

func (*FrequencyEnum) Scan

func (e *FrequencyEnum) Scan(src interface{}) error

type InsertSubscriptionParams

type InsertSubscriptionParams struct {
	Email     string        `json:"email"`
	City      string        `json:"city"`
	Frequency FrequencyEnum `json:"frequency"`
}

type NullFrequencyEnum

type NullFrequencyEnum struct {
	FrequencyEnum FrequencyEnum `json:"frequency_enum"`
	Valid         bool          `json:"valid"` // Valid is true if FrequencyEnum is not NULL
}

func (*NullFrequencyEnum) Scan

func (ns *NullFrequencyEnum) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullFrequencyEnum) Value

func (ns NullFrequencyEnum) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ConfirmSubscription

func (q *Queries) ConfirmSubscription(ctx context.Context, token uuid.UUID) error

func (*Queries) DeleteSubscription

func (q *Queries) DeleteSubscription(ctx context.Context, arg DeleteSubscriptionParams) error

func (*Queries) GetSubscription

func (q *Queries) GetSubscription(ctx context.Context, email string) (Subscription, error)

func (*Queries) GetSubscriptionByToken

func (q *Queries) GetSubscriptionByToken(ctx context.Context, token uuid.UUID) (Subscription, error)

func (*Queries) InsertSubscription

func (q *Queries) InsertSubscription(ctx context.Context, arg InsertSubscriptionParams) (Subscription, error)

func (*Queries) WithTx

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

type Store

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

func NewStore

func NewStore(db *sql.DB) *Store

type Subscription

type Subscription struct {
	ID        int64         `json:"id"`
	Email     string        `json:"email"`
	City      string        `json:"city"`
	Frequency FrequencyEnum `json:"frequency"`
	Token     uuid.UUID     `json:"token"`
	Confirmed bool          `json:"confirmed"`
}

Jump to

Keyboard shortcuts

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