package models

import "errors"

//报警声音表
type Voice struct {
	Id        string       `gorm:"column:id;primary_key;type:varchar(100);unique;" json:"id"`
	Name 	  string 	   `gorm:"column:name" json:"name"`
	Path 	  string  	   `gorm:"column:path" json:"path"`
}

func (Voice) TableName() string {
	return "voice"
}

func (v *Voice) Insert() (bool,error) {
	var tmp Voice
	if tmp.Exist(v.Name) {
		//return false, errors.New("文件不允许重名")
	}
	result := db.Table(v.TableName()).Create(&v)
	if result.Error != nil {
		return false, result.Error
	}
	if result.RowsAffected > 0 {
		return true, nil
	}
	return false, errors.New("新增失败")
}

func (v *Voice) Update() (bool,error) {
	var tmp Voice
	if tmp.Exist(v.Name) && tmp.Id != v.Id {
		return false, errors.New("同名文件已存在")
	}
	result := db.Table(v.TableName()).Save(&v)
	if result.Error != nil {
		return false, result.Error
	}
	if result.RowsAffected > 0 {
		return true, nil
	}
	return false, errors.New("更新失败")
}

func (v *Voice) Exist(name string) bool {
	dbSelect := db.Table(v.TableName()).Where("name=?", name).First(&v)
	if dbSelect.Error != nil || dbSelect.RowsAffected ==0 {
		return false
	}
	return true
}

func (v *Voice) FindAll() (list []Voice, err error) {
	err = db.Table(v.TableName()).Find(&list).Order("id asc").Error
	if err != nil {
		return nil,err
	}
	return list,nil
}

func (v *Voice) DeleteById(id string) (bool, error) {
	result := db.Exec("delete from "+v.TableName()+" where id=?", id)
	if result.Error !=nil {
		return false, result.Error
	}
	if result.RowsAffected > 0 {
		return true, nil
	}
	return false, errors.New("删除失败")
}