database

Documentation

Index

• type CreateUrlParams
• type DBTX
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUrl(ctx context.Context, arg CreateUrlParams) (Url, error)
  • func (q *Queries) DeleteUrlByShortUrl(ctx context.Context, shortUrl string) (Url, error)
  • func (q *Queries) GetUrlByShortUrl(ctx context.Context, shortUrl string) (Url, error)
  • func (q *Queries) ListUrls(ctx context.Context) ([]Url, error)
  • func (q *Queries) UpdateClickCount(ctx context.Context, shortUrl string) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Url

Types

type CreateUrlParams

type CreateUrlParams struct {
	Url       string
	ShortUrl  string
	ExpiredAt time.Time
}

type DBTX

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 Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateUrl

func (q *Queries) CreateUrl(ctx context.Context, arg CreateUrlParams) (Url, error)

func (*Queries) DeleteUrlByShortUrl

func (q *Queries) DeleteUrlByShortUrl(ctx context.Context, shortUrl string) (Url, error)

func (*Queries) GetUrlByShortUrl

func (q *Queries) GetUrlByShortUrl(ctx context.Context, shortUrl string) (Url, error)

func (*Queries) ListUrls

func (q *Queries) ListUrls(ctx context.Context) ([]Url, error)

func (*Queries) UpdateClickCount

func (q *Queries) UpdateClickCount(ctx context.Context, shortUrl string) error

func (*Queries) WithTx

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

type Url

type Url struct {
	ID         uuid.UUID
	Url        string
	ShortUrl   string
	ClickCount pgtype.Int4
	CreatedAt  pgtype.Timestamptz
	ExpiredAt  time.Time
}