constant

const (
	AdapterTypeGORM     = "gorm"
	AdapterTypeSQLX     = "sqlx"
	AdapterTypeDatabase = "database"
	AdapterTypeCustom   = "custom"
)

const (
	DialectMySQL     = "mysql"
	DialectPostgres  = "postgres"
	DialectSQLite    = "sqlite"
	DialectSQLServer = "sqlserver"
)

const (
	ParameterPlaceholder = "?"
	ParameterStyle       = "question"
)

const (
	DefaultPageSize      = 10
	DefaultTimeout       = 30 // seconds
	DefaultMaxPoolSize   = 100
	DefaultMaxIdleConns  = 10
	DefaultCacheTTL      = 3600 // seconds
	DefaultSlowQueryTime = 100  // milliseconds
)

const (
	ConfigKeyShowSQL      = "show_sql"
	ConfigKeyLogLevel     = "log_level"
	ConfigKeyLogFile      = "log_file"
	ConfigKeyMaxRetries   = "max_retries"
	ConfigKeyCacheEnabled = "cache_enabled"
)

const (
	// Operator errors
	ErrUnknownOperator = "unknown operator: %s"

	// Filter errors
	ErrInvalidFilterField = "invalid filter field: %s"
	ErrInvalidFilterValue = "invalid filter value for operator %s"

	// Query errors
	ErrEmptyTable        = "table name cannot be empty"
	ErrInvalidPagination = "invalid pagination parameters"

	// Database errors
	ErrNoDatabaseConnection = "no database connection available"
	ErrTransactionFailed    = "transaction failed: %w"

	// Cache errors
	ErrCacheKeyNotFound = "cache key not found"
	ErrCacheFailed      = "cache operation failed: %w"
)

const (
	// 时间戳字段
	FieldCreatedAt = "created_at"
	FieldUpdatedAt = "updated_at"
	FieldDeletedAt = "deleted_at"

	// 用户信息字段
	FieldCreatedBy = "created_by"
	FieldUpdatedBy = "updated_by"
	FieldDeletedBy = "deleted_by"

	// 版本控制字段
	FieldVersion  = "version"
	FieldRevision = "revision"

	// 通用字段
	FieldID          = "id"
	FieldName        = "name"
	FieldStatus      = "status"
	FieldIsDeleted   = "is_deleted"
	FieldIsActive    = "is_active"
	FieldRemark      = "remark"
	FieldDescription = "description"
)

const (
	DefaultDeletedValue    = 1
	DefaultNotDeletedValue = 0
	DefaultActiveValue     = 1
	DefaultInactiveValue   = 0
)

const (
	// 创建操作钩子
	HookEventBeforeCreate = "before_create"
	HookEventAfterCreate  = "after_create"

	// 更新操作钩子
	HookEventBeforeUpdate = "before_update"
	HookEventAfterUpdate  = "after_update"

	// 删除操作钩子
	HookEventBeforeDelete = "before_delete"
	HookEventAfterDelete  = "after_delete"

	// 查询操作钩子
	HookEventBeforeQuery = "before_query"
	HookEventAfterQuery  = "after_query"

	// 保存操作钩子 (upsert)
	HookEventBeforeSave = "before_save"
	HookEventAfterSave  = "after_save"

	// 批量操作钩子
	HookEventBeforeBatch = "before_batch"
	HookEventAfterBatch  = "after_batch"

	// 事务钩子
	HookEventBeforeTransaction = "before_transaction"
	HookEventAfterTransaction  = "after_transaction"
	HookEventBeforeCommit      = "before_commit"
	HookEventAfterCommit       = "after_commit"
	HookEventBeforeRollback    = "before_rollback"
	HookEventAfterRollback     = "after_rollback"
)

const (
	ComponentCore       = "core"
	ComponentExecutor   = "executor"
	ComponentCompiler   = "compiler"
	ComponentAdapter    = "adapter"
	ComponentRepository = "repository"
	ComponentCache      = "cache"
	ComponentMiddleware = "middleware"
)

const (
	EventQueryStart          = "query_start"
	EventQueryComplete       = "query_complete"
	EventQueryError          = "query_error"
	EventTransactionStart    = "transaction_start"
	EventTransactionCommit   = "transaction_commit"
	EventTransactionRollback = "transaction_rollback"
	EventCacheHit            = "cache_hit"
	EventCacheMiss           = "cache_miss"
)

const (
	ContextKeySQL          = "sql"
	ContextKeyDuration     = "duration"
	ContextKeyRowsAffected = "rows_affected"
	ContextKeyError        = "error"
	ContextKeyComponent    = "component"
)

const (
	MsgQueryExecuted         = "query executed successfully"
	MsgTransactionStarted    = "transaction started"
	MsgTransactionCommitted  = "transaction committed"
	MsgTransactionRolledback = "transaction rolled back"
	MsgCacheMiss             = "cache miss for key: %s"
	MsgCacheHit              = "cache hit for key: %s"
)

const (
	MiddlewareTypeLogging        = "logging"
	MiddlewareTypeMetrics        = "metrics"
	MiddlewareTypeRetry          = "retry"
	MiddlewareTypeTimeout        = "timeout"
	MiddlewareTypeValidation     = "validation"
	MiddlewareTypeCircuitBreaker = "circuit_breaker"
	MiddlewareTypeRateLimit      = "rate_limit"
)

const (
	HookTypeBeforeExecution = "before_execution"
	HookTypeAfterExecution  = "after_execution"
	HookTypeOnError         = "on_error"
)

const (
	DefaultRetryCount              = 3
	DefaultRetryDelay              = 100
	DefaultCircuitBreakerThreshold = 5
	DefaultRateLimit               = 1000
)

const (
	// 基本CRUD操作
	OperationTypeCreate = "create"
	OperationTypeRead   = "read"
	OperationTypeUpdate = "update"
	OperationTypeDelete = "delete"
	OperationTypeUpsert = "upsert"
	OperationTypeQuery  = "query"

	// 批量操作
	OperationTypeBatchInsert = "batch_insert"
	OperationTypeBatchUpdate = "batch_update"
	OperationTypeBatchDelete = "batch_delete"
	OperationTypeBatchUpsert = "batch_upsert"

	// 事务操作
	OperationTypeTransaction = "transaction"
	OperationTypeCommit      = "commit"
	OperationTypeRollback    = "rollback"

	// 其他操作
	OperationTypeCount     = "count"
	OperationTypeExists    = "exists"
	OperationTypeAggregate = "aggregate"
)

const (
	// go-core 兼容
	OP_COMPAT_LT  = "lt"
	OP_COMPAT_GT  = "gt"
	OP_COMPAT_LTE = "lte"
	OP_COMPAT_GTE = "gte"
	OP_COMPAT_EQ  = "eq"
	OP_COMPAT_NEQ = "neq"
	OP_COMPAT_LK  = "lk"
)

const (
	ParamPage     = "page"
	ParamPageSize = "pageSize"
	ParamOffset   = "offset"
	ParamLimit    = "limit"
	ParamSort     = "sort"
	ParamOrder    = "order"
	ParamFilter   = "filter"
	ParamSearch   = "search"
	ParamFields   = "fields"
	ParamInclude  = "include"
	ParamExclude  = "exclude"
)

const (
	ConditionKeyFilters    = "filters"
	ConditionKeyOrders     = "orders"
	ConditionKeyPagination = "pagination"
)

const (
	MinPageNumber = 1
	MinPageSize   = 1
	MaxPageSize   = 1000
	DefaultPage   = 1
)

const (
	OrderASC  = "ASC"
	OrderDESC = "DESC"
)

const (
	SQL_SELECT   = "SELECT"
	SQL_INSERT   = "INSERT INTO"
	SQL_UPDATE   = "UPDATE"
	SQL_DELETE   = "DELETE FROM"
	SQL_WHERE    = "WHERE"
	SQL_AND      = "AND"
	SQL_OR       = "OR"
	SQL_ORDER_BY = "ORDER BY"
	SQL_LIMIT    = "LIMIT"
	SQL_OFFSET   = "OFFSET"
	SQL_DISTINCT = "DISTINCT"
	SQL_GROUP_BY = "GROUP BY"
	SQL_HAVING   = "HAVING"
	SQL_JOIN     = "JOIN"
	SQL_INNER    = "INNER"
	SQL_LEFT     = "LEFT"
	SQL_RIGHT    = "RIGHT"
	SQL_FULL     = "FULL"
)

const (
	ErrFilterFieldEmpty    = "filter field cannot be empty"
	ErrFilterValueNil      = "filter value cannot be nil"
	ErrFilterOperatorEmpty = "filter operator cannot be empty"
)

const (
	ErrOrderFieldEmpty   = "order field cannot be empty"
	ErrOrderValueInvalid = "invalid order value"
)

const (
	ErrPaginationLimitInvalid  = "pagination limit must be positive"
	ErrPaginationOffsetInvalid = "pagination offset must be non-negative"
	ErrPaginationPageInvalid   = "invalid page number (must be positive)"
	ErrPaginationSizeInvalid   = "invalid page size (must be positive)"
)

const (
	ErrQueryNil          = "query cannot be nil"
	ErrQueryFieldEmpty   = "query field cannot be empty"
	ErrQueryConditionNil = "query condition cannot be nil"
)

const (
	ErrOperatorEmpty        = "operator cannot be empty"
	ErrOperatorNotSupported = "operator not supported: %s"
)

const (
	ErrValueNil          = "%s value cannot be nil"
	ErrValueEmpty        = "%s value cannot be empty"
	ErrValueInvalid      = "%s value is invalid"
	ErrValueTypeMismatch = "value type mismatch: expected %s, got %s"
)

const (
	ErrInputInvalid  = "invalid input parameter"
	ErrParamRequired = "parameter %s is required"
	ErrParamInvalid  = "parameter %s is invalid"
)

const DefaultSortOrder = OrderASC

const SortFieldPlaceholder = "%s %s"