dbase

Apr 8, 2024

Changes in this version

+ const MaxCharacterLength

+ const MaxColumnNameLength

+ const MaxFloatLength

+ const MaxIntegerValue

+ const MaxNumericLength

+ const MinIntegerValue

type Error

+ func NewError(err string) Error

+ func NewErrorf(format string, a ...interface{}) Error

+ func WrapError(err error) Error

+ func (e Error) Details(err error) Error

Aug 21, 2023

Changes in this version

type File

+ func (file *File) Init() error

Aug 18, 2023

Changes in this version

type File

+ func (file *File) TableName() string

Aug 18, 2023

Changes in this version

type Row

+ func (row *Row) BoolValueByName(name string) (bool, error)

+ func (row *Row) BytesValueByName(name string) ([]byte, error)

+ func (row *Row) FloatValueByName(name string) (float64, error)

+ func (row *Row) IntValueByName(name string) (int64, error)

+ func (row *Row) MustBoolValueByName(name string) bool

+ func (row *Row) MustBytesValueByName(name string) []byte

+ func (row *Row) MustFloatValueByName(name string) float64

+ func (row *Row) MustIntValueByName(name string) int64

+ func (row *Row) MustStringValueByName(name string) string

+ func (row *Row) MustTimeValueByName(name string) time.Time

+ func (row *Row) MustValueByName(name string) interface{}

+ func (row *Row) StringValueByName(name string) (string, error)

+ func (row *Row) TimeValueByName(name string) (time.Time, error)

Aug 15, 2023

Changes in this version

+ var ErrUnknownDataType = errors.New("UNKNOWN_DATA_TYPE")

type File

+ func NewTable(version FileVersion, config *Config, columns []*Column, memoBlockSize uint16, ...) (*File, error)

+ func (file *File) Represent(field *Field, skipSpacing bool) ([]byte, error)

Mar 30, 2023

Changes in this version

type Config

+ DisableConvertFilenameUnderscores bool

+ ReadOnly bool

Nov 24, 2022

Changes in this version

type Config

+ IO IO

type UnixIO — darwin/amd64, js/wasm, linux/amd64

+ var DefaultIO UnixIO

type WindowsIO — windows/amd64

+ var DefaultIO WindowsIO

Nov 22, 2022

Changes in this version

+ func ValidateFileVersion(version byte, untested bool) error

type Config

+ CustomIO io.ReadWriteSeeker

type File

+ func (file *File) Create() error

+ func (file *File) GetHandle() (interface{}, interface{})

+ func (file *File) GetIO() IO

+ func (file *File) GetRepresentation(field *Field, skipSpacing bool) ([]byte, error)

+ func (file *File) Interpret(raw []byte, column *Column) (interface{}, error)

+ func (file *File) ReadColumns() ([]*Column, *Column, error)

+ func (file *File) ReadHeader() error

+ func (file *File) ReadMemo(address []byte) ([]byte, bool, error)

+ func (file *File) ReadMemoHeader() error

+ func (file *File) ReadNullFlag(position uint64, column *Column) (bool, bool, error)

+ func (file *File) ReadRow(position uint32) ([]byte, error)

+ func (file *File) WriteColumns() error

+ func (file *File) WriteHeader() error

+ func (file *File) WriteMemo(data []byte, text bool, length int) ([]byte, error)

+ func (file *File) WriteMemoHeader(size int) error

+ func (file *File) WriteRow(row *Row) error

+ type GenericIO struct

+ Handle io.ReadWriteSeeker

+ RelatedHandle io.ReadWriteSeeker

+ func (g GenericIO) Close(file *File) error

+ func (g GenericIO) Create(file *File) error

+ func (g GenericIO) Deleted(file *File) (bool, error)

+ func (g GenericIO) GoTo(file *File, row uint32) error

+ func (g GenericIO) OpenTable(config *Config) (*File, error)

+ func (g GenericIO) ReadColumns(file *File) ([]*Column, *Column, error)

+ func (g GenericIO) ReadHeader(file *File) error

+ func (g GenericIO) ReadMemo(file *File, address []byte) ([]byte, bool, error)

+ func (g GenericIO) ReadMemoHeader(file *File) error

+ func (g GenericIO) ReadNullFlag(file *File, position uint64, column *Column) (bool, bool, error)

+ func (g GenericIO) ReadRow(file *File, position uint32) ([]byte, error)

+ func (g GenericIO) Search(file *File, field *Field, exactMatch bool) ([]*Row, error)

+ func (g GenericIO) Skip(file *File, offset int64)

+ func (g GenericIO) WriteColumns(file *File) error

+ func (g GenericIO) WriteHeader(file *File) error

+ func (g GenericIO) WriteMemo(file *File, raw []byte, text bool, length int) ([]byte, error)

+ func (g GenericIO) WriteMemoHeader(file *File, size int) error

+ func (g GenericIO) WriteRow(file *File, row *Row) error

+ type IO interface

+ Close func(file *File) error

+ Create func(file *File) error

+ Deleted func(file *File) (bool, error)

+ GoTo func(file *File, row uint32) error

+ OpenTable func(config *Config) (*File, error)

+ ReadColumns func(file *File) ([]*Column, *Column, error)

+ ReadHeader func(file *File) error

+ ReadMemo func(file *File, address []byte) ([]byte, bool, error)

+ ReadMemoHeader func(file *File) error

+ ReadNullFlag func(file *File, position uint64, column *Column) (bool, bool, error)

+ ReadRow func(file *File, position uint32) ([]byte, error)

+ Search func(file *File, field *Field, exactMatch bool) ([]*Row, error)

+ Skip func(file *File, offset int64)

+ WriteColumns func(file *File) error

+ WriteHeader func(file *File) error

+ WriteMemo func(file *File, raw []byte, text bool, length int) ([]byte, error)

+ WriteMemoHeader func(file *File, size int) error

+ WriteRow func(file *File, row *Row) error

+ type UnixIO struct — darwin/amd64, js/wasm, linux/amd64

+ func (u UnixIO) Close(file *File) error

+ func (u UnixIO) Create(file *File) error

+ func (u UnixIO) Deleted(file *File) (bool, error)

+ func (u UnixIO) GoTo(file *File, row uint32) error

+ func (u UnixIO) OpenTable(config *Config) (*File, error)

+ func (u UnixIO) ReadColumns(file *File) ([]*Column, *Column, error)

+ func (u UnixIO) ReadHeader(file *File) error

+ func (u UnixIO) ReadMemo(file *File, blockdata []byte) ([]byte, bool, error)

+ func (u UnixIO) ReadMemoHeader(file *File) error

+ func (u UnixIO) ReadNullFlag(file *File, rowPosition uint64, column *Column) (bool, bool, error)

+ func (u UnixIO) ReadRow(file *File, position uint32) ([]byte, error)

+ func (u UnixIO) Search(file *File, field *Field, exactMatch bool) ([]*Row, error)

+ func (u UnixIO) Skip(file *File, offset int64)

+ func (u UnixIO) WriteColumns(file *File) (err error)

+ func (u UnixIO) WriteHeader(file *File) (err error)

+ func (u UnixIO) WriteMemo(file *File, raw []byte, text bool, length int) ([]byte, error)

+ func (u UnixIO) WriteMemoHeader(file *File, size int) (err error)

+ func (u UnixIO) WriteRow(file *File, row *Row) (err error)

+ type WindowsIO struct — windows/amd64

+ func (w WindowsIO) Close(file *File) error

+ func (w WindowsIO) Create(file *File) error

+ func (w WindowsIO) Deleted(file *File) (bool, error)

+ func (w WindowsIO) GoTo(file *File, row uint32) error

+ func (w WindowsIO) OpenTable(config *Config) (*File, error)

+ func (w WindowsIO) ReadColumns(file *File) ([]*Column, *Column, error)

+ func (w WindowsIO) ReadHeader(file *File) error

+ func (w WindowsIO) ReadMemo(file *File, address []byte) ([]byte, bool, error)

+ func (w WindowsIO) ReadMemoHeader(file *File) error

+ func (w WindowsIO) ReadNullFlag(file *File, position uint64, column *Column) (bool, bool, error)

+ func (w WindowsIO) ReadRow(file *File, position uint32) ([]byte, error)

+ func (w WindowsIO) Search(file *File, field *Field, exactMatch bool) ([]*Row, error)

+ func (w WindowsIO) Skip(file *File, offset int64)

+ func (w WindowsIO) WriteColumns(file *File) (err error)

+ func (w WindowsIO) WriteHeader(file *File) (err error)

+ func (w WindowsIO) WriteMemo(file *File, raw []byte, text bool, length int) ([]byte, error)

+ func (w WindowsIO) WriteMemoHeader(file *File, size int) (err error)

+ func (w WindowsIO) WriteRow(file *File, row *Row) (err error)

Nov 6, 2022

Changes in this version

type Row

+ func (row *Row) Increment() error

Nov 4, 2022

Changes in this version

type Row

+ func (row *Row) Struct(v interface{}) error

Oct 21, 2022

Changes in this version

type File

+ func (file *File) Next() (*Row, error)

Oct 17, 2022

Changes in this version

+ func Debug(enabled bool, out io.Writer)

+ func GetErrorTrace(err error) error

type Column

+ func (c *Column) Reflect() reflect.Type

type DataType

+ func (t DataType) Reflect() reflect.Type

type DefaultConverter

+ func ConverterFromCodePage(codePageMark byte) DefaultConverter

+ func (c DefaultConverter) CodePage() byte

type EncodingConverter

+ CodePage func() byte

Oct 17, 2022

Changes in this version

+ func ErrorDetails(err error) error

+ func SetDebug(enabled bool)

+ func SetDebugOutput(out io.Writer)

type Database

+ func OpenDatabase(config *Config) (*Database, error)

+ func (db *Database) Close() error

+ func (db *Database) Names() []string

+ func (db *Database) Schema() map[string][]*Column

+ func (db *Database) Tables() map[string]*File

+ type File struct

+ func OpenTable(config *Config) (*File, error)

+ func (file *File) BOF() bool

+ func (file *File) BytesToRow(data []byte) (*Row, error)

+ func (file *File) Close() error

+ func (file *File) Column(pos int) *Column

+ func (file *File) ColumnNames() []string

+ func (file *File) ColumnPos(column *Column) int

+ func (file *File) ColumnPosByName(colname string) int

+ func (file *File) Columns() []*Column

+ func (file *File) ColumnsCount() uint16

+ func (file *File) Deleted() (bool, error)

+ func (file *File) EOF() bool

+ func (file *File) GetColumnModification(position int) *Modification

+ func (file *File) GoTo(rowNumber uint32) error

+ func (file *File) Header() *Header

+ func (file *File) NewField(pos int, value interface{}) (*Field, error)

+ func (file *File) NewFieldByName(name string, value interface{}) (*Field, error)

+ func (file *File) NewRow() *Row

+ func (file *File) Pointer() uint32

+ func (file *File) Row() (*Row, error)

+ func (file *File) RowFromJSON(j []byte) (*Row, error)

+ func (file *File) RowFromMap(m map[string]interface{}) (*Row, error)

+ func (file *File) RowFromStruct(v interface{}) (*Row, error)

+ func (file *File) Rows(skipInvalid bool, skipDeleted bool) ([]*Row, error)

+ func (file *File) RowsCount() uint32

+ func (file *File) Search(field *Field, exactMatch bool) ([]*Row, error)

+ func (file *File) SetColumnModification(position int, mod *Modification)

+ func (file *File) SetColumnModificationByName(name string, mod *Modification) error

+ func (file *File) Skip(offset int64)

+ func (file *File) WriteLock(enabled bool)

type FileExtension

+ const DBC

+ const DCT

+ const FPT

+ const LBX

+ const MNX

+ const PJX

+ const RPX

+ const SCX

+ const VCX

+ type FileVersion byte

Oct 15, 2022

Changes in this version

type Config

+ InterpretCodePage bool

+ ValidateCodePage bool

+ type DefaultConverter struct

+ func NewDefaultConverter(encoding *charmap.Charmap) DefaultConverter

+ func NewDefaultConverterFromCodePage(codePageMark byte) DefaultConverter

+ func (c DefaultConverter) Decode(in []byte) ([]byte, error)

+ func (c DefaultConverter) Encode(in []byte) ([]byte, error)

+ func (d DefaultConverter) CodePageMark() byte

+ type FileExtension string

+ const DatabaseFileExtension

+ const FormFileExtension

+ const LabelFileExtension

+ const MemoFileExtension

+ const MenuFileExtension

+ const ProjectFileExtension

+ const ReportFileExtension

+ const TableFileExtension

+ const VisualClassLibaryFileExtension

type TableFlag

+ func (t TableFlag) Defined(flag byte) bool

Oct 14, 2022

Changes in this version

type Column

+ FieldName [11]byte

+ func NewColumn(name string, dataType DataType, length uint8, decimals uint8, nullable bool) (*Column, error)

type DBF

+ func New(version FileType, config *Config, columns []*Column, memoBlockSize uint16) (*DBF, error)

type FileType

+ const DBaseMemo

+ const DBaseSQLMemo

+ const DBaseSQLTable

+ const FoxBase

+ const FoxBase2

+ const FoxBasePlus

+ const FoxBasePlusMemo

+ const FoxPro2Memo

Oct 13, 2022

Changes in this version

type Row

+ func (row *Row) ValueByName(name string) (interface{}, error)

Oct 12, 2022

Changes in this version

type Column

+ Flag byte

+ type ColumnFlag byte

+ const AutoincrementFlag

+ const BinaryFlag

+ const HiddenFlag

+ const NullableFlag

+ type FileType byte

+ const FoxProVar

+ type Marker byte

+ type TableFlag byte

Oct 11, 2022

Changes in this version

type DBF

+ func (dbf *DBF) NewFieldByName(name string, value interface{}) (*Field, error)

+ func (dbf *DBF) SetColumnModificationByName(name string, trimspaces bool, key string, ...) error

Oct 11, 2022

Changes in this version

+ const Blob

+ const Character

+ const Currency

+ const DatabaseFlag

+ const Date

+ const DateTime

+ const Double

+ const Float

+ const General

+ const Integer

+ const Logical

+ const MemoFlag

+ const Numeric

+ const Picture

+ const StructuralFlag

+ const StructuralMemoFlag

+ const Varbinary

+ const Varchar

+ type Config struct

+ CodePageValidation bool

+ Converter EncodingConverter

+ Exclusive bool

+ Filename string

+ TrimSpaces bool

+ Untested bool

+ WriteLock bool

+ type DataType byte

+ func (t DataType) String() string

type EncodingConverter

+ CodePageMark func() byte

type Row

+ func (row *Row) FieldByName(name string) (*Field, error)

type Win1250Converter

+ func (d *Win1250Converter) CodePageMark() byte

Oct 10, 2022

Changes in this version

type DBF

+ func (dbf *DBF) Column(pos int) *Column

+ func (dbf *DBF) NewField(pos int, value interface{}) (*Field, error)

+ func (dbf *DBF) Search(field *Field) ([]*Row, error)

type Row

+ ByteOffset int64

Oct 9, 2022

Changes in this version

+ var ErrBOF = errors.New("BOF")

+ var ErrEOF = errors.New("EOF")

+ var ErrIncomplete = errors.New("INCOMPLETE")

+ var ErrInvalidEncoding = errors.New("INVALID_ENCODING")

+ var ErrInvalidPosition = errors.New("INVALID_Position")

+ var ErrNoDBF = errors.New("DBF_FILE_NOT_FOUND")

+ var ErrNoFPT = errors.New("FPT_FILE_NOT_FOUND")

type Error

+ func (e Error) Context() string

+ func (e Error) Error() string

Oct 5, 2022

Changes in this version

type DBF

+ func (dbf *DBF) WriteLock(enabled bool)

Oct 5, 2022

Changes in this version

type DBF

+ func (dbf *DBF) ColumnPosByName(colname string) int

+ func (dbf *DBF) NewRow() *Row

+ func (dbf *DBF) RowFromJSON(j []byte) (*Row, error)

+ func (dbf *DBF) RowFromMap(m map[string]interface{}) (*Row, error)

+ func (dbf *DBF) RowFromStruct(v interface{}) (*Row, error)

+ type Field struct

+ func (field *Field) Column() *Column

+ func (field *Field) GetValue() interface{}

+ func (field *Field) Name() string

+ func (field *Field) SetValue(value interface{})

+ func (field *Field) Type() string

type Header

+ func (h *Header) RecordsCount() uint32

+ type Modification struct

+ Convert func(interface{}) (interface{}, error)

+ ExternalKey string

+ TrimSpaces bool

type Row

+ func (row *Row) Add() error

+ func (row *Row) ChangeField(field *Field) error

+ func (row *Row) Field(pos int) (*Field, error)

+ func (row *Row) Fields() []*Field

+ func (row *Row) ToBytes() ([]byte, error)

+ func (row *Row) Write() error

Sep 27, 2022

Changes in this version

+ const Active

+ const BOF

+ const Blank

+ const ColumnEnd

+ const Database

+ const Deleted

+ const EOF

+ const EOFMarker

+ const FoxPro

+ const FoxProAutoincrement

+ const Incomplete

+ const InvalidEncoding

+ const InvalidPosition

+ const Memo

+ const NoDBF

+ const NoFPT

+ const Null

+ const Structural

+ const StructuralMemo

+ type Error string

+ type Header struct

+ CodePage byte

+ Day uint8

+ FileType byte

+ FirstRow uint16

+ Month uint8

+ Reserved [16]byte

+ RowLength uint16

+ RowsCount uint32

+ TableFlags byte

+ Year uint8

+ func (h *Header) ColumnsCount() uint16

+ func (h *Header) FileSize() int64

+ func (h *Header) Modified() time.Time

Jun 24, 2022

Changes in this version

+ type ColumnModification struct

+ Convert func(interface{}) interface{}

+ ExternalKey string

+ Trimspaces bool

type DBF

+ func (dbf *DBF) GetColumnModification(position int) *ColumnModification

+ func (dbf *DBF) SetColumnModification(position int, trimspaces bool, key string, ...)

+ func (dbf *DBF) SetTrimspacesDefault(b bool)

Jun 23, 2022

Changes in this version

+ const ACTIVE

+ const BLANK

+ const DATABASE

+ const DELETED

+ const END_OF_COLUMN

+ const EOF_MARKER

+ const FOXPRO

+ const FOXPRO_AUTOINCREMENT

+ const MEMO

+ const NULL

+ const STRUCTURAL

+ const STRUCTURAL_MEMO

type DBF

+ func (dbf *DBF) DataToValue(raw []byte, column Column) (interface{}, error)

+ func (dbf *DBF) Pointer() uint32

type DBaseHeader

+ FileType byte

type Row

+ Position uint32

+ func (r *Row) Value(pos int) (interface{}, error)

+ func (r *Row) Values() []interface{}

Jun 22, 2022

Changes in this version

type DBF

+ func (dbf *DBF) Row() (*Row, error)

Jun 22, 2022

Changes in this version

+ func JD2YMD(date int) (int, int, int)

+ func JDToDate(number int) (time.Time, error)

+ func YMD2JD(y, m, d int) int

+ type Column struct

+ ColumnName [11]byte

+ DataType byte

+ Decimals uint8

+ Flags byte

+ Length uint8

+ Next uint32

+ Position uint32

+ Reserved [8]byte

+ Step uint16

+ func (f *Column) Name() string

+ func (f *Column) Type() string

+ type DBF struct

+ func Open(filename string, conv EncodingConverter) (*DBF, error)

+ func (dbf *DBF) BOF() bool

+ func (dbf *DBF) BytesToRow(data []byte) (*Row, error)

+ func (dbf *DBF) Close() error

+ func (dbf *DBF) ColumnDataToValue(raw []byte, columnPosition int) (interface{}, error)

+ func (dbf *DBF) ColumnNames() []string

+ func (dbf *DBF) ColumnPos(colname string) int

+ func (dbf *DBF) Columns() []Column

+ func (dbf *DBF) ColumnsCount() uint16

+ func (dbf *DBF) Deleted() (bool, error)

+ func (dbf *DBF) EOF() bool

+ func (dbf *DBF) GetRow() (*Row, error)

+ func (dbf *DBF) GoTo(rowNumber uint32) error

+ func (dbf *DBF) Header() *DBaseHeader

+ func (dbf *DBF) Rows(skipInvalid bool) ([]*Row, error)

+ func (dbf *DBF) RowsCount() uint32

+ func (dbf *DBF) RowsToJSON(skipInvalid bool, trimspaces bool) ([]byte, error)

+ func (dbf *DBF) RowsToMap(skipInvalid bool) ([]map[string]interface{}, error)

+ func (dbf *DBF) RowsToStruct(v interface{}, skipInvalid bool, trimspaces bool) ([]interface{}, error)

+ func (dbf *DBF) Skip(offset int64) error

+ func (dbf *DBF) Value(columnposition int) (interface{}, error)

+ type DBaseError string

+ const ERROR_BOF

+ const ERROR_EOF

+ const ERROR_INCOMPLETE

+ const ERROR_INVALID

+ const ERROR_INVALID_ENCODING

+ const ERROR_NO_DBF_FILE

+ const ERROR_NO_FPT_FILE

+ func (re DBaseError) AsError() error

+ type DBaseHeader struct

+ CodePage byte

+ Day uint8

+ FileVersion byte

+ FirstRow uint16

+ Month uint8

+ Reserved [16]byte

+ RowLength uint16

+ RowsCount uint32

+ TableFlags byte

+ Year uint8

+ func (h *DBaseHeader) ColumnsCount() uint16

+ func (h *DBaseHeader) FileSize() int64

+ func (h *DBaseHeader) Modified() time.Time

+ type EncodingConverter interface

+ Decode func(in []byte) ([]byte, error)

+ Encode func(in []byte) ([]byte, error)

+ type MemoHeader struct

+ BlockSize uint16

+ NextFree uint32

+ Unused [2]byte

+ type Row struct

+ DBF *DBF

+ Data []interface{}

+ Deleted bool

+ func (r *Row) Column(pos int) (interface{}, error)

+ func (r *Row) ColumnSlice() []interface{}

+ func (rec *Row) ToJSON(trimspaces bool) ([]byte, error)

+ func (rec *Row) ToMap() (map[string]interface{}, error)

+ func (rec *Row) ToStruct(v interface{}, trimspaces bool) error

+ type Table struct

+ type Win1250Converter struct

+ func (d *Win1250Converter) Decode(in []byte) ([]byte, error)

+ func (d *Win1250Converter) Encode(in []byte) ([]byte, error)