sqlite3

package
v1.1.1 Latest Latest
Warning

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

 Go to latest Published: Nov 5, 2022 License: MIT Imports: 6 Imported by: 0

Documentation ¶

Overview ¶

Package sqlite3 contains generated code for schema 'northwind.db'.

Index ¶

Constants ¶

This section is empty.

Variables ¶

View Source 
var TimestampFormats = []string{

	"2006-01-02 15:04:05.999999999-07:00",
	"2006-01-02T15:04:05.999999999-07:00",
	"2006-01-02 15:04:05.999999999",
	"2006-01-02T15:04:05.999999999",
	"2006-01-02 15:04:05",
	"2006-01-02T15:04:05",
	"2006-01-02 15:04",
	"2006-01-02T15:04",
	"2006-01-02",
}

TimestampFormats are the timestamp formats used by SQLite3 database drivers to store a time.Time in SQLite3.

The first format in the slice will be used when saving time values into the database. When parsing a string from a timestamp or datetime column, the formats are tried in order.

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   int            `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 'categories'.

func CategoryByCategoryID ¶ 

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

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

Generated from index 'sqlite_autoindex_categories_1'.

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 'customers'.

func CustomerByCustomerID ¶ 

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

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

Generated from index 'sqlite_autoindex_customers_1'.

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 'customer_customer_demo'.

func CustomerCustomerDemoByCustomerIDCustomerTypeID ¶ 

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

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

Generated from index 'sqlite_autoindex_customer_customer_demo_1'.

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_customer_id_fkey'.

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_customer_type_id_fkey'.

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 'customer_demographics'.

func CustomerDemographicByCustomerTypeID ¶ 

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

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

Generated from index 'sqlite_autoindex_customer_demographics_1'.

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.db'.

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

type Employee ¶ 

type Employee struct {
	EmployeeID      int            `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       *Time          `json:"birth_date"`        // birth_date
	HireDate        *Time          `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 'employees'.

func EmployeeByEmployeeID ¶ 

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

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

Generated from index 'sqlite_autoindex_employees_1'.

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_reports_to_fkey'.

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  int    `json:"employee_id"`  // employee_id
	TerritoryID string `json:"territory_id"` // territory_id
	// contains filtered or unexported fields
}

EmployeeTerritory represents a row from 'employee_territories'.

func EmployeeTerritoryByEmployeeIDTerritoryID ¶ 

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

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

Generated from index 'sqlite_autoindex_employee_territories_1'.

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_employee_id_fkey'.

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_territory_id_fkey'.

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 ErrInvalidTime ¶ 

type ErrInvalidTime string

ErrInvalidTime is the invalid Time error.

func (ErrInvalidTime) Error ¶ 

func (err ErrInvalidTime) Error() string

Error satisfies the error 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        int             `json:"order_id"`         // order_id
	CustomerID     sql.NullString  `json:"customer_id"`      // customer_id
	EmployeeID     sql.NullInt64   `json:"employee_id"`      // employee_id
	OrderDate      *Time           `json:"order_date"`       // order_date
	RequiredDate   *Time           `json:"required_date"`    // required_date
	ShippedDate    *Time           `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 'orders'.

func OrderByOrderID ¶ 

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

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

Generated from index 'sqlite_autoindex_orders_1'.

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_customer_id_fkey'.

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_employee_id_fkey'.

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_ship_via_fkey'.

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   int     `json:"order_id"`   // order_id
	ProductID int     `json:"product_id"` // product_id
	UnitPrice float64 `json:"unit_price"` // unit_price
	Quantity  int     `json:"quantity"`   // quantity
	Discount  float64 `json:"discount"`   // discount
	// contains filtered or unexported fields
}

OrderDetail represents a row from 'order_details'.

func OrderDetailByOrderIDProductID ¶ 

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

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

Generated from index 'sqlite_autoindex_order_details_1'.

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_order_id_fkey'.

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_product_id_fkey'.

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       int             `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 'products'.

func ProductByProductID ¶ 

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

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

Generated from index 'sqlite_autoindex_products_1'.

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_category_id_fkey'.

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_supplier_id_fkey'.

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          int    `json:"region_id"`          // region_id
	RegionDescription string `json:"region_description"` // region_description
	// contains filtered or unexported fields
}

Region represents a row from 'region'.

func RegionByRegionID ¶ 

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

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

Generated from index 'sqlite_autoindex_region_1'.

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   int            `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 'shippers'.

func ShipperByShipperID ¶ 

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

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

Generated from index 'sqlite_autoindex_shippers_1'.

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   int            `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 'suppliers'.

func SupplierBySupplierID ¶ 

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

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

Generated from index 'sqlite_autoindex_suppliers_1'.

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             int    `json:"region_id"`             // region_id
	// contains filtered or unexported fields
}

Territory represents a row from 'territories'.

func TerritoryByTerritoryID ¶ 

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

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

Generated from index 'sqlite_autoindex_territories_1'.

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_region_id_fkey'.

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 Time ¶ 

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

Time is a SQLite3 Time that scans for the various timestamps values used by SQLite3 database drivers to store time.Time values.

func NewTime ¶ 

func NewTime(t time.Time) Time

NewTime creates a time.

func (Time) Format ¶ 

func (t Time) Format(layout string) string

Format formats the time.

func (*Time) Parse ¶ 

func (t *Time) Parse(s string) error

Parse attempts to Parse string s to t.

func (*Time) Scan ¶ 

func (t *Time) Scan(v interface{}) error

Scan satisfies the sql.Scanner interface.

func (Time) String ¶ 

func (t Time) String() string

String satisfies the fmt.Stringer interface.

func (Time) Time ¶ 

func (t Time) Time() time.Time

Time returns a time.Time.

func (Time) Value ¶ 

func (t Time) Value() (driver.Value, error)

Value satisfies the sql/driver.Valuer interface.

type UsState ¶ 

type UsState struct {
	StateID     int            `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 'us_states'.

func UsStateByStateID ¶ 

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

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

Generated from index 'sqlite_autoindex_us_states_1'.

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.