db

package

v1.0.0 Latest Latest Go to latest Published: Apr 27, 2020 License: MIT 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

Repository

github.com/andrelrg/gutils

Links

Open Source Insights

Documentation ¶

Index ¶

type Config
type Database
- func NewMySQL(config Config) *Database
- func NewPgSQL(config Config) *Database
type DatabaseInterface

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type Config ¶

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

Config Interface With Methods to be a database config

type Database ¶

type Database struct {
	ConnectionLine string
	Conn           *sql.DB
	Driver         string
}

func NewMySQL ¶

func NewMySQL(config Config) *Database

NewMySQL makes a new instance of Database and connect to a MySQL database.

func NewPgSQL ¶

func NewPgSQL(config Config) *Database

NewPgSQL makes a new instance of PgSQL and connect to PostgresSQL database.

func (*Database) Close ¶

func (d *Database) Close()

Close is responsible for closing database connection

func (*Database) Connect ¶

func (d *Database) Connect() error

func (*Database) Execute ¶

func (d *Database) Execute(query string, args ...interface{}) (sql.Result, error)

Execute executes the query received with the given parameters.

func (*Database) GetJSON ¶

func (d *Database) GetJSON(sqlString string) (map[string]interface{}, error)

GetJSON Get first row in JSON format.

func (*Database) GetJSONList ¶

func (d *Database) GetJSONList(sqlString string) ([]map[string]interface{}, error)

GetJSONList Fetch all lines of given select

func (*Database) MapScan ¶

func (d *Database) MapScan(query string, args ...interface{}) (map[string]interface{}, error)

MapScan Get the result of a query in this format: map[string]interface{}

func (*Database) Ping ¶

func (d *Database) Ping() error

Ping Tests the connection.

func (*Database) QueryRow ¶

func (d *Database) QueryRow(query string, args ...interface{}) *sql.Row

QueryRow Get the next Query Row.

func (*Database) SliceMapScan ¶

func (d *Database) SliceMapScan(query string, args ...interface{}) ([]map[string]interface{}, error)

SliceMapScan Fetch all lines of given select

type DatabaseInterface ¶

type DatabaseInterface interface {
	Connect() error
	Ping() error
	Execute(query string, args ...interface{}) (sql.Result, error)
	QueryRow(query string, args ...interface{}) *sql.Row
	GetJSON(sqlString string) (map[string]interface{}, error)
	MapScan(sqlString string, args ...interface{}) (map[string]interface{}, error)
	GetJSONList(sqlString string) ([]map[string]interface{}, error)
	Close()
}

Database Interface With Methods to be a database handler

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL