database

Documentation

Index

• Variables
• type R
  • func Connect(path string) (*R, error)
  • func Use(db *sql.DB) *R
  • func (r *R) CreateHoffmanDatabase() error
  • func (r *R) CreateProductTable() error
  • func (r *R) CreateProductTagTable() error
  • func (r *R) CreateProductTaggingTable() error
  • func (r *R) DeleteOneProductTagging(pid, tid uint) error
  • func (r *R) DeleteProduct(id uint) (*types.Product, error)
  • func (r *R) DeleteProductProductTagging(pid uint) error
  • func (r *R) DeleteProductTag(id uint) (*types.Tag, error)
  • func (r *R) DeleteTagProductTagging(tid uint) error
  • func (r *R) Disconnect() error
  • func (r *R) DropProductTable() error
  • func (r *R) DropProductTagTable() error
  • func (r *R) DropProductTaggingTable() error
  • func (r *R) InsertProduct(product *types.Product) error
  • func (r *R) InsertProductTag(tag *types.Tag) error
  • func (r *R) InsertProductTagging(pid, tid uint) error
  • func (r *R) SelectAllProductTags() ([]*types.Tag, error)
  • func (r *R) SelectAllProducts() ([]*types.Product, error)
  • func (r *R) SelectProductByEAN(ean uint) (*types.Product, error)
  • func (r *R) SelectProductById(id uint) (*types.Product, error)
  • func (r *R) SelectProductTagById(id uint) (*types.Tag, error)
  • func (r *R) SelectProductTagByName(name string) (*types.Tag, error)
  • func (r *R) SelectProductTaggingByPid(pid uint) ([]types.Tag, error)
  • func (r *R) SelectProductTaggingByTid(tid uint) ([]*types.Product, error)
  • func (r *R) SelectProductTaggingLikeTagName(name string) ([]*types.Product, error)
  • func (r *R) SelectProductTagsLikeName(name string) ([]*types.Tag, error)
  • func (r *R) SelectProductsLike(ps *types.ProductSearch) ([]*types.Product, error)
  • func (r *R) UpdateProduct(product *types.Product) (*types.Product, error)
  • func (r *R) UpdateProductTag(tag *types.Tag) (*types.Tag, error)

Variables

var (
	ErrInvalidEANType      = errors.New("invalid ean type")
	ErrNegativeEAN         = errors.New("negative ean")
	ErrNonUniqueIdentifier = errors.New("found non-unique identifier")
)

var (
	/* *** Errors *** */
	ErrInvalidOperator = errors.New("invalid sql constraint joining operator - must be AND/OR")
)

Types

type R

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

Database Repository structure

func Connect

func Connect(path string) (*R, error)

func Use

func Use(db *sql.DB) *R

func (*R) CreateHoffmanDatabase

func (r *R) CreateHoffmanDatabase() error

func (*R) CreateProductTable

func (r *R) CreateProductTable() error

func (*R) CreateProductTagTable

func (r *R) CreateProductTagTable() error

func (*R) CreateProductTaggingTable

func (r *R) CreateProductTaggingTable() error

func (*R) DeleteOneProductTagging

func (r *R) DeleteOneProductTagging(pid, tid uint) error

func (*R) DeleteProduct

func (r *R) DeleteProduct(id uint) (*types.Product, error)

func (*R) DeleteProductProductTagging

func (r *R) DeleteProductProductTagging(pid uint) error

func (*R) DeleteProductTag

func (r *R) DeleteProductTag(id uint) (*types.Tag, error)

func (*R) DeleteTagProductTagging

func (r *R) DeleteTagProductTagging(tid uint) error

func (*R) Disconnect

func (r *R) Disconnect() error

func (*R) DropProductTable

func (r *R) DropProductTable() error

func (*R) DropProductTagTable

func (r *R) DropProductTagTable() error

func (*R) DropProductTaggingTable

func (r *R) DropProductTaggingTable() error

func (*R) InsertProduct

func (r *R) InsertProduct(product *types.Product) error

func (*R) InsertProductTag

func (r *R) InsertProductTag(tag *types.Tag) error

func (*R) InsertProductTagging

func (r *R) InsertProductTagging(pid, tid uint) error

func (*R) SelectAllProductTags

func (r *R) SelectAllProductTags() ([]*types.Tag, error)

func (*R) SelectAllProducts

func (r *R) SelectAllProducts() ([]*types.Product, error)

func (*R) SelectProductByEAN

func (r *R) SelectProductByEAN(ean uint) (*types.Product, error)

func (*R) SelectProductById

func (r *R) SelectProductById(id uint) (*types.Product, error)

func (*R) SelectProductTagById

func (r *R) SelectProductTagById(id uint) (*types.Tag, error)

func (*R) SelectProductTagByName

func (r *R) SelectProductTagByName(name string) (*types.Tag, error)

func (*R) SelectProductTaggingByPid

func (r *R) SelectProductTaggingByPid(pid uint) ([]types.Tag, error)

func (*R) SelectProductTaggingByTid

func (r *R) SelectProductTaggingByTid(tid uint) ([]*types.Product, error)

func (*R) SelectProductTaggingLikeTagName

func (r *R) SelectProductTaggingLikeTagName(name string) ([]*types.Product, error)

func (*R) SelectProductTagsLikeName

func (r *R) SelectProductTagsLikeName(name string) ([]*types.Tag, error)

func (*R) SelectProductsLike

func (r *R) SelectProductsLike(ps *types.ProductSearch) ([]*types.Product, error)

func (*R) UpdateProduct

func (r *R) UpdateProduct(product *types.Product) (*types.Product, error)

func (*R) UpdateProductTag

func (r *R) UpdateProductTag(tag *types.Tag) (*types.Tag, error)