dbmanager

package

v0.0.0-...-5dd2f1f Latest Latest Go to latest Published: Dec 9, 2023 License: Apache-2.0 Imports: 5 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 DBManager struct {
	DB *sql.DB
}

DBManager holds the database connection pool.

func NewDBManager() (*DBManager, error)

NewDBManager creates a new DBManager.

func (manager *DBManager) BeginTransaction() (*sql.Tx, error)

BeginTransaction starts a new database transaction.

func (manager *DBManager) Close() error

Close closes the database connection.

func (manager *DBManager) Delete(query string, args ...interface{}) (int64, error)

Delete executes a delete query and returns the number of affected rows.

func (manager *DBManager) Insert(query string, args ...interface{}) (int64, error)

Insert executes an insert query and returns the ID of the last inserted row.

func (manager *DBManager) Select(query string, args ...interface{}) (*sql.Rows, error)

Select executes a select query and returns the rows.

func (manager *DBManager) Update(query string, args ...interface{}) (int64, error)

Update executes an update query and returns the number of affected rows.