db

Documentation

Index

• Constants
• type CreateURLParams
• type DBTX
• type Querier
• type Queries
  • func New() *Queries
  • func (q *Queries) CreateURL(ctx context.Context, db DBTX, arg CreateURLParams) (Url, error)
  • func (q *Queries) DeleteURL(ctx context.Context, db DBTX, alias string) error
  • func (q *Queries) GetURLFromAlias(ctx context.Context, db DBTX, alias string) (Url, error)
• type Url

Constants

const CreateURL = `` /* 131-byte string literal not displayed */

const DeleteURL = `-- name: DeleteURL :exec
UPDATE urls
SET DELETED_AT = NOW()
WHERE alias = $1
	AND deleted_at IS NULL
`

const GetURLFromAlias = `` /* 147-byte string literal not displayed */

Types

type CreateURLParams

type CreateURLParams struct {
	Alias string `json:"alias"`
	Url   string `json:"url"`
}

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 Querier

type Querier interface {
	CreateURL(ctx context.Context, db DBTX, arg CreateURLParams) (Url, error)
	DeleteURL(ctx context.Context, db DBTX, alias string) error
	// SHORTLY
	GetURLFromAlias(ctx context.Context, db DBTX, alias string) (Url, error)
}

type Queries

type Queries struct {
}

func New

func New() *Queries

func (*Queries) CreateURL

func (q *Queries) CreateURL(ctx context.Context, db DBTX, arg CreateURLParams) (Url, error)

func (*Queries) DeleteURL

func (q *Queries) DeleteURL(ctx context.Context, db DBTX, alias string) error

func (*Queries) GetURLFromAlias

func (q *Queries) GetURLFromAlias(ctx context.Context, db DBTX, alias string) (Url, error)

SHORTLY

type Url

type Url struct {
	ID        int64        `json:"id"`
	Url       string       `json:"url"`
	Alias     string       `json:"alias"`
	CreatedAt time.Time    `json:"created_at"`
	UpdatedAt time.Time    `json:"updated_at"`
	DeletedAt sql.NullTime `json:"deleted_at"`
}