dbEngine

May 22, 2024

Changes in this version

+ var RegAlreadyExists = regexp.MustCompile(`(\w+)\s+"(\w+)"(\.+"(\w+)")?\s+already\s+exists`)

May 20, 2024

Changes in this version

type FlagColumn

+ func (f FlagColumn) String() string

Apr 2, 2024

Changes in this version

type CfgDB

+ Excluded []string

+ Included []string

Dec 8, 2023

Changes in this version

type Index

+ Where string

+ func (ind *Index) AddColumn(name string) bool

Sep 8, 2023

Changes in this version

type FlagColumn

+ const ChgToArray

type NumberColumn

+ func (c *NumberColumn) Table() Table

+ func (c *NumberColumn) UserDefinedType() *Types

May 12, 2023

Changes in this version

type FlagColumn

+ const ChgLength

+ const ChgType

Nov 22, 2022

Changes in this version

+ type ErrNotFoundType struct

+ Name string

+ Type string

+ func NewErrNotFoundType(name string, sType string) *ErrNotFoundType

+ func (err ErrNotFoundType) Error() string

type Types

+ func NewTypes() *Types

+ type TypesAttr struct

+ IsNotNull bool

+ Name string

+ Type string

+ func (dst *TypesAttr) DecodeText(ci *pgtype.ConnInfo, src []byte) error

+ type TypesAttrs []TypesAttr

+ func (dst *TypesAttrs) DecodeText(ci *pgtype.ConnInfo, src []byte) error

Oct 10, 2022

Changes in this version

type Column

+ Table func() Table

+ UserDefinedType func() *Types

type ForeignKey

+ ForeignCol Column

type StringColumn

+ func (s *StringColumn) Table() Table

+ func (s *StringColumn) UserDefinedType() *Types

type Types

+ Enumerates []string

+ Type rune

+ func (t *Types) GetFields(columns []Column) []interface{}

Aug 18, 2022

Changes in this version

type TableString

+ Rows [][]string

+ func NewTableString(name string, comment string, columns []Column, indexes Indexes, ...) *TableString

May 2, 2022

Changes in this version

+ const RECREATE_MATERIAZE_VIEW

+ type CfgCreatorDB struct

+ RecreateMaterView *struct{}

type CfgDB

+ CfgCreator *CfgCreatorDB

Apr 20, 2022

Changes in this version

type BuildSqlOptions

+ func Args(args ...interface{}) BuildSqlOptions

Apr 2, 2022

Changes in this version

+ type FlagColumn uint8

+ const ChangeLength

+ const ChangeType

+ const MustNotNull

+ const Nullable

Mar 24, 2022

Changes in this version

+ func IsErrorNullValues(err error) bool

Feb 22, 2022

Changes in this version

type NumberColumn

+ func (c *NumberColumn) Foreign() *ForeignKey

Jan 26, 2022

Changes in this version

type DB

+ FuncsAdded []string

+ FuncsReplaced []string

Jan 14, 2022

Changes in this version

+ const DB_SETTING

+ type CfgDB struct

+ GetSchema *struct{}

+ PathCfg *string

+ TestInit *string

+ Url string

+ type TypeCfgDB string

Dec 20, 2021

Changes in this version

+ func IsErrorDuplicated(err error) (map[string]string, bool)

Nov 17, 2021

Changes in this version

type BuildSqlOptions

+ func ColumnsForInsert(columns ...string) BuildSqlOptions

+ func ValuesForInsert(values ...interface{}) BuildSqlOptions

Nov 30, 2021

Changes in this version

type DB

+ DbSet map[string]*string

+ Name string

+ Schema string

type ParserTableDDL

+ DB *DB

Nov 25, 2021

Changes in this version

+ const DB_TEST_INIT

+ func IsErrorDoesNotExists(err error) bool

type BuildSqlOptions

+ func Columns(columns ...string) BuildSqlOptions

+ func Values(values ...interface{}) BuildSqlOptions

Nov 12, 2021

Changes in this version

+ const DB_GET_SCHEMA

+ const DB_URL

Aug 18, 2021

Changes in this version

type Routine

+ ReturnType func() string

Aug 11, 2021

Changes in this version

type Connection

+ SelectAndPerformRaw func(ctx context.Context, each FncRawRow, sql string, args ...interface{}) error

+ type FncRawRow func(values [][]byte, columns []Column) error

Jun 19, 2021

Changes in this version

type Column

+ Foreign func() *ForeignKey

+ type ForeignKey struct

+ Column string

+ DeleteRule string

+ Parent string

+ UpdateRule string

type StringColumn

+ func (c *StringColumn) Foreign() *ForeignKey

Jun 2, 2021

Changes in this version

type SQLBuilder

+ func (b SQLBuilder) DeleteSql() (string, error)

type Table

+ Delete func(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

type TableString

+ func (t TableString) Delete(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

May 8, 2021

Changes in this version

+ const DB_MIGRATION

Feb 28, 2021

Changes in this version

type Column

+ func CheckColumn(ddl string, table Table) (col Column, trueColumn bool)

type Index

+ Expr string

+ Unique bool

type Indexes

+ func (i Indexes) LastIndex() *Index

type Table

+ Indexes func() Indexes

type TableString

+ func (t TableString) Indexes() Indexes

Feb 12, 2021

Changes in this version

type SQLBuilder

+ func NewSQLBuilder(t Table, Options ...BuildSqlOptions) (*SQLBuilder, error)

Jan 17, 2021

Changes in this version

type BuildSqlOptions

+ func FetchOnlyRows(i int) BuildSqlOptions

+ func Offset(i int) BuildSqlOptions

type SQLBuilder

+ Limit int

+ Offset int

Dec 29, 2020

Changes in this version

type Routine

+ BuildSql func(Options ...BuildSqlOptions) (string, []interface{}, error)

Dec 22, 2020

Changes in this version

type Routine

+ Overlay func() Routine

+ SelectOneAndScan func(ctx context.Context, row interface{}, Options ...BuildSqlOptions) error

Dec 15, 2020

Changes in this version

type TableString

+ func (t TableString) SelectOneAndScan(ctx context.Context, row interface{}, Options ...BuildSqlOptions) error

Nov 25, 2020

Changes in this version

+ var ErrDBNotFound = errors.New("DB not found")

+ func IsErrorAlreadyExists(err error) bool

+ func IsErrorCntChgView(err error) bool

+ func IsErrorForReplace(err error) bool

type Index

+ func (ind *Index) GetFields(columns []Column) []interface{}

+ type Indexes []*Index

+ func (i *Indexes) GetFields(columns []Column) []interface{}

Nov 10, 2020

Changes in this version

+ type TableString struct

+ func (t TableString) Columns() []Column

+ func (t TableString) Comment() string

+ func (t TableString) FindColumn(name string) Column

+ func (t TableString) FindIndex(name string) *Index

+ func (t TableString) GetColumns(ctx context.Context) error

+ func (t TableString) Insert(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

+ func (t TableString) Name() string

+ func (t TableString) ReReadColumn(name string) Column

+ func (t TableString) Select(ctx context.Context, Options ...BuildSqlOptions) error

+ func (t TableString) SelectAndRunEach(ctx context.Context, each FncEachRow, Options ...BuildSqlOptions) error

+ func (t TableString) SelectAndScanEach(ctx context.Context, each func() error, rowValue RowScanner, ...) error

+ func (t TableString) Update(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

+ func (t TableString) Upsert(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

Nov 2, 2020

Changes in this version

type Connection

+ LastRowAffected func() int64

type ErrUnknownSql

+ Msg string

Oct 27, 2020

Changes in this version

type DB

+ func (db *DB) ReadViewSQL(path string, info os.FileInfo, err error) error

Oct 15, 2020

Changes in this version

type Table

+ SelectOneAndScan func(ctx context.Context, row interface{}, Options ...BuildSqlOptions) error

Aug 22, 2020

Changes in this version

type BuildSqlOptions

+ func OrderBy(columns ...string) BuildSqlOptions

type SQLBuilder

+ OrderBy []string

Aug 11, 2020

Changes in this version

type Column

+ SetDefault func(string)

type NumberColumn

+ func (s *NumberColumn) SetDefault(str string)

type StringColumn

+ func (s *StringColumn) SetDefault(str string)

Aug 5, 2020

Changes in this version

type ErrNotFoundTable

+ func NewErrNotFoundTable(table string) *ErrNotFoundTable

Aug 4, 2020

Changes in this version

type SQLBuilder

+ func (b *SQLBuilder) SetUpsert() string

Aug 4, 2020

Changes in this version

type ErrUnknownSql

+ Line int

Aug 4, 2020

Changes in this version

+ type ErrUnknownSql struct

+ func NewErrUnknownSql(typeName, name, attr string) *ErrUnknownSql

+ func (err ErrUnknownSql) Error() string

Jul 31, 2020

Changes in this version

type Table

+ ReReadColumn func(name string) Column

+ type Types struct

+ Attr []string

+ Id int

+ Name string

Jul 25, 2020

Changes in this version

type Connection

+ SelectOneAndScan func(ctx context.Context, sql string, args ...interface{}) error

+ SelectToMap func(ctx context.Context, sql string, args ...interface{}) (map[string]interface{}, error)

+ SelectToMaps func(ctx context.Context, sql string, args ...interface{}) ([]map[string]interface{}, error)

+ SelectToMultiDimension func(ctx context.Context, sql string, args ...interface{}) ([][]interface{}, []Column, error)

+ type ErrNotFoundRoutine struct

+ Name string

+ SName string

+ func (err ErrNotFoundRoutine) Error() string

Jul 23, 2020

Changes in this version

type Connection

+ SelectAndRunEach func(ctx context.Context, each FncEachRow, Options ...BuildSqlOptions) error

+ SelectAndScanEach func(ctx context.Context, each func() error, rowValue RowScanner, ...) error

Jul 23, 2020

Changes in this version

type Routine

+ SelectAndRunEach func(ctx context.Context, each FncEachRow, Options ...BuildSqlOptions) error

+ SelectAndScanEach func(ctx context.Context, each func() error, rowValue RowScanner, ...) error

Jul 23, 2020

Changes in this version

type DB

+ Types map[string]string

Jul 23, 2020

Changes in this version

type Connection

+ GetRoutines func(ctx context.Context) (map[string]Routine, error)

+ type ErrWrongType struct

+ Attr string

+ Name string

+ TypeName string

+ func NewErrWrongType(typeName, name, attr string) *ErrWrongType

+ func (err ErrWrongType) Error() string

type ParserTableDDL

+ func NewParserTableDDL(table Table, db *DB) ParserTableDDL

Jul 20, 2020

Changes in this version

type Table

+ Comment func() string

Jul 7, 2020

Changes in this version

+ type BuildSqlOptions func(b *SQLBuilder) error

+ func ArgsForSelect(args ...interface{}) BuildSqlOptions

+ func ColumnsForSelect(columns ...string) BuildSqlOptions

+ func InsertOnConflict(onConflict string) BuildSqlOptions

+ func InsertOnConflictDoNothing(onConflict string) BuildSqlOptions

+ func WhereForSelect(columns ...string) BuildSqlOptions

+ type Column interface

+ AutoIncrement func() bool

+ BasicType func() types.BasicKind

+ BasicTypeInfo func() types.BasicInfo

+ CharacterMaximumLength func() int

+ CheckAttr func(fieldDefine string) string

+ Comment func() string

+ Default func() string

+ IsNullable func() bool

+ Name func() string

+ Primary func() bool

+ Required func() bool

+ SetNullable func(bool)

+ Type func() string

+ func SimpleColumns(names ...string) []Column

+ type Connection interface

+ ExecDDL func(ctx context.Context, sql string, args ...interface{}) error

+ GetSchema func(ctx context.Context) (map[string]Table, map[string]Routine, error)

+ GetStat func() string

+ InitConn func(ctx context.Context, dbURL string) error

+ NewTable func(name, typ string) Table

+ type DB struct

+ Cfg map[string]interface{}

+ Conn Connection

+ Routines map[string]Routine

+ Tables map[string]Table

+ func NewDB(ctx context.Context, conn Connection) (*DB, error)

+ func (db *DB) ReadTableSQL(path string, info os.FileInfo, err error) error

+ type ErrNotFoundColumn struct

+ Column string

+ Table string

+ func NewErrNotFoundColumn(table string, column string) *ErrNotFoundColumn

+ func (err ErrNotFoundColumn) Error() string

+ type ErrNotFoundTable struct

+ Table string

+ func (err ErrNotFoundTable) Error() string

+ type ErrWrongArgsLen struct

+ Args []interface{}

+ Filter []string

+ Table string

+ func NewErrWrongArgsLen(table string, column []string, args []interface{}) *ErrWrongArgsLen

+ func (err ErrWrongArgsLen) Error() string

+ type FncEachRow func(values []interface{}, columns []Column) error

+ type Index struct

+ Columns []string

+ Name string

+ type NumberColumn struct

+ func NewNumberColumn(name, comment string, req bool) *NumberColumn

+ func (c *NumberColumn) AutoIncrement() bool

+ func (c *NumberColumn) BasicType() types.BasicKind

+ func (c *NumberColumn) BasicTypeInfo() types.BasicInfo

+ func (c *NumberColumn) CharacterMaximumLength() int

+ func (c *NumberColumn) CheckAttr(fieldDefine string) string

+ func (c *NumberColumn) Comment() string

+ func (c *NumberColumn) Default() string

+ func (c *NumberColumn) IsNullable() bool

+ func (c *NumberColumn) Name() string

+ func (c *NumberColumn) Primary() bool

+ func (c *NumberColumn) Required() bool

+ func (c *NumberColumn) SetNullable(f bool)

+ func (c *NumberColumn) Type() string

+ type ParserTableDDL struct

+ func NewtableParser(table Table, db *DB) ParserTableDDL

+ func (p ParserTableDDL) Parse(ddl string) error

+ type Routine interface

+ Call func(ctx context.Context)

+ Name func() string

+ Params func()

+ Select func(ctx context.Context, args ...interface{}) error

+ type RowScanner interface

+ GetFields func([]Column) []interface{}

+ type SQLBuilder struct

+ Args []interface{}

+ SelectColumns []Column

+ Table Table

+ func (b *SQLBuilder) OnConflict() string

+ func (b *SQLBuilder) Select() string

+ func (b *SQLBuilder) Set() string

+ func (b *SQLBuilder) Where() string

+ func (b SQLBuilder) InsertSql() (string, error)

+ func (b SQLBuilder) SelectSql() (string, error)

+ func (b SQLBuilder) UpdateSql() (string, error)

+ func (b SQLBuilder) UpsertSql() (string, error)

+ type StringColumn struct

+ func NewStringColumn(name, comment string, req bool) *StringColumn

+ func (c *StringColumn) IsNullable() bool

+ func (c *StringColumn) SetNullable(f bool)

+ func (s *StringColumn) AutoIncrement() bool

+ func (s *StringColumn) BasicType() types.BasicKind

+ func (s *StringColumn) BasicTypeInfo() types.BasicInfo

+ func (s *StringColumn) CharacterMaximumLength() int

+ func (s *StringColumn) CheckAttr(fieldDefine string) string

+ func (s *StringColumn) Comment() string

+ func (s *StringColumn) Default() string

+ func (s *StringColumn) Name() string

+ func (s *StringColumn) Primary() bool

+ func (s *StringColumn) Required() bool

+ func (s *StringColumn) Type() string

+ type Table interface

+ Columns func() []Column

+ FindColumn func(name string) Column

+ FindIndex func(name string) *Index

+ GetColumns func(ctx context.Context) error

+ Insert func(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

+ Name func() string

+ RereadColumn func(name string) Column

+ Select func(ctx context.Context, Options ...BuildSqlOptions) error

+ SelectAndRunEach func(ctx context.Context, each FncEachRow, Options ...BuildSqlOptions) error

+ SelectAndScanEach func(ctx context.Context, each func() error, rowValue RowScanner, ...) error

+ Update func(ctx context.Context, Options ...BuildSqlOptions) (int64, error)

+ Upsert func(ctx context.Context, Options ...BuildSqlOptions) (int64, error)