cockroach

Documentation

Index

• type Client
  • func NewClient(dbURL string) *Client
  • func (c *Client) Close()
  • func (c *Client) DoSave(p request.PartNumber) error
• type CockPartNumber
  • func (c CockPartNumber) TableName() string

Types

type Client

type Client struct {
	DB *gorm.DB
}

Although there are many cockroachdb clients with Go, I still want to implement one by myself. Because we only need some very simple usages.

func NewClient

func NewClient(dbURL string) *Client

func (*Client) Close

func (c *Client) Close()

func (*Client) DoSave

func (c *Client) DoSave(p request.PartNumber) error

type CockPartNumber

type CockPartNumber struct {
	ID                int64
	Part              string  `gorm:"column:pro_sno"`
	Cat               string  `gorm:"column:pro_cat"`
	Imag              string  `gorm:"column:pro_img"`
	Promaf            string  `gorm:"column:pro_maf"`
	BaseSalePrice     float64 `gorm:"column:base_sale_price"`
	Stock             int64   `gorm:"column:stock"`
	SupPart           string  `gorm:"column:suppart"`
	Moq               int64   `gorm:"column:moq"`
	Mbuy              float64 `gorm:"column:mbuy"`
	Currency          string  `gorm:"column:currency"`
	KuCunDi           string  `gorm:"column:kucundi"`
	CunHuoWeiZhi      string  `gorm:"column:kucunweizi"`
	BasePurchasePrice float64 `gorm:"column:base_pur_price"`
	PiHao             string  `gorm:"column:pihao"`
	Package           string  `gorm:"column:pkg"`
	Spq               int64   `gorm:"column:spq"`
	FutureCN          string  `gorm:"column:futurecn"`

	Pname               string    `gorm:"column:pname"`
	PurchaseNum1        int64     `gorm:"column:purnum1"`
	PurchaseNum2        int64     `gorm:"column:purnum2"`
	PurchaseNum3        int64     `gorm:"column:purnum3"`
	PurchaseNum4        int64     `gorm:"column:purnum4"`
	PurchaseNum5        int64     `gorm:"column:purnum5"`
	PurchaseNum6        int64     `gorm:"column:purnum6"`
	PurchaseNum7        int64     `gorm:"column:purnum7"`
	PurchaseNum8        int64     `gorm:"column:purnum8"`
	PurchaseNum9        int64     `gorm:"column:purnum9"`
	PurchaseNum10       int64     `gorm:"column:purnum10"`
	SalesUnitPrice1     float64   `gorm:"column:saluprice1"`
	SalesUnitPrice2     float64   `gorm:"column:saluprice2"`
	SalesUnitPrice3     float64   `gorm:"column:saluprice3"`
	SalesUnitPrice4     float64   `gorm:"column:saluprice4"`
	SalesUnitPrice5     float64   `gorm:"column:saluprice5"`
	SalesUnitPrice6     float64   `gorm:"column:saluprice6"`
	SalesUnitPrice7     float64   `gorm:"column:saluprice7"`
	SalesUnitPrice8     float64   `gorm:"column:saluprice8"`
	SalesUnitPrice9     float64   `gorm:"column:saluprice9"`
	SalesUnitPrice10    float64   `gorm:"column:saluprice10"`
	PurchaseUnitPrice1  float64   `gorm:"column:purunit_price1"`
	PurchaseUnitPrice2  float64   `gorm:"column:purunit_price2"`
	PurchaseUnitPrice3  float64   `gorm:"column:purunit_price3"`
	PurchaseUnitPrice4  float64   `gorm:"column:purunit_price4"`
	PurchaseUnitPrice5  float64   `gorm:"column:purunit_price5"`
	PurchaseUnitPrice6  float64   `gorm:"column:purunit_price6"`
	PurchaseUnitPrice7  float64   `gorm:"column:purunit_price7"`
	PurchaseUnitPrice8  float64   `gorm:"column:purunit_price8"`
	PurchaseUnitPrice9  float64   `gorm:"column:purunit_price9"`
	PurchaseUnitPrice10 float64   `gorm:"column:purunit_price10"`
	Comments            string    `gorm:"column:comments"`
	Description         string    `gorm:"column:pro_desc"`
	SaleChannel         string    `gorm:"column:sale_channel"`
	ProductDetail       string    `gorm:"column:pro_detail"`
	Datasheet           string    `gorm:"column:datasheet"`
	Rosh                string    `gorm:"column:rosh"`
	StockBiaoStock      string    `gorm:"column:stock_biao"`
	NotUse1             string    `gorm:"column:not_use1"`
	NotUse2             string    `gorm:"column:not_use2"`
	PartEN              string    `gorm:"column:parten"`
	PromatEN            string    `gorm:"column:promaten"`
	FutureEN            string    `gorm:"column:futureen"`
	DescriptionEN       string    `gorm:"column:descen"`
	LUptime             time.Time `gorm:"column:luptime"`
	// contains filtered or unexported fields
}

CSVPartNumber csvpart

func (CockPartNumber) TableName

func (c CockPartNumber) TableName() string