sqldb

package module

Go to main page

Versions in this module

v1

v1.4.2

Jun 16, 2022

v1.4.1

Jun 12, 2022

v1.4.0

Jun 12, 2022

Changes in this version

+ func GetSQLiteBusyTimeout() (busyTimeout int, err error)

+ func GetSQLiteJournalMode() (journalMode string, err error)

type Config

+ SQLitePragmas []string

+ func (c *Config) GetSQLiteBusyTimeout() (busyTimeout int, err error)

+ func (c *Config) GetSQLiteJournalMode() (journalMode string, err error)

v1.3.1

Jun 7, 2022

v1.3.0

Jun 7, 2022

Changes in this version

+ func DeploySchemaWithOps(ops DeploySchemaOptions) (err error)

+ func UpdateSchemaWithOps(ops UpdateSchemaOptions) (err error)

type Config

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

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

+ type DeploySchemaOptions struct

+ CloseConnection bool

+ SkipInsert bool

+ type UpdateSchemaOptions struct

+ CloseConnection bool

v1.2.2

Jun 2, 2022

v1.2.1

Jun 2, 2022

v1.2.0

Jun 2, 2022

Changes in this version

+ func GetSQLiteLibrary() string

v1.1.1

May 21, 2022

v1.1.0

May 21, 2022

Changes in this version

+ func TFMySQLToSQLiteReformatDatetime(in string) (out string)

+ func TFMySQLToSQLiteReformatDefaultTimestamp(in string) (out string)

+ func TFMySQLToSQLiteReformatID(in string) (out string)

+ func TFMySQLToSQLiteRemovePrimaryKeyDefinition(in string) (out string)

v1.0.4

May 21, 2022

v1.0.3

May 21, 2022

v1.0.2

May 14, 2022

Changes in this version

+ const InMemoryFilePathRaceSafe

+ const InMemoryFilePathRacy

v1.0.1

Dec 1, 2021

v1.0.0

Nov 10, 2021

Changes in this version

+ const DBTypeMariaDB

+ const DBTypeMySQL

+ const DBTypeSQLite

+ const SQLiteJournalModeRollback

+ const SQLiteJournalModeWAL

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

+ var ErrDoubleCommaInColumnString = errors.New("sqldb: Extra comma in column name")

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

+ var ErrInvalidDBType = fmt.Errorf("sqldb: invalid db type provided, must be one of the following %s", ...)

+ var ErrInvalidJournalMode = errors.New("sqldb: Invalid SQLite journal mode")

+ 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)

+ 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(dontInsert bool) (err error)

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

+ func IsMariaDB() bool

+ func IsMySQL() bool

+ func IsSQLite() bool

+ func JournalMode(s string) journalMode

+ func MapperFunc(m func(string) string)

+ func SQLitePragmaJournalMode(j journalMode)

+ func Save(c Config)

+ func SetDeployFuncs(fs []func() error)

+ func SetDeployQueries(qs []string)

+ func SetUpdateIgnoreErrorFuncs(fs []UpdateIgnoreErrorFunc)

+ func SetUpdateQueries(qs []string)

+ func TFToSQLiteReformatDatetime(in string) (out string)

+ func TFToSQLiteReformatDefaultTimestamp(in string) (out string)

+ func TFToSQLiteReformatID(in string) (out string)

+ func TFToSQLiteRemovePrimaryKeyDefinition(in string) (out string)

+ func TranslateCreateTableFuncs(fs []TranslateFunc)

+ 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)

+ 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 []func() error

+ DeployQueries []string

+ Host string

+ MapperFunc func(string) string

+ Name string

+ Password string

+ Port uint

+ SQLitePath string

+ SQLitePragmaJournalMode journalMode

+ TranslateCreateTableFuncs []TranslateFunc

+ Type dbType

+ UpdateIgnoreErrorFuncs []UpdateIgnoreErrorFunc

+ UpdateQueries []string

+ User string

+ func GetDefaultConfig() (c *Config)

+ func NewConfig(t dbType) *Config

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

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

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

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

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

+ func (c *Config) Connected() bool

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

+ func (c *Config) DeploySchema(dontInsert bool) (err error)

+ func (c *Config) IsMariaDB() bool

+ func (c *Config) IsMySQL() bool

+ func (c *Config) IsMySQLOrMariaDB() bool

+ func (c *Config) IsSQLite() bool

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

+ type TranslateFunc func(string) string

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

+ type Where string

+ func (w Where) String() string

Other modules containing this package

github.com/c9845/sqldb/v2

github.com/c9845/sqldb/v3

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