Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqldb

package module

Go to main page

Versions in this module

v3

v3.0.4

Oct 6, 2024

Changes in this version

+ func TranslateMariaDBToSQLite(query string) string

v3.0.3

Jun 15, 2024

v3.0.2

Jun 14, 2024

v3.0.1

Apr 12, 2024

Changes in this version

+ func IgnoreErrorColumnDoesNotExist(query string, err error) bool

+ func IgnoreErrorDropColumn(query string, err error) bool

+ func IgnoreErrorDropForeignKey(query string, err error) bool

+ func IgnoreErrorDropTable(query string, err error) bool

+ func IgnoreErrorTableDoesNotExist(query string, err error) bool

v3.0.0

Feb 28, 2024

Changes in this version

+ const DBTypeMSSQL

+ const DBTypeMariaDB

+ const DBTypeMySQL

+ const DBTypeSQLite

+ const LogLevelDebug

+ const LogLevelDefault

+ const LogLevelError

+ const LogLevelInfo

+ const LogLevelNone

+ const SQLiteInMemoryFilepathRaceSafe

+ const SQLiteInMemoryFilepathRacy

+ var DefaultSQLitePragmas = []string

+ 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 ErrInvalidLoggingLevel = errors.New("sqldb: invalid logging level")

+ 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 AddConnectionOption(key, value string)

+ func Close() (err error)

+ func Connect() (err error)

+ func Connected() bool

+ func Connection() *sqlx.DB

+ func DBType(s string) dbType

+ func DefaultMapperFunc(s string) string

+ func DeploySchema(opts *DeploySchemaOptions) (err error)

+ func GetSQLiteLibrary() library

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

+ func IgnoreErrorDropDoesNotExist(query string, err error) bool

+ func IgnoreErrorDropUnknownColumn(query string, err error) bool

+ func IgnoreErrorDuplicateColumn(query string, err error) bool

+ func IgnoreErrorIndexAlreadyExists(query string, err error) bool

+ func IgnoreErrorRenameDoesNotExist(query string, err error) bool

+ func IgnoreErrorSQLiteModify(query string, err error) bool

+ func IsMSSQL() bool

+ func IsMariaDB() bool

+ func IsMySQL() bool

+ func IsSQLite() bool

+ func RunDeployQueryTranslators(in string) (out string)

+ func RunUpdateQueryTranslators(in string) (out string)

+ func TranslateMariaDBToSQLiteCreateTable(query string) string

+ func Type() dbType

+ func UpdateSchema(opts *UpdateSchemaOptions) (err error)

+ func Use(c *Config)

+ type Bindvars []interface

+ type Columns []string

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

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

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

+ type Config struct

+ ConnectionOptions map[string]string

+ DeployFuncs []QueryFunc

+ DeployQueries []string

+ DeployQueryErrorHandlers []ErrorHandler

+ DeployQueryTranslators []Translator

+ Host string

+ LoggingLevel logLevel

+ MapperFunc func(string) string

+ Name string

+ Password string

+ Port uint

+ SQLitePath string

+ SQLitePragmas []string

+ Type dbType

+ UpdateFuncs []QueryFunc

+ UpdateQueries []string

+ UpdateQueryErrorHandlers []ErrorHandler

+ UpdateQueryTranslators []Translator

+ User string

+ func New() *Config

+ func NewMSSQL(host, dbName, user, password string) *Config

+ func NewMariaDB(host, dbName, user, password string) *Config

+ func NewMySQL(host, dbName, user, password string) *Config

+ func NewSQLite(path string) *Config

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

+ 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(opts *DeploySchemaOptions) (err error)

+ func (c *Config) IsMSSQL() bool

+ func (c *Config) IsMariaDB() bool

+ func (c *Config) IsMySQL() bool

+ func (c *Config) IsSQLite() bool

+ func (c *Config) RunDeployQueryTranslators(in string) (out string)

+ func (c *Config) RunUpdateQueryTranslators(in string) (out string)

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

+ type DeploySchemaOptions struct

+ CloseConnection bool

+ type ErrorHandler func(string, error) bool

+ type QueryFunc func(*sqlx.DB) error

+ type Translator func(string) string

+ type UpdateSchemaOptions struct

+ CloseConnection bool

+ type Where string

+ func (w Where) String() string

v3.0.0-beta3

Jan 19, 2024

v3.0.0-beta2

Jan 19, 2024

Other modules containing this package

github.com/c9845/sqldb

github.com/c9845/sqldb/v2