parser

type CsvInterface interface {
	SetOptionsRead(opt CsvOptions)
	SetOptionsWrite(opt CsvOptions)
	Marshal(orig interface{}) ([]byte, error)
	MarshalWithoutHeaders(orig interface{}) ([]byte, error)
	Unmarshal(blob []byte, dest interface{}) error
}

type CsvOptions struct {
	Separator  rune
	LazyQuotes bool
}

type ExcelError []struct {
	RowNum   int
	ColNum   int
	Value    string // Old Value
	Position string // "A1, B2, C3"
	Message  string
}

type ExcelHeader struct {
	Parent      string
	ParentValue string
	Name        string
	Value       string
	ColIndex    int
}

type ExcelInput struct {
	SheetName  string
	SheetValue map[string]string
}

type ExcelInterface interface {
	// General Excel
	Unmarshal(ctx context.Context, blob []byte) ([]map[string]string, error)

	// Opiniated Excel
	UnmarshalTransform(ctx context.Context, blob []byte, t Transformer) (ExcelResult, error)
	UnmarshalTransformV2(ctx context.Context, blob []byte, t Transformer) (ExcelResult, error)
	Validate(ctx context.Context, blob []byte, t Transformer) error
	UnmarshalWithAxis(ctx context.Context, blob []byte, t Transformer) (ExcelResult, error)
	UnmarshalTransformMultipleSheet(ctx context.Context, blob []byte, opt ExcelOption) (map[string]ExcelResult, error)
	UnmarshalTransformMultipleSheetV2(ctx context.Context, blob []byte, opt ExcelOption) (map[string]ExcelResult, error)
	UnmarshalTransformYAxis(ctx context.Context, blob []byte, t Transformer) (ExcelResult, error)

	// Generate excel file
	Marshal(ctx context.Context, input []ExcelInput, pathToFile string) error

	WriteReader(ctx context.Context, blob []byte, ioReader io.Writer) error
	InjectValue(ctx context.Context, blob []byte, sheetName string, values map[string]interface{}) ([]byte, error)
}

type ExcelOption struct {
	Type      string        `json:"type"`
	Version   string        `json:"version"`
	Parser    Transformer   `json:"parser"`
	Parsers   []Transformer `json:"parsers"`
	ParserMap map[string]Transformer
}

type ExcelOptions map[string]ExcelOption

type ExcelPoint struct {
	Value    string
	RowNum   int
	ColNum   int
	Position string
}

type ExcelResult struct {
	Header  ExcelResultHeader
	Data    []ExcelResultData
	Details []ExcelResultDetails
}

type ExcelResultData map[string]interface{}

type ExcelResultDetails map[string]ExcelPoint

type ExcelResultHeader map[string]ExcelHeader

type Filter struct {
	ColNum int
	Regex  string // regex -> pass data when regex is matched
}

type JsonInterface interface {
	// Marshal go structs into bytes
	Marshal(orig interface{}) ([]byte, error)
	// Marshal go structs into bytes and validates returned bytes
	MarshalWithSchemaValidation(sch string, orig interface{}) ([]byte, error)
	// Unmarshal bytes into go structs
	Unmarshal(blob []byte, dest interface{}) error
	// Validates input bytes and Unmarshal
	UnmarshalWithSchemaValidation(sch string, blob []byte, dest interface{}) error
}

type JsonOptions struct {
	Config                        jsonConfig
	IndentionStep                 int
	MarshalFloatWith6Digits       bool
	EscapeHTML                    bool
	SortMapKeys                   bool
	UseNumber                     bool
	DisallowUnknownFields         bool
	TagKey                        string
	OnlyTaggedField               bool
	ValidateJSONRawMessage        bool
	ObjectFieldMustBeSimpleString bool
	CaseSensitive                 bool
	// Schema contains schema definitions with key as schema name and value as source path
	// schema sources can be file or URL. Schema definition will be iniatialized during
	// JSON parser object initialization.
	Schema map[string]string
}

type Mapper struct {
	Name        string
	ColNum      int
	Type        string
	Relation    string
	Axis        string
	RelationMap map[string]int64
}

type MapperV2 struct {
	Name        string
	Type        string
	Relation    string
	RelationMap map[string]int64
	Multiple    bool
	MultiColumn bool
	FilterRegex string
	Mappers     []Mapper
}

type MapperYAxis struct {
	KeysColumn []string
	MappersVal map[string]Mapper
}

type Options struct {
	JsonOptions  JsonOptions
	CsvOptions   CsvOptions
	ExcelOptions ExcelOptions
}

type Parser interface {
	JsonParser() JsonInterface
	CsvParser() CsvInterface
	ExcelParser() ExcelInterface
}

type Transformer struct {
	Name            string
	SheetType       string
	SheetName       string
	SheetRegex      string
	SheetSeparators string

	SlicerInitialSkipRows int
	SlicerInitialSkipCols int
	SlicerNumRows         int
	SlicerNumCols         int
	IsDynamicHeader       bool
	Filters               []Filter

	Mappers []Mapper // Beware it's not exactly same number with the excel col number

	MappersV2   map[string]MapperV2
	MapperYAxis MapperYAxis
}