cmd

type AccountPrivilege struct {
	User           string
	Host           string
	Grants         []string
	HighRisk       bool
	IsWildcardHost bool
	LastUsed       string
}

type Advice struct {
	Level      string // 高/中/低
	Content    string
	RelatedSQL string
}

type BinlogStats struct {
	TotalCount      int
	InsertCount     int
	UpdateCount     int
	DeleteCount     int
	QueryType       string
	QueryCount      int
	TableName       string
	Timestamp       string
	TransactionSize int   // 事务大小（字节）
	StartPosition   int64 // 事务开始位置
}

type CheckItem struct {
	Title  string
	Anchor string
	SQL    string
}

type Column struct {
	Name        string
	Selectivity float64
	CondType    string
	Source      string
}

type CommandInfo struct {
	Name        string
	Required    bool
	Description string
	InstallCmd  map[string]string // OS -> install command
}

type CommandResult struct {
	Host   string
	Output string
	Error  error
}

type DeployConfig struct {
	MysqlVersion    string
	InstallPrefix   string
	DataDir         string
	ReplicationUser string
	ReplicationPass string
	AdminUser       string
	AdminPass       string
	RootPass        string
	MyCnfTemplate   string
	ServiceTemplate string
	HostFile        string
	Architecture    string
	SSHUser         string
	SSHPort         int
	MySQLPort       int
	MGRGroupName    string
	MGRPort         int
	ForceDownload   bool
	ForceDeploy     bool
	SSHKeyPath      string
	MinimalPackage  bool   // 是否使用minimal安装包
	AppUser         string // 应用账号用户名
	AppPass         string // 应用账号密码
}

type DiagnosticInfo struct {
	OutputDir   string
	MyCnfPath   string
	DataDir     string
	ErrorLog    string
	WarningsLog string
	StartTime   time.Time
}

type HostInfo struct {
	IP       string
	Role     string
	ServerID int
}

type IndexRecommendation struct {
	IndexSQL        string
	SelectivityInfo string
}

type SQLParseResult struct {
	Tables       map[string]string           // alias -> real table name
	TableColumns map[string]*TableColumnInfo // table name -> column info
}

type SSHClient struct {
	Addr    string
	User    string
	KeyPath string
	Client  *ssh.Client
}

type SSHConfig struct {
	HostFile   string
	Command    string
	LocalFile  string
	RemotePath string
	SSHUser    string
	SSHPort    int
	SSHKeyPath string
	Timeout    int
	Parallel   int
}

type TableColumnInfo struct {
	TableName      string
	WhereColumns   []string
	JoinColumns    []string
	GroupByColumns []string
	OrderByColumns []string
	SelectColumns  []string
}

type UserCreateRequest struct {
	Username    string
	Password    string
	Host        string
	Privileges  []string
	RequireSSL  bool
	Description string
}