ekuiper-new/extensions/sqldatabase/sqlgen/sqlgen.go

// Copyright 2022-2023 EMQ Technologies Co., Ltd.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package sqlgen

import (
	"fmt"

	"github.com/lf-edge/ekuiper/pkg/cast"
)

type SqlQueryGenerator interface {
	IndexValuer
	SqlQueryStatement() (string, error)
	UpdateMaxIndexValue(rows map[string]interface{})
}

type IndexValuer interface {
	SetIndexValue(interface{})
	GetIndexValue() interface{}
}

const DATETIME_TYPE = "DATETIME"

type InternalSqlQueryCfg struct {
	Table          string      `json:"table"`
	Limit          int         `json:"limit"`
	IndexField     string      `json:"indexField"`
	IndexValue     interface{} `json:"indexValue"`
	IndexFieldType string      `json:"indexFieldType"`
	DateTimeFormat string      `json:"dateTimeFormat"`
}

func (i *InternalSqlQueryCfg) SetIndexValue(val interface{}) {
	i.IndexValue = val
}

func (i *InternalSqlQueryCfg) GetIndexValue() interface{} {
	return i.IndexValue
}

type TemplateSqlQueryCfg struct {
	TemplateSql    string      `json:"templateSql"`
	IndexField     string      `json:"indexField"`
	IndexValue     interface{} `json:"indexValue"`
	IndexFieldType string      `json:"indexFieldType"`
	DateTimeFormat string      `json:"dateTimeFormat"`
}

func (i *TemplateSqlQueryCfg) SetIndexValue(val interface{}) {
	i.IndexValue = val
}

func (i *TemplateSqlQueryCfg) GetIndexValue() interface{} {
	return i.IndexValue
}

type sqlConfig struct {
	TemplateSqlQueryCfg *TemplateSqlQueryCfg `json:"templateSqlQueryCfg"`
	InternalSqlQueryCfg *InternalSqlQueryCfg `json:"internalSqlQueryCfg"`
}

func (cfg *sqlConfig) Init(props map[string]interface{}) error {
	err := cast.MapToStruct(props, &cfg)
	if err != nil {
		return fmt.Errorf("read properties %v fail with error: %v", props, err)
	}

	if cfg.TemplateSqlQueryCfg == nil && cfg.InternalSqlQueryCfg == nil {
		return fmt.Errorf("read properties %v fail with error: %v", props, err)
	}

	if cfg.TemplateSqlQueryCfg != nil && cfg.TemplateSqlQueryCfg.IndexFieldType == DATETIME_TYPE && cfg.TemplateSqlQueryCfg.DateTimeFormat != "" {
		t, err := cast.InterfaceToTime(cfg.TemplateSqlQueryCfg.IndexValue, cfg.TemplateSqlQueryCfg.DateTimeFormat)
		if err != nil {
			err = fmt.Errorf("TemplateSqlQueryCfg InterfaceToTime datetime convert got error %v", err)
			return err
		}
		cfg.TemplateSqlQueryCfg.IndexValue = t
	}

	if cfg.InternalSqlQueryCfg != nil && cfg.InternalSqlQueryCfg.IndexFieldType == DATETIME_TYPE && cfg.InternalSqlQueryCfg.DateTimeFormat != "" {
		t, err := cast.InterfaceToTime(cfg.InternalSqlQueryCfg.IndexValue, cfg.InternalSqlQueryCfg.DateTimeFormat)
		if err != nil {
			err = fmt.Errorf("InternalSqlQueryCfg InterfaceToTime datetime convert got error %v", err)
			return err
		}
		cfg.InternalSqlQueryCfg.IndexValue = t
	}

	return nil
}

func GetQueryGenerator(driver string, props map[string]interface{}) (SqlQueryGenerator, error) {
	cfg := &sqlConfig{}
	err := cfg.Init(props)
	if err != nil {
		return nil, err
	}

	if cfg.TemplateSqlQueryCfg != nil {
		ge, err := NewTemplateSqlQuery(cfg.TemplateSqlQueryCfg)
		if err != nil {
			return nil, err
		} else {
			return ge, nil
		}
	}

	switch driver {
	case "sqlserver":
		return NewSqlServerQuery(cfg.InternalSqlQueryCfg), nil
	case "godror", "oracle":
		return NewOracleQueryGenerate(cfg.InternalSqlQueryCfg), nil
	default:
		return NewCommonSqlQuery(cfg.InternalSqlQueryCfg), nil
	}
}