// Package database define database operation functions
package database

import (
	"context"
	"time"

	"modelRT/orm"

	"github.com/gofrs/uuid"
	"gorm.io/gorm"
	"gorm.io/gorm/clause"
)

// QueryCircuitDiagramComponentFromDB return the result of query circuit diagram component info order by page id from postgresDB
// func QueryCircuitDiagramComponentFromDB(ctx context.Context, tx *gorm.DB, pool *ants.PoolWithFunc) (map[uuid.UUID]string, error) {
// 	var components []orm.Component
// 	// ctx超时判断
// 	cancelCtx, cancel := context.WithTimeout(ctx, 5*time.Second)
// 	defer cancel()

// 	result := tx.WithContext(cancelCtx).Clauses(clause.Locking{Strength: "UPDATE"}).Find(&components)
// 	if result.Error != nil {
// 		logger.Error(ctx, "query circuit diagram component info failed", "error", result.Error)
// 		return nil, result.Error
// 	}

// 	componentTypeMap := make(map[uuid.UUID]string, len(components))
// 	for _, component := range components {
// 		pool.Invoke(config.ModelParseConfig{
// 			ComponentInfo: component,
// 			Ctx:           ctx,
// 		})

// 		componentTypeMap[component.GlobalUUID] = component.GlobalUUID.String()
// 	}
// 	return componentTypeMap, nil
// }

// QueryComponentByUUID return the result of query circuit diagram component info by uuid from postgresDB
func QueryComponentByUUID(ctx context.Context, tx *gorm.DB, uuid uuid.UUID) (orm.Component, error) {
	var component orm.Component
	// ctx超时判断
	cancelCtx, cancel := context.WithTimeout(ctx, 5*time.Second)
	defer cancel()
	result := tx.WithContext(cancelCtx).
		Where("global_uuid = ?", uuid).
		Clauses(clause.Locking{Strength: "UPDATE"}).
		First(&component)

	if result.Error != nil {
		return orm.Component{}, result.Error
	}
	return component, nil
}

// QueryComponentByPageID return the result of query circuit diagram component info by page id from postgresDB
func QueryComponentByPageID(ctx context.Context, tx *gorm.DB, uuid uuid.UUID) (orm.Component, error) {
	var component orm.Component
	// ctx超时判断
	cancelCtx, cancel := context.WithTimeout(ctx, 5*time.Second)
	defer cancel()

	result := tx.WithContext(cancelCtx).Where("page_id = ? ", uuid).Clauses(clause.Locking{Strength: "UPDATE"}).Find(&component)
	if result.Error != nil {
		return orm.Component{}, result.Error
	}
	return component, nil
}

// QueryComponentByNsPath return the result of query circuit diagram component info by ns path from postgresDB
func QueryComponentByNsPath(ctx context.Context, tx *gorm.DB, nsPath string) (orm.Component, error) {
	var component orm.Component
	// ctx超时判断
	cancelCtx, cancel := context.WithTimeout(ctx, 5*time.Second)
	defer cancel()

	result := tx.WithContext(cancelCtx).Where("NAME = ? ", nsPath).Clauses(clause.Locking{Strength: "UPDATE"}).Find(&component)
	if result.Error != nil {
		return orm.Component{}, result.Error
	}
	return component, nil
}