mysql

package
v0.0.0-...-de94dfd Latest Latest
Warning

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

 Go to latest Published: Oct 16, 2022 License: MIT Imports: 4 Imported by: 0

Documentation

Overview

Package mysql contains generated code for schema 'northwind'.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Errorf 

func Errorf(s string, v ...interface{})

Errorf logs an error message using the package error logger.

func Logf 

func Logf(s string, v ...interface{})

Logf logs a message using the package logger.

func SetErrorLogger 

func SetErrorLogger(logger interface{})

SetErrorLogger sets the package error logger. Valid logger types: 

io.Writer
func(string, ...interface{}) (int, error) // fmt.Printf
func(string, ...interface{}) // log.Printf

func SetLogger 

func SetLogger(logger interface{})

SetLogger sets the package logger. Valid logger types: 

io.Writer
func(string, ...interface{}) (int, error) // fmt.Printf
func(string, ...interface{}) // log.Printf

Types

type Category 

type Category struct {
	CategoryID   int16          `json:"category_id"`   // category_id
	CategoryName string         `json:"category_name"` // category_name
	Description  sql.NullString `json:"description"`   // description
	Picture      []byte         `json:"picture"`       // picture
	// contains filtered or unexported fields
}

Category represents a row from 'northwind.categories'.

func CategoryByCategoryID 

func CategoryByCategoryID(ctx context.Context, db DB, categoryID int16) (*Category, error)

CategoryByCategoryID retrieves a row from 'northwind.categories' as a Category.

Generated from index 'categories_category_id_pkey'.

func (*Category) Delete 

func (c *Category) Delete(ctx context.Context, db DB) error

Delete deletes the Category from the database.

func (*Category) Deleted 

func (c *Category) Deleted() bool

Deleted returns true when the Category has been marked for deletion from the database.

func (*Category) Exists 

func (c *Category) Exists() bool

Exists returns true when the Category exists in the database.

func (*Category) Insert 

func (c *Category) Insert(ctx context.Context, db DB) error

Insert inserts the Category to the database.

func (*Category) Save 

func (c *Category) Save(ctx context.Context, db DB) error

Save saves the Category to the database.

func (*Category) Update 

func (c *Category) Update(ctx context.Context, db DB) error

Update updates a Category in the database.

func (*Category) Upsert 

func (c *Category) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Category.

type Customer 

type Customer struct {
	CustomerID   string         `json:"customer_id"`   // customer_id
	CompanyName  string         `json:"company_name"`  // company_name
	ContactName  sql.NullString `json:"contact_name"`  // contact_name
	ContactTitle sql.NullString `json:"contact_title"` // contact_title
	Address      sql.NullString `json:"address"`       // address
	City         sql.NullString `json:"city"`          // city
	Region       sql.NullString `json:"region"`        // region
	PostalCode   sql.NullString `json:"postal_code"`   // postal_code
	Country      sql.NullString `json:"country"`       // country
	Phone        sql.NullString `json:"phone"`         // phone
	Fax          sql.NullString `json:"fax"`           // fax
	// contains filtered or unexported fields
}

Customer represents a row from 'northwind.customers'.

func CustomerByCustomerID 

func CustomerByCustomerID(ctx context.Context, db DB, customerID string) (*Customer, error)

CustomerByCustomerID retrieves a row from 'northwind.customers' as a Customer.

Generated from index 'customers_customer_id_pkey'.

func (*Customer) Delete 

func (c *Customer) Delete(ctx context.Context, db DB) error

Delete deletes the Customer from the database.

func (*Customer) Deleted 

func (c *Customer) Deleted() bool

Deleted returns true when the Customer has been marked for deletion from the database.

func (*Customer) Exists 

func (c *Customer) Exists() bool

Exists returns true when the Customer exists in the database.

func (*Customer) Insert 

func (c *Customer) Insert(ctx context.Context, db DB) error

Insert inserts the Customer to the database.

func (*Customer) Save 

func (c *Customer) Save(ctx context.Context, db DB) error

Save saves the Customer to the database.

func (*Customer) Update 

func (c *Customer) Update(ctx context.Context, db DB) error

Update updates a Customer in the database.

func (*Customer) Upsert 

func (c *Customer) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Customer.

type CustomerCustomerDemo 

type CustomerCustomerDemo struct {
	CustomerID     string `json:"customer_id"`      // customer_id
	CustomerTypeID string `json:"customer_type_id"` // customer_type_id
	// contains filtered or unexported fields
}

CustomerCustomerDemo represents a row from 'northwind.customer_customer_demo'.

func CustomerCustomerDemoByCustomerIDCustomerTypeID 

func CustomerCustomerDemoByCustomerIDCustomerTypeID(ctx context.Context, db DB, customerID, customerTypeID string) (*CustomerCustomerDemo, error)

CustomerCustomerDemoByCustomerIDCustomerTypeID retrieves a row from 'northwind.customer_customer_demo' as a CustomerCustomerDemo.

Generated from index 'customer_customer_demo_customer_id_customer_type_id_pkey'.

func CustomerCustomerDemoByCustomerTypeID 

func CustomerCustomerDemoByCustomerTypeID(ctx context.Context, db DB, customerTypeID string) ([]*CustomerCustomerDemo, error)

CustomerCustomerDemoByCustomerTypeID retrieves a row from 'northwind.customer_customer_demo' as a CustomerCustomerDemo.

Generated from index 'customer_type_id'.

func (*CustomerCustomerDemo) Customer 

func (ccd *CustomerCustomerDemo) Customer(ctx context.Context, db DB) (*Customer, error)

Customer returns the Customer associated with the CustomerCustomerDemo's (CustomerID).

Generated from foreign key 'customer_customer_demo_ibfk_1'.

func (*CustomerCustomerDemo) CustomerDemographic 

func (ccd *CustomerCustomerDemo) CustomerDemographic(ctx context.Context, db DB) (*CustomerDemographic, error)

CustomerDemographic returns the CustomerDemographic associated with the CustomerCustomerDemo's (CustomerTypeID).

Generated from foreign key 'customer_customer_demo_ibfk_2'.

func (*CustomerCustomerDemo) Delete 

func (ccd *CustomerCustomerDemo) Delete(ctx context.Context, db DB) error

Delete deletes the CustomerCustomerDemo from the database.

func (*CustomerCustomerDemo) Deleted 

func (ccd *CustomerCustomerDemo) Deleted() bool

Deleted returns true when the CustomerCustomerDemo has been marked for deletion from the database.

func (*CustomerCustomerDemo) Exists 

func (ccd *CustomerCustomerDemo) Exists() bool

Exists returns true when the CustomerCustomerDemo exists in the database.

func (*CustomerCustomerDemo) Insert 

func (ccd *CustomerCustomerDemo) Insert(ctx context.Context, db DB) error

Insert inserts the CustomerCustomerDemo to the database.

type CustomerDemographic 

type CustomerDemographic struct {
	CustomerTypeID string         `json:"customer_type_id"` // customer_type_id
	CustomerDesc   sql.NullString `json:"customer_desc"`    // customer_desc
	// contains filtered or unexported fields
}

CustomerDemographic represents a row from 'northwind.customer_demographics'.

func CustomerDemographicByCustomerTypeID 

func CustomerDemographicByCustomerTypeID(ctx context.Context, db DB, customerTypeID string) (*CustomerDemographic, error)

CustomerDemographicByCustomerTypeID retrieves a row from 'northwind.customer_demographics' as a CustomerDemographic.

Generated from index 'customer_demographics_customer_type_id_pkey'.

func (*CustomerDemographic) Delete 

func (cd *CustomerDemographic) Delete(ctx context.Context, db DB) error

Delete deletes the CustomerDemographic from the database.

func (*CustomerDemographic) Deleted 

func (cd *CustomerDemographic) Deleted() bool

Deleted returns true when the CustomerDemographic has been marked for deletion from the database.

func (*CustomerDemographic) Exists 

func (cd *CustomerDemographic) Exists() bool

Exists returns true when the CustomerDemographic exists in the database.

func (*CustomerDemographic) Insert 

func (cd *CustomerDemographic) Insert(ctx context.Context, db DB) error

Insert inserts the CustomerDemographic to the database.

func (*CustomerDemographic) Save 

func (cd *CustomerDemographic) Save(ctx context.Context, db DB) error

Save saves the CustomerDemographic to the database.

func (*CustomerDemographic) Update 

func (cd *CustomerDemographic) Update(ctx context.Context, db DB) error

Update updates a CustomerDemographic in the database.

func (*CustomerDemographic) Upsert 

func (cd *CustomerDemographic) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for CustomerDemographic.

type DB 

type DB interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

DB is the common interface for database operations that can be used with types from schema 'northwind'.

This works with both database/sql.DB and database/sql.Tx.

type Employee 

type Employee struct {
	EmployeeID      int16          `json:"employee_id"`       // employee_id
	LastName        string         `json:"last_name"`         // last_name
	FirstName       string         `json:"first_name"`        // first_name
	Title           sql.NullString `json:"title"`             // title
	TitleOfCourtesy sql.NullString `json:"title_of_courtesy"` // title_of_courtesy
	BirthDate       sql.NullTime   `json:"birth_date"`        // birth_date
	HireDate        sql.NullTime   `json:"hire_date"`         // hire_date
	Address         sql.NullString `json:"address"`           // address
	City            sql.NullString `json:"city"`              // city
	Region          sql.NullString `json:"region"`            // region
	PostalCode      sql.NullString `json:"postal_code"`       // postal_code
	Country         sql.NullString `json:"country"`           // country
	HomePhone       sql.NullString `json:"home_phone"`        // home_phone
	Extension       sql.NullString `json:"extension"`         // extension
	Photo           []byte         `json:"photo"`             // photo
	Notes           sql.NullString `json:"notes"`             // notes
	ReportsTo       sql.NullInt64  `json:"reports_to"`        // reports_to
	PhotoPath       sql.NullString `json:"photo_path"`        // photo_path
	// contains filtered or unexported fields
}

Employee represents a row from 'northwind.employees'.

func EmployeeByEmployeeID 

func EmployeeByEmployeeID(ctx context.Context, db DB, employeeID int16) (*Employee, error)

EmployeeByEmployeeID retrieves a row from 'northwind.employees' as a Employee.

Generated from index 'employees_employee_id_pkey'.

func EmployeesByReportsTo 

func EmployeesByReportsTo(ctx context.Context, db DB, reportsTo sql.NullInt64) ([]*Employee, error)

EmployeesByReportsTo retrieves a row from 'northwind.employees' as a Employee.

Generated from index 'reports_to'.

func (*Employee) Delete 

func (e *Employee) Delete(ctx context.Context, db DB) error

Delete deletes the Employee from the database.

func (*Employee) Deleted 

func (e *Employee) Deleted() bool

Deleted returns true when the Employee has been marked for deletion from the database.

func (*Employee) Employee 

func (e *Employee) Employee(ctx context.Context, db DB) (*Employee, error)

Employee returns the Employee associated with the Employee's (ReportsTo).

Generated from foreign key 'employees_ibfk_1'.

func (*Employee) Exists 

func (e *Employee) Exists() bool

Exists returns true when the Employee exists in the database.

func (*Employee) Insert 

func (e *Employee) Insert(ctx context.Context, db DB) error

Insert inserts the Employee to the database.

func (*Employee) Save 

func (e *Employee) Save(ctx context.Context, db DB) error

Save saves the Employee to the database.

func (*Employee) Update 

func (e *Employee) Update(ctx context.Context, db DB) error

Update updates a Employee in the database.

func (*Employee) Upsert 

func (e *Employee) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Employee.

type EmployeeTerritory 

type EmployeeTerritory struct {
	EmployeeID  int16  `json:"employee_id"`  // employee_id
	TerritoryID string `json:"territory_id"` // territory_id
	// contains filtered or unexported fields
}

EmployeeTerritory represents a row from 'northwind.employee_territories'.

func EmployeeTerritoriesByTerritoryID 

func EmployeeTerritoriesByTerritoryID(ctx context.Context, db DB, territoryID string) ([]*EmployeeTerritory, error)

EmployeeTerritoriesByTerritoryID retrieves a row from 'northwind.employee_territories' as a EmployeeTerritory.

Generated from index 'territory_id'.

func EmployeeTerritoryByEmployeeIDTerritoryID 

func EmployeeTerritoryByEmployeeIDTerritoryID(ctx context.Context, db DB, employeeID int16, territoryID string) (*EmployeeTerritory, error)

EmployeeTerritoryByEmployeeIDTerritoryID retrieves a row from 'northwind.employee_territories' as a EmployeeTerritory.

Generated from index 'employee_territories_employee_id_territory_id_pkey'.

func (*EmployeeTerritory) Delete 

func (et *EmployeeTerritory) Delete(ctx context.Context, db DB) error

Delete deletes the EmployeeTerritory from the database.

func (*EmployeeTerritory) Deleted 

func (et *EmployeeTerritory) Deleted() bool

Deleted returns true when the EmployeeTerritory has been marked for deletion from the database.

func (*EmployeeTerritory) Employee 

func (et *EmployeeTerritory) Employee(ctx context.Context, db DB) (*Employee, error)

Employee returns the Employee associated with the EmployeeTerritory's (EmployeeID).

Generated from foreign key 'employee_territories_ibfk_1'.

func (*EmployeeTerritory) Exists 

func (et *EmployeeTerritory) Exists() bool

Exists returns true when the EmployeeTerritory exists in the database.

func (*EmployeeTerritory) Insert 

func (et *EmployeeTerritory) Insert(ctx context.Context, db DB) error

Insert inserts the EmployeeTerritory to the database.

func (*EmployeeTerritory) Territory 

func (et *EmployeeTerritory) Territory(ctx context.Context, db DB) (*Territory, error)

Territory returns the Territory associated with the EmployeeTerritory's (TerritoryID).

Generated from foreign key 'employee_territories_ibfk_2'.

type ErrInsertFailed 

type ErrInsertFailed struct {
	Err error
}

ErrInsertFailed is the insert failed error.

func (*ErrInsertFailed) Error 

func (err *ErrInsertFailed) Error() string

Error satisfies the error interface.

func (*ErrInsertFailed) Unwrap 

func (err *ErrInsertFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type ErrUpdateFailed 

type ErrUpdateFailed struct {
	Err error
}

ErrUpdateFailed is the update failed error.

func (*ErrUpdateFailed) Error 

func (err *ErrUpdateFailed) Error() string

Error satisfies the error interface.

func (*ErrUpdateFailed) Unwrap 

func (err *ErrUpdateFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type ErrUpsertFailed 

type ErrUpsertFailed struct {
	Err error
}

ErrUpsertFailed is the upsert failed error.

func (*ErrUpsertFailed) Error 

func (err *ErrUpsertFailed) Error() string

Error satisfies the error interface.

func (*ErrUpsertFailed) Unwrap 

func (err *ErrUpsertFailed) Unwrap() error

Unwrap satisfies the unwrap interface.

type Error 

type Error string

Error is an error. 

const (
	// ErrAlreadyExists is the already exists error.
	ErrAlreadyExists Error = "already exists"
	// ErrDoesNotExist is the does not exist error.
	ErrDoesNotExist Error = "does not exist"
	// ErrMarkedForDeletion is the marked for deletion error.
	ErrMarkedForDeletion Error = "marked for deletion"
)

Error values.

func (Error) Error 

func (err Error) Error() string

Error satisfies the error interface.

type Order 

type Order struct {
	OrderID        int16           `json:"order_id"`         // order_id
	CustomerID     sql.NullString  `json:"customer_id"`      // customer_id
	EmployeeID     sql.NullInt64   `json:"employee_id"`      // employee_id
	OrderDate      sql.NullTime    `json:"order_date"`       // order_date
	RequiredDate   sql.NullTime    `json:"required_date"`    // required_date
	ShippedDate    sql.NullTime    `json:"shipped_date"`     // shipped_date
	ShipVia        sql.NullInt64   `json:"ship_via"`         // ship_via
	Freight        sql.NullFloat64 `json:"freight"`          // freight
	ShipName       sql.NullString  `json:"ship_name"`        // ship_name
	ShipAddress    sql.NullString  `json:"ship_address"`     // ship_address
	ShipCity       sql.NullString  `json:"ship_city"`        // ship_city
	ShipRegion     sql.NullString  `json:"ship_region"`      // ship_region
	ShipPostalCode sql.NullString  `json:"ship_postal_code"` // ship_postal_code
	ShipCountry    sql.NullString  `json:"ship_country"`     // ship_country
	// contains filtered or unexported fields
}

Order represents a row from 'northwind.orders'.

func OrderByOrderID 

func OrderByOrderID(ctx context.Context, db DB, orderID int16) (*Order, error)

OrderByOrderID retrieves a row from 'northwind.orders' as a Order.

Generated from index 'orders_order_id_pkey'.

func OrdersByCustomerID 

func OrdersByCustomerID(ctx context.Context, db DB, customerID sql.NullString) ([]*Order, error)

OrdersByCustomerID retrieves a row from 'northwind.orders' as a Order.

Generated from index 'customer_id'.

func OrdersByEmployeeID 

func OrdersByEmployeeID(ctx context.Context, db DB, employeeID sql.NullInt64) ([]*Order, error)

OrdersByEmployeeID retrieves a row from 'northwind.orders' as a Order.

Generated from index 'employee_id'.

func OrdersByShipVia 

func OrdersByShipVia(ctx context.Context, db DB, shipVia sql.NullInt64) ([]*Order, error)

OrdersByShipVia retrieves a row from 'northwind.orders' as a Order.

Generated from index 'ship_via'.

func (*Order) Customer 

func (o *Order) Customer(ctx context.Context, db DB) (*Customer, error)

Customer returns the Customer associated with the Order's (CustomerID).

Generated from foreign key 'orders_ibfk_1'.

func (*Order) Delete 

func (o *Order) Delete(ctx context.Context, db DB) error

Delete deletes the Order from the database.

func (*Order) Deleted 

func (o *Order) Deleted() bool

Deleted returns true when the Order has been marked for deletion from the database.

func (*Order) Employee 

func (o *Order) Employee(ctx context.Context, db DB) (*Employee, error)

Employee returns the Employee associated with the Order's (EmployeeID).

Generated from foreign key 'orders_ibfk_2'.

func (*Order) Exists 

func (o *Order) Exists() bool

Exists returns true when the Order exists in the database.

func (*Order) Insert 

func (o *Order) Insert(ctx context.Context, db DB) error

Insert inserts the Order to the database.

func (*Order) Save 

func (o *Order) Save(ctx context.Context, db DB) error

Save saves the Order to the database.

func (*Order) Shipper 

func (o *Order) Shipper(ctx context.Context, db DB) (*Shipper, error)

Shipper returns the Shipper associated with the Order's (ShipVia).

Generated from foreign key 'orders_ibfk_3'.

func (*Order) Update 

func (o *Order) Update(ctx context.Context, db DB) error

Update updates a Order in the database.

func (*Order) Upsert 

func (o *Order) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Order.

type OrderDetail 

type OrderDetail struct {
	OrderID   int16   `json:"order_id"`   // order_id
	ProductID int16   `json:"product_id"` // product_id
	UnitPrice float32 `json:"unit_price"` // unit_price
	Quantity  int16   `json:"quantity"`   // quantity
	Discount  float32 `json:"discount"`   // discount
	// contains filtered or unexported fields
}

OrderDetail represents a row from 'northwind.order_details'.

func OrderDetailByOrderIDProductID 

func OrderDetailByOrderIDProductID(ctx context.Context, db DB, orderID, productID int16) (*OrderDetail, error)

OrderDetailByOrderIDProductID retrieves a row from 'northwind.order_details' as a OrderDetail.

Generated from index 'order_details_order_id_product_id_pkey'.

func OrderDetailsByProductID 

func OrderDetailsByProductID(ctx context.Context, db DB, productID int16) ([]*OrderDetail, error)

OrderDetailsByProductID retrieves a row from 'northwind.order_details' as a OrderDetail.

Generated from index 'product_id'.

func (*OrderDetail) Delete 

func (od *OrderDetail) Delete(ctx context.Context, db DB) error

Delete deletes the OrderDetail from the database.

func (*OrderDetail) Deleted 

func (od *OrderDetail) Deleted() bool

Deleted returns true when the OrderDetail has been marked for deletion from the database.

func (*OrderDetail) Exists 

func (od *OrderDetail) Exists() bool

Exists returns true when the OrderDetail exists in the database.

func (*OrderDetail) Insert 

func (od *OrderDetail) Insert(ctx context.Context, db DB) error

Insert inserts the OrderDetail to the database.

func (*OrderDetail) Order 

func (od *OrderDetail) Order(ctx context.Context, db DB) (*Order, error)

Order returns the Order associated with the OrderDetail's (OrderID).

Generated from foreign key 'order_details_ibfk_1'.

func (*OrderDetail) Product 

func (od *OrderDetail) Product(ctx context.Context, db DB) (*Product, error)

Product returns the Product associated with the OrderDetail's (ProductID).

Generated from foreign key 'order_details_ibfk_2'.

func (*OrderDetail) Save 

func (od *OrderDetail) Save(ctx context.Context, db DB) error

Save saves the OrderDetail to the database.

func (*OrderDetail) Update 

func (od *OrderDetail) Update(ctx context.Context, db DB) error

Update updates a OrderDetail in the database.

func (*OrderDetail) Upsert 

func (od *OrderDetail) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for OrderDetail.

type Product 

type Product struct {
	ProductID       int16           `json:"product_id"`        // product_id
	ProductName     string          `json:"product_name"`      // product_name
	SupplierID      sql.NullInt64   `json:"supplier_id"`       // supplier_id
	CategoryID      sql.NullInt64   `json:"category_id"`       // category_id
	QuantityPerUnit sql.NullString  `json:"quantity_per_unit"` // quantity_per_unit
	UnitPrice       sql.NullFloat64 `json:"unit_price"`        // unit_price
	UnitsInStock    sql.NullInt64   `json:"units_in_stock"`    // units_in_stock
	UnitsOnOrder    sql.NullInt64   `json:"units_on_order"`    // units_on_order
	ReorderLevel    sql.NullInt64   `json:"reorder_level"`     // reorder_level
	Discontinued    int             `json:"discontinued"`      // discontinued
	// contains filtered or unexported fields
}

Product represents a row from 'northwind.products'.

func ProductByProductID 

func ProductByProductID(ctx context.Context, db DB, productID int16) (*Product, error)

ProductByProductID retrieves a row from 'northwind.products' as a Product.

Generated from index 'products_product_id_pkey'.

func ProductsByCategoryID 

func ProductsByCategoryID(ctx context.Context, db DB, categoryID sql.NullInt64) ([]*Product, error)

ProductsByCategoryID retrieves a row from 'northwind.products' as a Product.

Generated from index 'category_id'.

func ProductsBySupplierID 

func ProductsBySupplierID(ctx context.Context, db DB, supplierID sql.NullInt64) ([]*Product, error)

ProductsBySupplierID retrieves a row from 'northwind.products' as a Product.

Generated from index 'supplier_id'.

func (*Product) Category 

func (p *Product) Category(ctx context.Context, db DB) (*Category, error)

Category returns the Category associated with the Product's (CategoryID).

Generated from foreign key 'products_ibfk_2'.

func (*Product) Delete 

func (p *Product) Delete(ctx context.Context, db DB) error

Delete deletes the Product from the database.

func (*Product) Deleted 

func (p *Product) Deleted() bool

Deleted returns true when the Product has been marked for deletion from the database.

func (*Product) Exists 

func (p *Product) Exists() bool

Exists returns true when the Product exists in the database.

func (*Product) Insert 

func (p *Product) Insert(ctx context.Context, db DB) error

Insert inserts the Product to the database.

func (*Product) Save 

func (p *Product) Save(ctx context.Context, db DB) error

Save saves the Product to the database.

func (*Product) Supplier 

func (p *Product) Supplier(ctx context.Context, db DB) (*Supplier, error)

Supplier returns the Supplier associated with the Product's (SupplierID).

Generated from foreign key 'products_ibfk_1'.

func (*Product) Update 

func (p *Product) Update(ctx context.Context, db DB) error

Update updates a Product in the database.

func (*Product) Upsert 

func (p *Product) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Product.

type Region 

type Region struct {
	RegionID          int16  `json:"region_id"`          // region_id
	RegionDescription string `json:"region_description"` // region_description
	// contains filtered or unexported fields
}

Region represents a row from 'northwind.region'.

func RegionByRegionID 

func RegionByRegionID(ctx context.Context, db DB, regionID int16) (*Region, error)

RegionByRegionID retrieves a row from 'northwind.region' as a Region.

Generated from index 'region_region_id_pkey'.

func (*Region) Delete 

func (r *Region) Delete(ctx context.Context, db DB) error

Delete deletes the Region from the database.

func (*Region) Deleted 

func (r *Region) Deleted() bool

Deleted returns true when the Region has been marked for deletion from the database.

func (*Region) Exists 

func (r *Region) Exists() bool

Exists returns true when the Region exists in the database.

func (*Region) Insert 

func (r *Region) Insert(ctx context.Context, db DB) error

Insert inserts the Region to the database.

func (*Region) Save 

func (r *Region) Save(ctx context.Context, db DB) error

Save saves the Region to the database.

func (*Region) Update 

func (r *Region) Update(ctx context.Context, db DB) error

Update updates a Region in the database.

func (*Region) Upsert 

func (r *Region) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Region.

type Shipper 

type Shipper struct {
	ShipperID   int16          `json:"shipper_id"`   // shipper_id
	CompanyName string         `json:"company_name"` // company_name
	Phone       sql.NullString `json:"phone"`        // phone
	// contains filtered or unexported fields
}

Shipper represents a row from 'northwind.shippers'.

func ShipperByShipperID 

func ShipperByShipperID(ctx context.Context, db DB, shipperID int16) (*Shipper, error)

ShipperByShipperID retrieves a row from 'northwind.shippers' as a Shipper.

Generated from index 'shippers_shipper_id_pkey'.

func (*Shipper) Delete 

func (s *Shipper) Delete(ctx context.Context, db DB) error

Delete deletes the Shipper from the database.

func (*Shipper) Deleted 

func (s *Shipper) Deleted() bool

Deleted returns true when the Shipper has been marked for deletion from the database.

func (*Shipper) Exists 

func (s *Shipper) Exists() bool

Exists returns true when the Shipper exists in the database.

func (*Shipper) Insert 

func (s *Shipper) Insert(ctx context.Context, db DB) error

Insert inserts the Shipper to the database.

func (*Shipper) Save 

func (s *Shipper) Save(ctx context.Context, db DB) error

Save saves the Shipper to the database.

func (*Shipper) Update 

func (s *Shipper) Update(ctx context.Context, db DB) error

Update updates a Shipper in the database.

func (*Shipper) Upsert 

func (s *Shipper) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Shipper.

type Supplier 

type Supplier struct {
	SupplierID   int16          `json:"supplier_id"`   // supplier_id
	CompanyName  string         `json:"company_name"`  // company_name
	ContactName  sql.NullString `json:"contact_name"`  // contact_name
	ContactTitle sql.NullString `json:"contact_title"` // contact_title
	Address      sql.NullString `json:"address"`       // address
	City         sql.NullString `json:"city"`          // city
	Region       sql.NullString `json:"region"`        // region
	PostalCode   sql.NullString `json:"postal_code"`   // postal_code
	Country      sql.NullString `json:"country"`       // country
	Phone        sql.NullString `json:"phone"`         // phone
	Fax          sql.NullString `json:"fax"`           // fax
	Homepage     sql.NullString `json:"homepage"`      // homepage
	// contains filtered or unexported fields
}

Supplier represents a row from 'northwind.suppliers'.

func SupplierBySupplierID 

func SupplierBySupplierID(ctx context.Context, db DB, supplierID int16) (*Supplier, error)

SupplierBySupplierID retrieves a row from 'northwind.suppliers' as a Supplier.

Generated from index 'suppliers_supplier_id_pkey'.

func (*Supplier) Delete 

func (s *Supplier) Delete(ctx context.Context, db DB) error

Delete deletes the Supplier from the database.

func (*Supplier) Deleted 

func (s *Supplier) Deleted() bool

Deleted returns true when the Supplier has been marked for deletion from the database.

func (*Supplier) Exists 

func (s *Supplier) Exists() bool

Exists returns true when the Supplier exists in the database.

func (*Supplier) Insert 

func (s *Supplier) Insert(ctx context.Context, db DB) error

Insert inserts the Supplier to the database.

func (*Supplier) Save 

func (s *Supplier) Save(ctx context.Context, db DB) error

Save saves the Supplier to the database.

func (*Supplier) Update 

func (s *Supplier) Update(ctx context.Context, db DB) error

Update updates a Supplier in the database.

func (*Supplier) Upsert 

func (s *Supplier) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Supplier.

type Territory 

type Territory struct {
	TerritoryID          string `json:"territory_id"`          // territory_id
	TerritoryDescription string `json:"territory_description"` // territory_description
	RegionID             int16  `json:"region_id"`             // region_id
	// contains filtered or unexported fields
}

Territory represents a row from 'northwind.territories'.

func TerritoriesByRegionID 

func TerritoriesByRegionID(ctx context.Context, db DB, regionID int16) ([]*Territory, error)

TerritoriesByRegionID retrieves a row from 'northwind.territories' as a Territory.

Generated from index 'region_id'.

func TerritoryByTerritoryID 

func TerritoryByTerritoryID(ctx context.Context, db DB, territoryID string) (*Territory, error)

TerritoryByTerritoryID retrieves a row from 'northwind.territories' as a Territory.

Generated from index 'territories_territory_id_pkey'.

func (*Territory) Delete 

func (t *Territory) Delete(ctx context.Context, db DB) error

Delete deletes the Territory from the database.

func (*Territory) Deleted 

func (t *Territory) Deleted() bool

Deleted returns true when the Territory has been marked for deletion from the database.

func (*Territory) Exists 

func (t *Territory) Exists() bool

Exists returns true when the Territory exists in the database.

func (*Territory) Insert 

func (t *Territory) Insert(ctx context.Context, db DB) error

Insert inserts the Territory to the database.

func (*Territory) Region 

func (t *Territory) Region(ctx context.Context, db DB) (*Region, error)

Region returns the Region associated with the Territory's (RegionID).

Generated from foreign key 'territories_ibfk_1'.

func (*Territory) Save 

func (t *Territory) Save(ctx context.Context, db DB) error

Save saves the Territory to the database.

func (*Territory) Update 

func (t *Territory) Update(ctx context.Context, db DB) error

Update updates a Territory in the database.

func (*Territory) Upsert 

func (t *Territory) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for Territory.

type UsState 

type UsState struct {
	StateID     int16          `json:"state_id"`     // state_id
	StateName   sql.NullString `json:"state_name"`   // state_name
	StateAbbr   sql.NullString `json:"state_abbr"`   // state_abbr
	StateRegion sql.NullString `json:"state_region"` // state_region
	// contains filtered or unexported fields
}

UsState represents a row from 'northwind.us_states'.

func UsStateByStateID 

func UsStateByStateID(ctx context.Context, db DB, stateID int16) (*UsState, error)

UsStateByStateID retrieves a row from 'northwind.us_states' as a UsState.

Generated from index 'us_states_state_id_pkey'.

func (*UsState) Delete 

func (us *UsState) Delete(ctx context.Context, db DB) error

Delete deletes the UsState from the database.

func (*UsState) Deleted 

func (us *UsState) Deleted() bool

Deleted returns true when the UsState has been marked for deletion from the database.

func (*UsState) Exists 

func (us *UsState) Exists() bool

Exists returns true when the UsState exists in the database.

func (*UsState) Insert 

func (us *UsState) Insert(ctx context.Context, db DB) error

Insert inserts the UsState to the database.

func (*UsState) Save 

func (us *UsState) Save(ctx context.Context, db DB) error

Save saves the UsState to the database.

func (*UsState) Update 

func (us *UsState) Update(ctx context.Context, db DB) error

Update updates a UsState in the database.

func (*UsState) Upsert 

func (us *UsState) Upsert(ctx context.Context, db DB) error

Upsert performs an upsert for UsState.

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.