dao

package
v0.0.0-...-5357738 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Feb 6, 2023 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Admin 

type Admin struct {
	Id        int           `json:"id" gorm:"primary_key" description:"自增主键"`
	UserName  string        `json:"user_name" gorm:"column:user_name" description:"管理员用户名"`
	Salt      string        `json:"salt" gorm:"column:salt" description:"盐"`
	Password  string        `json:"password" gorm:"column:password" description:"密码"`
	UpdatedAt time.Time     `json:"update_at" gorm:"column:update_at" description:"更新时间"`
	CreatedAt time.Time     `json:"create_at" gorm:"column:create_at" description:"创建时间"`
	IsDelete  sql.NullInt32 `json:"is_delete" gorm:"column:is_delete" description:"是否删除"`
	GroupId   int           `gorm:"column:group_id;type:int(11)" json:"group_id"`
	InfoId    int           `gorm:"column:info_id;type:int(11);comment:用户信息关联" json:"info_id"`
	Status    int           `gorm:"column:status;type:int(11);comment:在线状态" json:"status"`
	LoginTime time.Time     `gorm:"column:login_time;type:datetime" json:"login_time"`
}

func (*Admin) Find 

func (a *Admin) Find(c *gin.Context, tx *gorm.DB, search *Admin) (*Admin, error)

func (*Admin) LoginCheck 

func (a *Admin) LoginCheck(c *gin.Context, tx *gorm.DB, param *dto.AdminLoginInput) (*Admin, error)

func (*Admin) PageList 

func (a *Admin) PageList(c *gin.Context, tx *gorm.DB, params *dto.GroupUserListInput, groupId int) ([]*Admin, int, error)

func (*Admin) Save 

func (a *Admin) Save(c *gin.Context, tx *gorm.DB) error

func (*Admin) TableName 

func (a *Admin) TableName() string

func (*Admin) UpdateStatus 

func (a *Admin) UpdateStatus(ctx *gin.Context, tx *gorm.DB, info *Admin) error

func (*Admin) Updates 

func (a *Admin) Updates(ctx *gin.Context, tx *gorm.DB) error

type BakHistory 

type BakHistory struct {
	Id         int           `gorm:"primary_key" description:"自增主键"`
	TaskID     int           `gorm:"column:task_id" description:"任务id"`
	Host       string        `gorm:"column:host" description:"主机"`
	DBName     string        `gorm:"column:db_name" description:"库名"`
	OssStatus  int           `gorm:"column:oss_status"  description:"钉钉发送状态"`
	DingStatus int           `gorm:"column:ding_status"  description:"OSS保存状态"`
	BakStatus  int           `gorm:"column:bak_status" description:"备份状态"`
	Msg        string        `gorm:"column:message" description:"消息"`
	FileSize   int           `gorm:"column:file_size" description:"文件大小"`
	FileName   string        `gorm:"column:file_name" description:"文件名"`
	BakTime    time.Time     `gorm:"column:bak_time" description:"备份时间"`
	IsDelete   sql.NullInt32 `gorm:"column:is_delete;type:int(11);NOT NULL" json:"is_delete"`
}

func (*BakHistory) Find 

func (b *BakHistory) Find(c *gin.Context, tx *gorm.DB, search *BakHistory) (*BakHistory, error)

func (*BakHistory) FindAllHistory 

func (b *BakHistory) FindAllHistory(c *gin.Context, tx *gorm.DB, status string) ([]*BakHistory, error)

FindAllHistory 查询所有备份历史记录

func (*BakHistory) FindByDate 

func (b *BakHistory) FindByDate(ctx *gin.Context, tx *gorm.DB, num int) ([]BakHistory, error)

FindByDate 查询7天内数据

func (*BakHistory) PageList 

func (b *BakHistory) PageList(c *gin.Context, tx *gorm.DB, params *dto.HistoryListInput) ([]BakHistory, int, error)

func (*BakHistory) Save 

func (b *BakHistory) Save(c context.Context, tx *gorm.DB) error

func (*BakHistory) TableName 

func (b *BakHistory) TableName() string

func (*BakHistory) Updates 

func (b *BakHistory) Updates(c *gin.Context, tx *gorm.DB) error

type DingDatabase 

type DingDatabase struct {
	Id              int    `gorm:"primary_key" description:"自增主键"`
	TaskID          int    `json:"task_id" gorm:"column:task_id" description:"任务id"`
	IsDingSend      int    `json:"is_ding_send"  gorm:"column:is_ding_send" description:"是否发送钉钉消息"`
	DingAccessToken string `json:"ding_access_token"  gorm:"column:ding_access_token" description:"accessToken"`
	DingSecret      string `json:"ding_secret" gorm:"column:ding_secret" description:"secret"`
}

func (*DingDatabase) Find 

func (s *DingDatabase) Find(c *gin.Context, tx *gorm.DB, search *DingDatabase) (*DingDatabase, error)

func (*DingDatabase) Save 

func (s *DingDatabase) Save(c *gin.Context, tx *gorm.DB) error

func (*DingDatabase) TableName 

func (s *DingDatabase) TableName() string

func (*DingDatabase) Updates 

func (d *DingDatabase) Updates(c *gin.Context, tx *gorm.DB) error

type HostDatabase 

type HostDatabase struct {
	Id         int            `json:"host_id" gorm:"primary_key" description:"自增主键"`
	Host       string         `json:"host" gorm:"column:host" description:"任务id"`
	User       string         `json:"user"  gorm:"column:user" description:"是否发送钉钉消息"`
	Password   string         `json:"password"  gorm:"column:password" description:"accessToken"`
	Content    string         `json:"content" gorm:"column:content"`
	HostStatus int            `json:"host_status" gorm:"column:host_status"`
	IsDeleted  int            `json:"is_deleted" gorm:"column:is_deleted"`
	Type       sql.NullInt32  `gorm:"column:type;type:int(11);default:1;comment:1为mysql;2为elastic" json:"type"`
	Avatar     sql.NullString `gorm:"column:avatar;type:varchar(60);comment:头像" json:"avatar"`
}

func (*HostDatabase) Find 

func (s *HostDatabase) Find(c *gin.Context, tx *gorm.DB, search *HostDatabase) (*HostDatabase, error)

func (*HostDatabase) FindAllHost 

func (s *HostDatabase) FindAllHost(tx *gorm.DB) ([]HostDatabase, error)

func (*HostDatabase) PageList 

func (s *HostDatabase) PageList(c *gin.Context, tx *gorm.DB, params *dto.HostListInput) ([]HostDatabase, int, error)

func (*HostDatabase) Save 

func (s *HostDatabase) Save(c *gin.Context, tx *gorm.DB) error

func (*HostDatabase) TableName 

func (s *HostDatabase) TableName() string

func (*HostDatabase) UpdatesStatus 

func (s *HostDatabase) UpdatesStatus(tx *gorm.DB) error

type JobHistory 

type JobHistory struct {
	ID         int           `gorm:"column:id;type:int(11);AUTO_INCREMENT;primary_key" json:"id"`
	JobType    int           `gorm:"column:job_type;type:int(11);NOT NULL" json:"job_type"`
	JobCycle   string        `gorm:"column:job_cycle;type:varchar(20);NOT NULL" json:"job_cycle"`
	Affected   int           `gorm:"column:affected;type:int(11)" json:"affected"`
	Status     sql.NullInt64 `gorm:"column:status;type:int(11);NOT NULL" json:"status"`
	Message    string        `gorm:"column:message;type:varchar(255)" json:"message"`
	UpdateTime time.Time     `gorm:"column:update_time;type:datetime" json:"update_time"`
}

func (*JobHistory) Find 

func (j *JobHistory) Find(c context.Context, tx *gorm.DB, search *JobHistory) (*JobHistory, error)

func (*JobHistory) Save 

func (j *JobHistory) Save(c context.Context, tx *gorm.DB) error

func (*JobHistory) TableName 

func (j *JobHistory) TableName() string

func (*JobHistory) Updates 

func (j *JobHistory) Updates(c context.Context, tx *gorm.DB) error

type OssDatabase 

type OssDatabase struct {
	Id         int    `gorm:"primary_key" description:"自增主键"`
	TaskID     int    `json:"task_id" gorm:"column:task_id" description:"任务id"`
	IsOssSave  int    `json:"is_oss_save" gorm:"column:is_oss_save" description:"是否保存到oss中 0关闭1开启"`
	OssType    int    `json:"oss_type" gorm:"column:oss_type" description:"oss类型"`
	Endpoint   string `json:"endpoint"  gorm:"column:endpoint" description:"endpoint"`
	OssAccess  string `json:"oss_access"  gorm:"column:oss_access" description:"ossaccess"`
	OssSecret  string `json:"oss_secret"  gorm:"column:oss_secret" description:"secret"`
	BucketName string `json:"bucket_name"  gorm:"column:bucket_name" description:"bucket名字"`
	Directory  string `json:"directory" gorm:"column:directory" description:"目录"`
}

func (*OssDatabase) Find 

func (s *OssDatabase) Find(c *gin.Context, tx *gorm.DB, search *OssDatabase) (*OssDatabase, error)

func (*OssDatabase) Save 

func (s *OssDatabase) Save(c *gin.Context, tx *gorm.DB) error

func (*OssDatabase) TableName 

func (s *OssDatabase) TableName() string

func (*OssDatabase) Updates 

func (d *OssDatabase) Updates(c *gin.Context, tx *gorm.DB) error

type TaskDetail 

type TaskDetail struct {
	Host *HostDatabase `json:"host_info"`
	Info *TaskInfo     `json:"task_info"`
	Ding *DingDatabase `json:"ding"`
	Oss  *OssDatabase  `json:"oss"`
}

type TaskInfo 

type TaskInfo struct {
	Id          int       `gorm:"primary_key" description:"自增主键" json:"task_id"`
	HostID      int       `json:"host_id" gorm:"column:host_id" description:"主机关系id"`
	DBName      string    `json:"db_name" gorm:"column:db_name" description:"备份库名"`
	BackupCycle string    `json:"backup_cycle" gorm:"column:backup_cycle" description:"备份周期"`
	KeepNumber  int       `json:"keep_number"  gorm:"column:keep_number" description:"数据保留周期"`
	IsAllDBBak  int       `json:"is_all_dbbak" gorm:"column:is_all_dbbak" description:"是否全库备份"`
	IsDelete    int       `json:"is_delete" gorm:"column:is_delete" description:"是否删除"`
	Status      int       `json:"status" gorm:"column:status" description:"开关"`
	UpdatedAt   time.Time `json:"updated_at" gorm:"column:updated_at" description:"更新时间"`
	CreatedAt   time.Time `json:"created_at" gorm:"column:created_at" description:"添加时间"`
}

func FindAllStatusUpTask 

func FindAllStatusUpTask(tx *gorm.DB) ([]*TaskInfo, error)

func (*TaskInfo) Find 

func (s *TaskInfo) Find(c *gin.Context, tx *gorm.DB, search *TaskInfo) (*TaskInfo, error)

func (*TaskInfo) FindAllTask 

func (s *TaskInfo) FindAllTask(c *gin.Context, tx *gorm.DB, params *dto.HostIDInput) ([]*TaskInfo, error)

func (*TaskInfo) GroupByHost 

func (t *TaskInfo) GroupByHost(c *gin.Context, tx *gorm.DB) ([]dto.DashServiceStatItemOutput, error)

func (*TaskInfo) PageList 

func (s *TaskInfo) PageList(c *gin.Context, tx *gorm.DB, params *dto.TaskListInput) ([]TaskInfo, int, error)

func (*TaskInfo) Save 

func (s *TaskInfo) Save(c *gin.Context, tx *gorm.DB) error

func (*TaskInfo) TableName 

func (s *TaskInfo) TableName() string

func (*TaskInfo) TaskDetail 

func (s *TaskInfo) TaskDetail(c *gin.Context, tx *gorm.DB, serch *TaskInfo) (*TaskDetail, error)

func (*TaskInfo) Updates 

func (d *TaskInfo) Updates(c *gin.Context, tx *gorm.DB) error

func (*TaskInfo) UpdatesStatus 

func (d *TaskInfo) UpdatesStatus(tx *gorm.DB) error

UpdatesStatus 只更新单个字段

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.