package models

import (
	"basic.com/valib/logger.git"
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
	"strings"
)

var (
	db             *gorm.DB
	DeviceInfo     Device
	IntervalConfig Interval
)

func Init(dbPath string) {
	var err error

	db, err = gorm.Open(sqlite.Open(dbPath), &gorm.Config{})

	if err != nil {
		logger.Debug("db open error ", err)
		return
	}
	_ = db.AutoMigrate(Device{}, Interval{})

	// 添加时间间隔默认数据
	var sqls []string
	sqls = append(sqls, "INSERT INTO t_interval(`id`,`devInfo`,`DevState`) SELECT 'default',1440,10 where not exists (select 1 from t_interval);")
	db.Exec(strings.Join(sqls, ""))

	DeviceInfo.Read()
	IntervalConfig.Read()

	logger.Debug("DeviceInfo:", DeviceInfo, " IntervalConfig", IntervalConfig)
}

func GetDB() *gorm.DB {
	return db
}

func CloseDB() {

}