clickhouse

type AdminConfig struct {
	Incremental AdminTableConfig `yaml:"incremental"`
	Scheduled   AdminTableConfig `yaml:"scheduled"`
}

type AdminTableConfig struct {
	Database string `yaml:"database"`
	Table    string `yaml:"table"`
}

type ClientInterface interface {
	// QueryOne executes a query and returns a single result
	QueryOne(ctx context.Context, query string, dest any) error
	// QueryMany executes a query and returns multiple results
	QueryMany(ctx context.Context, query string, dest any) error
	// Execute runs a query without returning results (INSERT, ALTER, etc.)
	Execute(ctx context.Context, query string) error
	// BulkInsert performs a bulk insert operation
	BulkInsert(ctx context.Context, table string, data any) error
	// Start initializes the client
	Start() error
	// Stop closes the client
	Stop() error
}

type Config struct {
	// URL supports multiple formats:
	// - Native: clickhouse://user:pass@host:9000
	// - HTTP: http://user:pass@host:8123
	URL string `yaml:"url" validate:"required"`

	Cluster     string `yaml:"cluster"`
	LocalSuffix string `yaml:"localSuffix"`

	QueryTimeout  time.Duration `yaml:"queryTimeout"`
	InsertTimeout time.Duration `yaml:"insertTimeout"`
	Debug         bool          `yaml:"debug"`

	// Connection pool settings
	MaxOpenConns    int           `yaml:"maxOpenConns"`
	MaxIdleConns    int           `yaml:"maxIdleConns"`
	ConnMaxLifetime time.Duration `yaml:"connMaxLifetime"`

	// TLS settings
	InsecureSkipVerify bool `yaml:"insecureSkipVerify"`

	Admin AdminConfig `yaml:"admin"`
}