package models

type SdkChanSet struct {
	SdkType 		string 		`gorm:"column:sdk_type;primary_key" json:"sdk_type"`
	ChanNum 		int 		`gorm:"column:chan_num;default:16" json:"chan_num"`
	ConfidenceInc 	int      	`gorm:"column:confidenceInc;default:5" json:"confidenceInc"`
	MinMovePos 		int      	`gorm:"column:minMovePos;default:1" json:"minMovePos"`
}

func (SdkChanSet) TableName() string {
	return "sdk_chan_set"
}

func (scs *SdkChanSet) FindAll() (list []SdkChanSet,err error) {
	if err := db.Table(scs.TableName()).Find(&list).Error; err != nil {
		return []SdkChanSet{}, err
	}
	return list, nil
}

func (scs *SdkChanSet) SelectBySdkType(sdkType string) (exist bool,model SdkChanSet){
	dbSelect := db.Table(scs.TableName()).Where("sdk_type=?",sdkType).First(&model)
	if dbSelect.Error != nil || dbSelect.RowsAffected == 0 {
		return false, model
	}
	return dbSelect.RecordNotFound(), model
}

func (scs *SdkChanSet) Insert() (err error) {
	tx := db.Table(scs.TableName()).Begin()
	if tx.Error != nil {
		return tx.Error
	}

	if err := tx.Create(&scs).Error; err != nil {
		tx.Rollback()
		return err
	}

	err =tx.Commit().Error
	if err == nil{
		return nil
	}
	return err
}

func (scs *SdkChanSet) Update() (b bool, err error) {
	result :=db.Exec("update ? set chan_num=? where sdk_type=?",scs.TableName(), scs.ChanNum, scs.SdkType)
	if result.Error != nil {
		return false, err
	}
	return result.RowsAffected>0,nil
}

func (scs *SdkChanSet) Delete(sdkType string) bool {
	updateResult := db.Exec("delete from ? where sdk_type=?", scs.TableName(),sdkType)
	if updateResult.Error != nil || updateResult.RowsAffected == 0 {
		return false
	}
	return true
}