db

package
v1.0.0 Latest Latest
Warning

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

Go to latest
Published: Mar 8, 2025 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type CreateImageParams

type CreateImageParams struct {
	Name   string      `json:"name"`
	UserID pgtype.UUID `json:"user_id"`
	Url    string      `json:"url"`
}

type CreateImageTransformationParams

type CreateImageTransformationParams struct {
	ImageID        pgtype.UUID `json:"image_id"`
	Transformation []byte      `json:"transformation"`
	Url            string      `json:"url"`
}

type CreateUserParams

type CreateUserParams struct {
	Email        string `json:"email"`
	PasswordHash string `json:"password_hash"`
}

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 GetImageTransformationsParams

type GetImageTransformationsParams struct {
	ImageID pgtype.UUID `json:"image_id"`
	Offset  int32       `json:"offset"`
	Limit   int32       `json:"limit"`
}

type GetUserImagesParams

type GetUserImagesParams struct {
	UserID pgtype.UUID `json:"user_id"`
	Offset int32       `json:"offset"`
	Limit  int32       `json:"limit"`
}

type Image

type Image struct {
	ID         pgtype.UUID        `json:"id"`
	Name       string             `json:"name"`
	UserID     pgtype.UUID        `json:"user_id"`
	Url        string             `json:"url"`
	UploadedAt pgtype.Timestamptz `json:"uploaded_at"`
}

type ImageTransformation

type ImageTransformation struct {
	ID             pgtype.UUID        `json:"id"`
	ImageID        pgtype.UUID        `json:"image_id"`
	Transformation []byte             `json:"transformation"`
	Url            string             `json:"url"`
	TransformedAt  pgtype.Timestamptz `json:"transformed_at"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateImage

func (q *Queries) CreateImage(ctx context.Context, arg CreateImageParams) (Image, error)

func (*Queries) CreateImageTransformation

func (q *Queries) CreateImageTransformation(ctx context.Context, arg CreateImageTransformationParams) (ImageTransformation, error)

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) GetImage

func (q *Queries) GetImage(ctx context.Context, id pgtype.UUID) (Image, error)

func (*Queries) GetImageTransformations

func (q *Queries) GetImageTransformations(ctx context.Context, arg GetImageTransformationsParams) ([]ImageTransformation, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id pgtype.UUID) (User, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserImages

func (q *Queries) GetUserImages(ctx context.Context, arg GetUserImagesParams) ([]Image, error)

func (*Queries) WithTx

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

type User

type User struct {
	ID           pgtype.UUID        `json:"id"`
	Email        string             `json:"email"`
	PasswordHash string             `json:"password_hash"`
	CreatedAt    pgtype.Timestamptz `json:"created_at"`
	UpdatedAt    pgtype.Timestamptz `json:"updated_at"`
}

Jump to

Keyboard shortcuts

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