mysql

package

v0.0.2 Latest Latest Go to latest Published: Nov 26, 2022 License: MIT Imports: 8 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

This section is empty.

type ColumnInfo struct {
	ColumnName string `db:"COLUMN_NAME"`
	ColumnKey  string `db:"COLUMN_KEY"`
	TableName  string `db:"TABLE_NAME"`
}

type Config struct {
	// contains filtered or unexported fields
}

func NewConfigFromEnv() (*Config, error)

func (cfg *Config) GetDBName() string

func (cfg *Config) ToDSN() string

type DB struct {
	// contains filtered or unexported fields
}

func NewDB(db *sqlx.DB) *DB

func OpenMySQLDB(cfg *Config) (*DB, error)

func (db *DB) Close() error

func (db *DB) Exec(query string) (sql.Result, error)

func (db *DB) ExplainWithAnalyze(query string) (string, error)

func (db *DB) GetIndexes(database string, tables []string) ([]*IndexInfo, error)

func (db *DB) GetTableColumns(dbName string, tables []string) ([]*ColumnInfo, error)

type IndexInfo struct {
	TableName string
	Columns   []string
}