database

Documentation

Overview

database provide common database methods

Index

• type Database
  • func NewDatabase() (*Database, error)
  • func (db *Database) Exec(statement string, parameters ...interface{}) (res sql.Result, err error)
  • func (db *Database) Query(statement string, parameters ...interface{}) (res *sql.Rows, err error)

Examples

• NewDatabase

Types

type Database

type Database struct {
	*sql.DB
}

func NewDatabase

func NewDatabase() (*Database, error)

NewDatabase returns a Database

Example

os.Setenv("DOCKER_NAME", "utest01")
_, err := NewDatabase()
fmt.Println(err)

os.Setenv("DOCKER_NAME", "")
_, err = NewDatabase()
fmt.Println(err)

Output:

<nil>
<nil>

func (*Database) Exec

func (db *Database) Exec(statement string, parameters ...interface{}) (res sql.Result, err error)

Exec runs database dml insert/update/delete, or ddl create/alter

func (*Database) Query

func (db *Database) Query(statement string, parameters ...interface{}) (res *sql.Rows, err error)

Query runs a database queriy