database

Documentation

Index

• type Category
• type CreateCategoryParams
• type CreateRecipeParams
• type CreateRecipeRow
• type CreateRefreshTokenParams
• type CreateUserParams
• type DBTX
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)
  • func (q *Queries) CreateRecipe(ctx context.Context, arg CreateRecipeParams) (CreateRecipeRow, error)
  • func (q *Queries) CreateRefreshToken(ctx context.Context, arg CreateRefreshTokenParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteCategory(ctx context.Context, id pgtype.UUID) error
  • func (q *Queries) DeleteRecipe(ctx context.Context, id pgtype.UUID) error
  • func (q *Queries) DeleteRefreshTokenByValue(ctx context.Context, value string) error
  • func (q *Queries) GetCategories(ctx context.Context) ([]Category, error)
  • func (q *Queries) GetCategoryByID(ctx context.Context, id pgtype.UUID) (Category, error)
  • func (q *Queries) GetCategoryByName(ctx context.Context, name string) (Category, error)
  • func (q *Queries) GetCategoryByNames(ctx context.Context, dollar_1 []pgtype.UUID) ([]Category, error)
  • func (q *Queries) GetRecipeByID(ctx context.Context, id pgtype.UUID) (Recipe, error)
  • func (q *Queries) GetRecipes(ctx context.Context) ([]Recipe, error)
  • func (q *Queries) GetRecipesByUser(ctx context.Context, userID pgtype.UUID) ([]Recipe, error)
  • func (q *Queries) GetRecipesWithLimit(ctx context.Context, limit int32) ([]Recipe, error)
  • func (q *Queries) GetRefreshTokenByValue(ctx context.Context, value string) (Token, error)
  • func (q *Queries) GetUserByAPIKey(ctx context.Context, apiKey string) (User, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserByID(ctx context.Context, id pgtype.UUID) (User, error)
  • func (q *Queries) GetUsersWithLimit(ctx context.Context, limit int32) ([]User, error)
  • func (q *Queries) UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (Category, error)
  • func (q *Queries) UpdateRecipe(ctx context.Context, arg UpdateRecipeParams) (UpdateRecipeRow, error)
  • func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (UpdateUserRow, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Recipe
• type Token
• type UpdateCategoryParams
• type UpdateRecipeParams
• type UpdateRecipeRow
• type UpdateUserParams
• type UpdateUserRow
• type User

Types

type Category

type Category struct {
	ID        pgtype.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	Name      string
}

type CreateCategoryParams

type CreateCategoryParams struct {
	ID        pgtype.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	Name      string
}

type CreateRecipeParams

type CreateRecipeParams struct {
	ID           pgtype.UUID
	CreatedAt    pgtype.Timestamp
	UpdatedAt    pgtype.Timestamp
	Title        string
	Description  string
	Difficulty   pgtype.Int4
	Ingredients  string
	Instructions string
	CategoryID   pgtype.UUID
	UserID       pgtype.UUID
}

type CreateRecipeRow

type CreateRecipeRow struct {
	ID        pgtype.UUID
	CreatedAt pgtype.Timestamp
	Title     string
}

type CreateRefreshTokenParams

type CreateRefreshTokenParams struct {
	UserID    pgtype.UUID
	Value     string
	ExpiresAt pgtype.Timestamp
}

type CreateUserParams

type CreateUserParams struct {
	ID        pgtype.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	Name      string
	Email     string
	Password  string
}

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) CreateCategory

func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)

func (*Queries) CreateRecipe

func (q *Queries) CreateRecipe(ctx context.Context, arg CreateRecipeParams) (CreateRecipeRow, error)

func (*Queries) CreateRefreshToken

func (q *Queries) CreateRefreshToken(ctx context.Context, arg CreateRefreshTokenParams) error

func (*Queries) CreateUser

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

func (*Queries) DeleteCategory

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

func (*Queries) DeleteRecipe

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

func (*Queries) DeleteRefreshTokenByValue

func (q *Queries) DeleteRefreshTokenByValue(ctx context.Context, value string) error

func (*Queries) GetCategories

func (q *Queries) GetCategories(ctx context.Context) ([]Category, error)

func (*Queries) GetCategoryByID

func (q *Queries) GetCategoryByID(ctx context.Context, id pgtype.UUID) (Category, error)

func (*Queries) GetCategoryByName

func (q *Queries) GetCategoryByName(ctx context.Context, name string) (Category, error)

func (*Queries) GetCategoryByNames

func (q *Queries) GetCategoryByNames(ctx context.Context, dollar_1 []pgtype.UUID) ([]Category, error)

func (*Queries) GetRecipeByID

func (q *Queries) GetRecipeByID(ctx context.Context, id pgtype.UUID) (Recipe, error)

func (*Queries) GetRecipes

func (q *Queries) GetRecipes(ctx context.Context) ([]Recipe, error)

func (*Queries) GetRecipesByUser

func (q *Queries) GetRecipesByUser(ctx context.Context, userID pgtype.UUID) ([]Recipe, error)

func (*Queries) GetRecipesWithLimit

func (q *Queries) GetRecipesWithLimit(ctx context.Context, limit int32) ([]Recipe, error)

func (*Queries) GetRefreshTokenByValue

func (q *Queries) GetRefreshTokenByValue(ctx context.Context, value string) (Token, error)

func (*Queries) GetUserByAPIKey

func (q *Queries) GetUserByAPIKey(ctx context.Context, apiKey string) (User, error)

func (*Queries) GetUserByEmail

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

func (*Queries) GetUserByID

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

func (*Queries) GetUsersWithLimit

func (q *Queries) GetUsersWithLimit(ctx context.Context, limit int32) ([]User, error)

func (*Queries) UpdateCategory

func (q *Queries) UpdateCategory(ctx context.Context, arg UpdateCategoryParams) (Category, error)

func (*Queries) UpdateRecipe

func (q *Queries) UpdateRecipe(ctx context.Context, arg UpdateRecipeParams) (UpdateRecipeRow, error)

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (UpdateUserRow, error)

func (*Queries) WithTx

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

type Recipe

type Recipe struct {
	ID           pgtype.UUID
	CreatedAt    pgtype.Timestamp
	UpdatedAt    pgtype.Timestamp
	Title        string
	Description  string
	Ingredients  string
	Instructions string
	CategoryID   pgtype.UUID
	UserID       pgtype.UUID
	Difficulty   pgtype.Int4
}

type Token

type Token struct {
	UserID    pgtype.UUID
	Value     string
	ExpiresAt pgtype.Timestamp
}

type UpdateCategoryParams

type UpdateCategoryParams struct {
	ID        pgtype.UUID
	UpdatedAt pgtype.Timestamp
	Name      string
}

type UpdateRecipeParams

type UpdateRecipeParams struct {
	ID           pgtype.UUID
	UpdatedAt    pgtype.Timestamp
	Title        string
	Description  string
	Ingredients  string
	Instructions string
	CategoryID   pgtype.UUID
	Difficulty   pgtype.Int4
}

type UpdateRecipeRow

type UpdateRecipeRow struct {
	ID        pgtype.UUID
	UpdatedAt pgtype.Timestamp
	Title     string
}

type UpdateUserParams

type UpdateUserParams struct {
	ID        pgtype.UUID
	UpdatedAt pgtype.Timestamp
	Name      string
	Email     string
	Password  string
}

type UpdateUserRow

type UpdateUserRow struct {
	ID        pgtype.UUID
	UpdatedAt pgtype.Timestamp
	Name      string
}

type User

type User struct {
	ID        pgtype.UUID
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	Name      string
	ApiKey    string
	Email     string
	Password  string
}