storage

Documentation

Index

• func TryConvertValue(value any, expectedType DataType) (any, bool)
• type ColumnDef
  • func InferColumnTypes(columns []string, sampleRows [][]any) []ColumnDef
• type DataType
  • func InferType(value any) DataType
• type Storage
• type TypedStorage

Functions

func TryConvertValue

func TryConvertValue(value any, expectedType DataType) (any, bool)

TryConvertValue attempts to convert a value to the expected type Returns (convertedValue, success). If conversion fails, returns (nil, false)

Types

type ColumnDef

type ColumnDef struct {
	Name string
	Type DataType
}

ColumnDef defines a column with its name and inferred type

func InferColumnTypes

func InferColumnTypes(columns []string, sampleRows [][]any) []ColumnDef

InferColumnTypes analyzes sample data to infer the best type for each column It uses the most restrictive type that can represent all values: BIGINT -> DOUBLE -> VARCHAR (BOOLEAN is special-cased)

type DataType

type DataType string

DataType represents the detected type of a column

const (
	TypeVarchar DataType = "VARCHAR"
	TypeBigInt  DataType = "BIGINT"
	TypeDouble  DataType = "DOUBLE"
	TypeBoolean DataType = "BOOLEAN"
)

func InferType

func InferType(value any) DataType

InferType detects the most appropriate data type for a value

type Storage

type Storage interface {
	BuildStructure(string, []string) error
	InsertRow(string, []string, []any) error
	Query(cmd string) (*sql.Rows, error)
	ShowTables() (*sql.Rows, error)
	Close() error
}

Storage is the main interface for data storage operations

type TypedStorage

type TypedStorage interface {
	Storage
	BuildStructureWithTypes(tableName string, columns []ColumnDef) error
	InsertRowWithCoercion(tableName string, columns []string, values []any, columnDefs []ColumnDef) error
}

TypedStorage is an optional interface for storage implementations that support typed columns for better query compatibility