dbmanager

Documentation

Index

• type DBManager
  • func NewDBManager() (*DBManager, error)
  • func (manager *DBManager) BeginTransaction() (*sql.Tx, error)
  • func (manager *DBManager) Close() error
  • func (manager *DBManager) Delete(query string, args ...interface{}) (int64, error)
  • func (manager *DBManager) Insert(query string, args ...interface{}) (int64, error)
  • func (manager *DBManager) Select(query string, args ...interface{}) (*sql.Rows, error)
  • func (manager *DBManager) Update(query string, args ...interface{}) (int64, error)

Types

type DBManager

type DBManager struct {
	DB *sql.DB
}

DBManager holds the database connection pool.

func NewDBManager

func NewDBManager() (*DBManager, error)

NewDBManager creates a new DBManager.

func (*DBManager) BeginTransaction

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

BeginTransaction starts a new database transaction.

func (*DBManager) Close

func (manager *DBManager) Close() error

Close closes the database connection.

func (*DBManager) Delete

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

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

func (*DBManager) Insert

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 (*DBManager) Select

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

Select executes a select query and returns the rows.

func (*DBManager) Update

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

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