domain

type AssociationReplacements struct {
	Replacements    interface{}
	AssociationName string
}

type Contact struct {
	gorm.Model
	NodeID uint
	Name   string `gorm:"not null"`
	Email  string `gorm:"not null"`
	Phone  string
}

type Country struct {
	gorm.Model
	Code string `gorm:"type:varchar(4);not null;unique_index"`
	Name string `gorm:"type:varchar(64);not null"`
}

type ForeignKey struct {
	ChildModel  interface{}
	ChildField  string
	ParentTable string
	ParentField string
	OnDelete    string
	OnUpdate    string
}

type HelloRequest struct {
	ID      string
	Version string
	Uptime  int64
	OS      string
	Arch    string
}

type NamedServer struct {
	gorm.Model
	ServerType           string             `gorm:"not null" json:"Type"`
	SpeedTestNetServerID uint               `gorm:"default:null"` // Only needed if ServerType is SpeedTestNetServer
	SpeedTestNetServer   SpeedTestNetServer `json:"-"`
	ServerHost           string             `json:"Host"` // Needed for non-SpeedTestNetServers
	ServerCountry        string             `json:"Country"`
	ServerCountryCode    string             `gorm:"-" json:"CountryCode"` // Only needed if ServerType is SpeedTestNetServer
	Name                 string             `gorm:"not null;unique_index"`
	Description          string
	Notes                string `gorm:"type:varchar(2048)"`
}

type Node struct {
	gorm.Model
	MacAddr             string  `gorm:"type:varchar(32);not null;unique_index"`
	OS                  string  `gorm:"type:varchar(16); not null"`
	Arch                string  `gorm:"type:varchar(8); not null"`
	RunningVersion      Version `gorm:"foreignkey:RunningVersionID"`
	RunningVersionID    uint    `gorm:"default:null"`
	ConfiguredVersion   Version `gorm:"foreignkey:ConfiguredVersionID" json:"-"`
	ConfiguredVersionID uint    `gorm:"default:null"`
	Uptime              int64   `gorm:"default:0"`
	LastSeen            string  `gorm:"type:varchar(64)"`
	FirstSeen           string  `gorm:"type:varchar(64)"`
	Location            string
	Coordinates         string
	Network             string
	IPAddress           string
	Tasks               []Task
	Contacts            []Contact
	Tags                []Tag `gorm:"many2many:node_tags"`
	ConfiguredBy        string
	Nickname            string
	Notes               string
	BusinessStartTime   string `gorm:"type:varchar(5);default:'00:00'"`
	BusinessCloseTime   string `gorm:"type:varchar(5);default:'00:00'"`
}

type NodeConfig struct {
	Version struct {
		Number string
		URL    string
	}
	Tasks []Task
}

type NodeTags struct {
	gorm.Model
	Tag    Node `gorm:"foreignkey:TagID"`
	TagID  uint
	Node   Node `gorm:"foreignkey:NodeID"`
	NodeID uint
}

type ReportingEvent struct {
	gorm.Model
	Node        Node   `gorm:"foreignkey:NodeID" json:"-"`
	NodeID      uint   `gorm:"default:null;unique_index:idx_node_name_date"`
	Timestamp   int64  `gorm:"type:int(11); not null;default:0"`
	Date        string `gorm:"not null;unique_index:idx_node_name_date"`
	Name        string `gorm:"not null;unique_index:idx_node_name_date"`
	Description string `gorm:"type:varchar(2048)"`
}

type ReportingSnapshot struct {
	gorm.Model
	Node                      Node
	NodeID                    uint    `gorm:"default:null"`
	Timestamp                 int64   `gorm:"type:int(11); not null"`
	Interval                  string  `gorm:"not null"`
	UploadAvg                 float64 `gorm:"not null;default:0"`
	UploadMax                 float64 `gorm:"not null;default:0"`
	UploadMin                 float64 `gorm:"not null;default:0"`
	UploadTotal               float64 `gorm:"not null;default:0"`
	DownloadAvg               float64 `gorm:"not null;default:0"`
	DownloadMax               float64 `gorm:"not null;default:0"`
	DownloadMin               float64 `gorm:"not null;default:0"`
	DownloadTotal             float64 `gorm:"not null;default:0"`
	LatencyAvg                float64 `gorm:"not null;default:0"`
	LatencyMax                float64 `gorm:"not null;default:0"`
	LatencyMin                float64 `gorm:"not null;default:0"`
	LatencyTotal              float64 `gorm:"not null;default:0"`
	PacketLossAvg             float64 `gorm:"not null;default:0"`
	PacketLossMax             float64 `gorm:"not null;default:0"`
	PacketLossMin             float64 `gorm:"not null;default:0"`
	PacketLossTotal           float64 `gorm:"not null;default:0"`
	SpeedTestDataPoints       int64   `gorm:"not null;default:0"`
	LatencyDataPoints         int64   `gorm:"not null;default:0"`
	NetworkDowntimeSeconds    int64   `gorm:"not null;default:0"`
	NetworkOutagesCount       int64   `gorm:"not null;default:0"`
	RestartsCount             int64   `gorm:"not null;default:0"`
	BizUploadAvg              float64 `gorm:"not null;default:0"`
	BizUploadMax              float64 `gorm:"not null;default:0"`
	BizUploadMin              float64 `gorm:"not null;default:0"`
	BizUploadTotal            float64 `gorm:"not null;default:0"`
	BizDownloadAvg            float64 `gorm:"not null;default:0"`
	BizDownloadMax            float64 `gorm:"not null;default:0"`
	BizDownloadMin            float64 `gorm:"not null;default:0"`
	BizDownloadTotal          float64 `gorm:"not null;default:0"`
	BizLatencyAvg             float64 `gorm:"not null;default:0"`
	BizLatencyMax             float64 `gorm:"not null;default:0"`
	BizLatencyMin             float64 `gorm:"not null;default:0"`
	BizLatencyTotal           float64 `gorm:"not null;default:0"`
	BizPacketLossAvg          float64 `gorm:"not null;default:0"`
	BizPacketLossMax          float64 `gorm:"not null;default:0"`
	BizPacketLossMin          float64 `gorm:"not null;default:0"`
	BizPacketLossTotal        float64 `gorm:"not null;default:0"`
	BizSpeedTestDataPoints    int64   `gorm:"not null;default:0"`
	BizLatencyDataPoints      int64   `gorm:"not null;default:0"`
	BizNetworkDowntimeSeconds int64   `gorm:"not null;default:0"`
	BizNetworkOutagesCount    int64   `gorm:"not null;default:0"`
	BizRestartsCount          int64   `gorm:"not null;default:0"`
}

type STNetServerList struct {
	Country Country
	Servers []SpeedTestNetServer `xml:"server"`
}

type STNetServerSettings struct {
	ServerLists []STNetServerList `xml:"servers"`
}

type SpeedTestNetServer struct {
	gorm.Model
	Lat         string `xml:"lat,attr"`
	Lon         string `xml:"lon,attr"`
	Name        string `xml:"name,attr"`
	Country     string `xml:"country,attr"`
	CountryCode string `xml:"cc,attr"`
	ServerID    string `xml:"id,attr" gorm:"not null"`
	Host        string `xml:"host,attr" gorm:"not null"`
}

type Tag struct {
	gorm.Model
	Name        string `gorm:"not null;unique_index"`
	Description string `gorm:"not null"`
	Nodes       []Node `gorm:"many2many:node_tags"`
	Users       []User `gorm:"many2many:user_tags"`
}

type Task struct {
	gorm.Model
	NodeID        uint
	Type          string `gorm:"type:varchar(32);not null"`
	Schedule      string `gorm:"not null"`
	NamedServer   NamedServer
	NamedServerID uint `gorm:"default:null"`
	ServerHost    string
	TaskData      TaskData `gorm:"type:text"`
}

type TaskData struct {
	StringValues map[string]string
	IntValues    map[string]int
	FloatValues  map[string]float64
	IntSlices    map[string][]int
}

type TaskLogError struct {
	gorm.Model
	Node                 Node
	NodeID               uint  `gorm:"default:null"`
	Timestamp            int64 `gorm:"type:int(11); not null"`
	ErrorCode            string
	ErrorMessage         string
	NamedServer          NamedServer
	NamedServerID        uint `gorm:"default:null"`
	ServerHost           string
	ServerCountry        string
	ServerName           string
	NodeLocation         string
	NodeCoordinates      string
	NodeNetwork          string
	NodeIPAddress        string
	NodeRunningVersion   Version `gorm:"foreignkey:NodeRunningVersionID"`
	NodeRunningVersionID uint    `gorm:"default:null"`
}

type TaskLogMapper interface {
	GetTaskLogMap() map[string]string
	GetTaskLogKeys() []string
}

type TaskLogNetworkDowntime struct {
	gorm.Model
	Node            Node
	NodeID          uint   `gorm:"default:null"`
	Timestamp       int64  `gorm:"type:int(11); not null;default:0"`
	DowntimeStart   string `gorm:"not null"`
	DowntimeSeconds int64  `gorm:"not null;default:0"`
	NodeNetwork     string
	NodeIPAddress   string
}

type TaskLogPingTest struct {
	gorm.Model
	Node                 Node
	NamedServer          NamedServer
	NodeID               uint    `gorm:"default:null"`
	Timestamp            int64   `gorm:"type:int(11); not null"`
	Latency              float64 `gorm:"not null;default:0"`
	PacketLossPercent    float64 `gorm:"not null;default:0"`
	NamedServerID        uint    `gorm:"default:null"`
	ServerHost           string
	ServerCountry        string
	ServerName           string
	NodeLocation         string
	NodeCoordinates      string
	NodeNetwork          string
	NodeIPAddress        string
	NodeRunningVersion   Version `gorm:"foreignkey:NodeRunningVersionID"`
	NodeRunningVersionID uint    `gorm:"default:null"`
}

type TaskLogRestart struct {
	gorm.Model
	Node      Node
	NodeID    uint  `gorm:"default:null"`
	Timestamp int64 `gorm:"type:int(11); not null"`
}

type TaskLogSpeedTest struct {
	gorm.Model
	Node                 Node
	NamedServer          NamedServer
	NodeID               uint    `gorm:"default:null"`
	Timestamp            int64   `gorm:"type:int(11); not null"`
	Upload               float64 `gorm:"not null;default:0"`
	Download             float64 `gorm:"not null;default:0"`
	NamedServerID        uint    `gorm:"default:null"`
	ServerHost           string
	ServerCountry        string
	ServerCoordinates    string
	ServerName           string
	NodeLocation         string `gorm:"not null"`
	NodeCoordinates      string `gorm:"not null"`
	NodeNetwork          string
	NodeIPAddress        string  `gorm:"not null"`
	NodeRunningVersion   Version `gorm:"foreignkey:NodeRunningVersionID"`
	NodeRunningVersionID uint    `gorm:"default:null"`
}

type User struct {
	gorm.Model
	UUID  string
	Name  string `gorm:"not null"`
	Email string `gorm:"not null;unique_index"`
	Role  string `gorm:"not null"`
	Tags  []Tag  `gorm:"many2many:user_tags"`
}

type UserTags struct {
	gorm.Model
	Tag    Node `gorm:"foreignkey:TagID"`
	TagID  uint
	User   User `gorm:"foreignkey:UserID"`
	UserID uint
}

type Version struct {
	gorm.Model
	Number      string `gorm:"not null;unique_index"`
	Description string `gorm:"not null"`
}