package models

import (
	"fmt"
	"go_mqtt/mydb"
	"time"
)

type Temperature struct {
	Id           int64 `gorm:"primaryKey;autoIncrement"`
	CreateDate   time.Time
	DataDate     string `gorm:"index:idx_dataDate;index:data_date_location_desc;size:20"`
	DataHour     string `gorm:"index:idx_dataHour;size:20"`
	DataMinute   string `gorm:"index:idx_dataMinute;size:20"`
	Humidity     string `gorm:"size:10"`
	LocationDesc string `gorm:"index:idx_locationDesc;index:data_date_location_desc;size:80"`
	Temperature  string `gorm:"size:10"`
	Topic        string `gorm:"size:60"`
}

func init() {
	fmt.Println("Temperature init()")
	mydb.DB.AutoMigrate(&Temperature{})
}

// TableName 会将 User 的表名重写为 `user`
func (Temperature) TableName() string {
	return "temperature"
}

func SaveTemperature(temperature *Temperature) {
	result := mydb.DB.Create(&temperature)
	if result.Error != nil {
		fmt.Println("Failed to create Temperature:", result.Error)
	} else {
		fmt.Println("Temperature created successfully!")
	}
}