sqldb

package module

Go to main page

Versions in this module

v2

v2.5.1

Mar 28, 2023

v2.5.0

Mar 14, 2023

Changes in this version

+ const LogLevelDebug

+ const LogLevelError

+ const LogLevelInfo

+ const LogLevelNone

+ var ErrInvalidLoggingLevel = errors.New("sqldb: invalid logging level")

type Config

+ LoggingLevel logLevel

v2.4.2

Feb 1, 2023

v2.4.1

Dec 6, 2022

v2.4.0

Nov 28, 2022

Changes in this version

+ func AddConnectionOption(key, value string)

+ func TFMySQLToSQLiteBLOB(in string) (out string)

+ func UseDefaultTranslateFuncs()

type Config

+ ConnectionOptions map[string]string

+ TranslateUpdateFuncs []func(string) string

+ func (cfg *Config) AddConnectionOption(key, value string)

+ func (cfg *Config) UseDefaultTranslateFuncs()

v2.4.0-beta3

Nov 11, 2022

v2.4.0-beta2

Nov 9, 2022

v2.4.0-beta1

Nov 9, 2022

v2.3.2

Oct 27, 2022

v2.3.1

Oct 27, 2022

Changes in this version

+ const DBTypeMSSQL

+ func DefaultMSSQLConfig(host string, port uint, name, user, password string)

+ func IsMSSQL() bool

type Config

+ func NewMSSQLConfig(host string, port uint, name, user, password string) (cfg *Config)

+ func (cfg *Config) IsMSSQL() bool

+ func (cfg *Config) SQLitePragmasAsString() (filenamePragmaString string)

v2.3.0

Sep 14, 2022

v2.2.0

Aug 1, 2022

Changes in this version

+ func UFIndexAlreadyExists(c Config, query string, err error) bool

type Config

+ TranslateCreateTableFuncs []func(string) string

v2.1.5

Jun 27, 2022

v2.1.4

Jun 25, 2022

v2.1.3

Jun 25, 2022

v2.1.2

Jun 25, 2022

v2.1.1

Jun 25, 2022

Changes in this version

+ const DBTypeMariaDB

+ const DBTypeMySQL

+ const DBTypeSQLite

+ const InMemoryFilePathRaceSafe

+ const InMemoryFilePathRacy

+ var ErrConnected = errors.New("sqldb: connection already established")

+ var ErrExtraCommaInColumnString = errors.New("sqldb: extra comma in column name")

+ var ErrHostNotProvided = errors.New("sqldb: database server host not provided")

+ var ErrInvalidPort = errors.New("sqldb: database server port invalid")

+ var ErrNameNotProvided = errors.New("sqldb: database name not provided")

+ var ErrNoColumnsGiven = errors.New("sqldb: no columns provided")

+ var ErrPasswordNotProvided = errors.New("sqldb: password for database user not provided")

+ var ErrSQLitePathNotProvided = errors.New("sqldb: SQLite path not provided")

+ var ErrUserNotProvided = errors.New("sqldb: database user not provided")

+ func Close() (err error)

+ func Connect() (err error)

+ func Connected() bool

+ func Connection() *sqlx.DB

+ func DBType(s string) dbType

+ func DefaultConfig(t dbType) (err error)

+ func DefaultMapperFunc(s string) string

+ func DefaultMariaDBConfig(host string, port uint, name, user, password string)

+ func DefaultMySQLConfig(host string, port uint, name, user, password string)

+ func DefaultSQLiteConfig(pathToFile string)

+ func DeploySchema(skipInsert bool) (err error)

+ func DeploySchemaWithOps(ops DeploySchemaOptions) (err error)

+ func GetDefaultSQLitePragmas() []string

+ func GetSQLiteLibrary() string

+ func GetSQLiteVersion() (version string, err error)

+ func IsMariaDB() bool

+ func IsMySQL() bool

+ func IsMySQLOrMariaDB() bool

+ func IsSQLite() bool

+ func MapperFunc(m func(string) string)

+ func Save(cfg Config)

+ func TFMySQLToSQLiteReformatDatetime(in string) (out string)

+ func TFMySQLToSQLiteReformatDefaultTimestamp(in string) (out string)

+ func TFMySQLToSQLiteReformatID(in string) (out string)

+ func TFMySQLToSQLiteRemovePrimaryKeyDefinition(in string) (out string)

+ func UFAddDuplicateColumn(c Config, query string, err error) bool

+ func UFAlreadyExists(c Config, query string, err error) bool

+ func UFDropUnknownColumn(c Config, query string, err error) bool

+ func UFModifySQLiteColumn(c Config, query string, err error) bool

+ func UpdateSchema() (err error)

+ func UpdateSchemaWithOps(ops UpdateSchemaOptions) (err error)

+ type Bindvars []interface

+ type Columns []string

+ func (c Columns) ForInsert() (colString, valString string, err error)

+ func (c Columns) ForSelect() (colString string, err error)

+ func (c Columns) ForUpdate() (colString string, err error)

+ type Config struct

+ Debug bool

+ DeployFuncs []DeployFunc

+ DeployQueries []string

+ Host string

+ MapperFunc func(string) string

+ Name string

+ Password string

+ Port uint

+ SQLitePath string

+ SQLitePragmas []string

+ TranslateDeployCreateTableFuncs []func(string) string

+ Type dbType

+ UpdateFuncs []UpdateFunc

+ UpdateIgnoreErrorFuncs []UpdateIgnoreErrorFunc

+ UpdateQueries []string

+ User string

+ func GetDefaultConfig() *Config

+ func NewConfig(t dbType) (cfg *Config, err error)

+ func NewMariaDBConfig(host string, port uint, name, user, password string) (cfg *Config)

+ func NewMySQLConfig(host string, port uint, name, user, password string) (cfg *Config)

+ func NewSQLiteConfig(pathToFile string) (cfg *Config)

+ func (c *Config) UpdateSchema() (err error)

+ func (cfg *Config) Close() (err error)

+ func (cfg *Config) Connect() (err error)

+ func (cfg *Config) Connected() bool

+ func (cfg *Config) Connection() *sqlx.DB

+ func (cfg *Config) DeploySchema(skipInsert bool) (err error)

+ func (cfg *Config) DeploySchemaWithOps(ops DeploySchemaOptions) (err error)

+ func (cfg *Config) IsMariaDB() bool

+ func (cfg *Config) IsMySQL() bool

+ func (cfg *Config) IsMySQLOrMariaDB() bool

+ func (cfg *Config) IsSQLite() bool

+ func (cfg *Config) UpdateSchemaWithOps(ops UpdateSchemaOptions) (err error)

+ type DeployFunc func(*sqlx.DB) error

+ type DeploySchemaOptions struct

+ CloseConnection bool

+ SkipInsert bool

+ type UpdateFunc func(*sqlx.Tx) error

+ type UpdateIgnoreErrorFunc func(Config, string, error) bool

+ type UpdateSchemaOptions struct

+ CloseConnection bool

+ type Where string

+ func (w Where) String() string

Other modules containing this package

github.com/c9845/sqldb

github.com/c9845/sqldb/v3

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL