database

package

v0.3.0 Latest Latest Go to latest Published: Nov 27, 2023 License: MIT Imports: 7 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

Package database contains functions to simplify opening/closing of DB connections, and tracing of SQL queries

This section is empty.

This section is empty.

func CloseDBConnection(db *sqlx.DB)

CloseDBConnection closes specified database connection.

func CloseSQLConnection(conn *sqlx.Conn)

CloseSQLConnection closes the specified database connection.

func OpenDBConnection(dsn, driver, user, passwd, host, schema, sslMode string) (*sqlx.DB, error)

OpenDBConnection establishes a connection specified database.

func SetDBOptionsAndPing(db *sqlx.DB) error

SetDBOptionsAndPing configures DB connections and attempts to ping it.

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

func NewDBSelectContext(s *zap.SugaredLogger, conn *sqlx.Conn, trace bool) *DBQueryContext

NewDBSelectContext creates a new instance of the DBQueryContext service.

func (q *DBQueryContext) SQLQueryTrace(query string, args ...interface{})

SQLQueryTrace logs the given SQL query if debug is enabled.

func (q *DBQueryContext) SQLResultsTrace(results interface{})

SQLResultsTrace logs the given SQL result if debug is enabled.

func (q *DBQueryContext) SelectContext(ctx context.Context, dest interface{}, query string, args ...interface{}) error

SelectContext logs the give query before executing it and the result afterward, if tracing is enabled?