package models

//Product is a Postgres table, parts of which are imported from the remote ERP and another remote website.
//All fields of ERPProduct and WebProduct are contained in the Postgres table
type Product struct {
	ERPProduct   //note: embedded ERPProduct.ProductCode is primary key!
	WebProduct
	Culture      string  `json:"culture" pg:"culture"` 
	IsEnabled    bool   `json:"isEnabled,omitempty" pg:"is_enabled"`
}

//ERPProduct represents an ERP product record from the remote SQL Server
type ERPProduct struct {
	ProductCode  string   `json:"productCode" db:"ProductCode" pg:"product_code"` //db tag is for ERP  SQL Server
	Category     string   `json:"categoryCode,omitempty" db:"Category" pg:"category"`
	//...other columns...
}

//Import will connect to the ERP and import an ERPProduct from an SQL Server
func (p *ERPProduct) Import() (error) {
   //code to import and populate p using sqlx
   return nil
}

//WebProduct represents a web product 
type WebProduct struct {
	WebCode         string  `json:"webcode,omitempty" pg:"web_code"`
	WebDescription  string  `json:"webDescription,omitempty" pg:"web_description"`
	Slug            string  `json:"slug,omitempty" pg:"slug"`
	//...other columns...
}

//Import will connect to another remote website and import a WebProduct via an API
func (p *WebProduct) Import() (error) {
   //code to import and populate p 
   return nil
}