module_model

type ColumnMasking struct {
	MaskingType string
	MaskingRule string
	CustomRule  security_rule.CustomRule
}

type DataSource struct {
	DbAlias                    string                                  `eru:"required"`
	DbType                     string                                  `eru:"required"`
	DbName                     string                                  `eru:"required"`
	DbConfig                   DbConfig                                `eru:"required"`
	SchemaTables               map[string]map[string]TableColsMetaData //tableName is the key
	OtherTables                map[string]map[string]TableColsMetaData `json:"-"` //tableName is the key
	SchemaTablesSecurity       map[string]SecurityRules
	SchemaTablesTransformation map[string]TransformRules
	TableJoins                 map[string]*TableJoins
	Con                        *sqlx.DB `json:"-"`
	ConStatus                  bool
	DbSecurityRules            SecurityRules
}

type DbConfig struct {
	Host          string       `eru:"required"`
	Port          string       `eru:"required"`
	User          string       `eru:"required"`
	Password      string       `eru:"required"`
	DefaultDB     string       `eru:"required"`
	DefaultSchema string       `eru:"required"`
	DriverConfig  DriverConfig `eru:"required"`
	OtherDbConfig OtherDbConfig
}

type DriverConfig struct {
	MaxOpenConns    int           `eru:"required"`
	MaxIdleConns    int           `eru:"required"`
	ConnMaxLifetime time.Duration `eru:"required"`
}

type ModuleProjectI interface {
	CompareProject(ctx context.Context, compareProject Project) (StoreCompare, error)
}

type MutationRecord struct {
	Cols            string
	NonNestedCols   string
	NonNestedValues []interface{}
	UpdatedCols     string
	ColsPlaceholder string
	Values          []interface{}
	ChildRecords    map[string][]MutationRecord
	TableJoins      map[string]TableJoins
	DBQuery         string
}

type MutationResultMaker struct {
	MainTableName   string
	MainAliasName   string
	MutationRecords []MutationRecord
	MutationReturn  MutationReturn
	QueryType       string
	SingleTxn       bool
	OpenTxn         bool
	CloseTxn        bool
	TxnFlag         bool
	IsNested        bool
	DBQuery         string
	PreparedQuery   bool
}

type MutationReturn struct {
	ReturnError      bool
	ReturnDoc        bool
	ReturnErrorAlias string
	ReturnDocAlias   string
	ReturnFields     string
}

type MyQuery struct {
	QueryName    string
	Query        string
	Vars         map[string]interface{}
	QueryType    string
	DBAlias      string
	ReadWrite    string
	Cols         string
	SecurityRule security_rule.SecurityRule
}

type OtherDbConfig struct {
	RowLimit       int
	QueryTimeOut   int
	AllowDropTable bool
}

type Project struct {
	ProjectId       string                 `eru:"required"`
	DataSources     map[string]*DataSource //DB alias is the key
	MyQueries       map[string]*MyQuery    //queryName is key
	ProjectSettings ProjectSettings
}

type ProjectSettings struct {
	AesKey    string
	ClaimsKey string
}

type QueryResultMaker struct {
	QueryLevel    int
	QuerySubLevel []int
	MainTableName string
	MainAliasName string
	Tables        [][]Tables
	SQLQuery      string
}

type SecurityRules struct {
	Create security_rule.SecurityRule
	Drop   security_rule.SecurityRule
	Alter  security_rule.SecurityRule
	Insert security_rule.SecurityRule
	Update security_rule.SecurityRule
	Delete security_rule.SecurityRule
	Select security_rule.SecurityRule
	Query  security_rule.SecurityRule
}

type StoreCompare struct {
	DeleteQueries       []string
	NewQueries          []string
	MismatchQuries      map[string]interface{}
	DeleteDataSources   []string
	NewDataSources      []string
	MismatchDataSources map[string]interface{}
}

type TableColsMetaData struct {
	TblSchema         string `eru:"required"`
	TblName           string `eru:"required"`
	ColName           string `eru:"required"`
	DataType          string
	OwnDataType       string `eru:"required"`
	PrimaryKey        bool   `eru:"required"`
	IsUnique          bool   `eru:"required"`
	PkConstraintName  string
	UqConstraintName  string
	IsNullable        bool `eru:"required"`
	ColPosition       int
	DefaultValue      string
	AutoIncrement     bool
	CharMaxLength     int
	NumericPrecision  string
	NumericScale      int
	DatetimePrecision int
	FkConstraintName  string
	FkDeleteRule      string
	FkTblSchema       string
	FkTblName         string
	FkColName         string
	ColumnMasking     ColumnMasking
}

type TableJoins struct {
	Table1Name       string
	Table1Cols       []string
	Table2Name       string
	Table2Cols       []string
	IsActive         bool
	IsCustom         bool
	ComplexCondition map[string]interface{}
}

type Tables struct {
	Name     string
	Nested   bool
	SqlQuery string
}

type TransformRule struct {
	RuleType string
	ApplyOn  []string
	Rules    []TransformRuleDetail
}

type TransformRuleDetail struct {
	CustomRule         security_rule.CustomRule
	ForceColumnValues  map[string]string
	RemoveColumnValues []string
	ComplexScript      string
	RuleRank           int
}

type TransformRules struct {
	TransformInput  TransformRule
	TransformOutput TransformRule
}