package models

import (
	"eta/eta_api/global"
	"eta/eta_api/utils"
)

type EdbImportFail struct {
	Id           int `gorm:"column:id;primaryKey;autoIncrement"`
	ClassifyName string
	Frequency    string
	SecName      string
	Unit         string
	Remark       string
	SysUserId    string
}

func AddEdbImportFail(item *EdbImportFail) (err error) {
	err = global.DbMap[utils.DbNameManualIndex].Create(item).Error
	return
}

// DelEdbImportFail 删除导入失败记录
func DelEdbImportFail(userId int) (err error) {
	sql := `delete from edb_import_fail where sys_user_id=?`
	err = global.DbMap[utils.DbNameManualIndex].Exec(sql, userId).Error
	return
}

// GetEdbImportFailList 获取指标数据导入失败数据
func GetEdbImportFailList(sysUserId int) (items []*EdbImportFail, err error) {
	sql := ` SELECT * FROM edb_import_fail WHERE sys_user_id=? `
	err = global.DbMap[utils.DbNameManualIndex].Raw(sql, sysUserId).Find(&items).Error
	return
}