db

type AuthorCount struct {
	Author string `json:"author" db:"author"`
	Count  int    `json:"count" db:"cou"`
}

type DatabaseConnectionSecret struct {
	Password string `json:"password"`
	Server   string `json:"server"`
	User     string `json:"user"`
	Database string `json:"database"`
	Port     int
}

type MyDB struct {
	DB   *sql.DB
	Name string
}

type SubredditAvgSentiment struct {
	Name    string  `json:"name" db:"name"`
	Average float32 `json:"average" db:"average"`
}

type SubredditSentiment struct {
	PostSentiment    float64 `json:"postSent" db:"postSent"`
	PostPositive     float64 `json:"postSentPos" db:"postSentPos"`
	PostNegative     float64 `json:"postSentNeg" db:"postSentNeg"`
	PostNeutral      float64 `json:"postSentNeu" db:"postSentNeu"`
	CommentSentiment float64 `json:"commentSent" db:"commentSent"`
	CommentPositive  float64 `json:"commentSentPos" db:"commentSentPos"`
	CommentNegative  float64 `json:"commentSentNeg" db:"commentSentNeg"`
	CommentNeutral   float64 `json:"commentSentNeu" db:"commentSentNeu"`
}

type TopicCount struct {
	Topic string `json:"topic" db:"topic"`
	Count int    `json:"count" db:"cou"`
}