sqlhandler

package

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

func NewMapSqlHandler(log logger.Logger, sqlconfigs map[string]config.SQL) map[string]database.SqlHandler

func NewSqlHandler(log logger.Logger, config Config) database.SqlHandler

type Config interface {
	GetHost() string
	GetDatabase() string
	GetUser() string
	GetPassword() string
}

type SqlHandler struct {
	DB *sql.DB
	// contains filtered or unexported fields
}

SqlHandler has a connection with DB

func (handler *SqlHandler) Close() error

func (handler *SqlHandler) Exec(statement string, args ...interface{}) (database.Result, error)

Exec executes the SQL that manipulates the data of the table

func (handler *SqlHandler) MultiExec(multiStatements string) (err error)

Use it for database initialization only

func (handler *SqlHandler) Query(statement string, args ...interface{}) (database.Row, error)

Query gets data from the database

func (handler *SqlHandler) Transaction(f func() (interface{}, error)) (interface{}, error)

Transaction ...

type SqlResult struct {
	Result sql.Result
}

SqlResult ...

func (r *SqlResult) LastInsertId() (int64, error)

LastInsertId ...

func (r *SqlResult) RowsAffected() (int64, error)

RowsAffected ...

type SqlRow struct {
	Rows *sql.Rows
}

SqlRow ...

func (r *SqlRow) Close() error

Close ...

func (r *SqlRow) Next() bool

Next ...

func (r *SqlRow) Scan(dest ...interface{}) error

Scan ...