db

README

gcwebapis/db

Documentation

Index

• type DBcon
  • func CreateDBCon(dbconnectionstring *string) (*DBcon, error)
  • func (c *DBcon) Close()
  • func (c *DBcon) ExecuteQuery(sqlquery string) (*ExecuteResult, error)
  • func (c *DBcon) GetResultRow(sqlquery string) (*sql.Row, error)
  • func (c *DBcon) GetResultRows(sqlquery string) (*sql.Rows, error)
• type ExecuteResult

Types

type DBcon

type DBcon struct {
	DB    *sql.DB
	Ctx   context.Context
	Qstmt *sql.Stmt
	// contains filtered or unexported fields
}

DBcon ... Project DB type

func CreateDBCon

func CreateDBCon(dbconnectionstring *string) (*DBcon, error)

CreateDBCon ... Create Project DB Connection

func (*DBcon) Close

func (c *DBcon) Close()

Close ... Close dbConntions

func (*DBcon) ExecuteQuery

func (c *DBcon) ExecuteQuery(sqlquery string) (*ExecuteResult, error)

ExecuteQuery ...

func (*DBcon) GetResultRow

func (c *DBcon) GetResultRow(sqlquery string) (*sql.Row, error)

GetResultRow ...

func (*DBcon) GetResultRows

func (c *DBcon) GetResultRows(sqlquery string) (*sql.Rows, error)

GetResultRows ...

type ExecuteResult

type ExecuteResult struct {
	LastInsertId int64 `json:"last_insert_id,omitempty"`
	RowsAffected int64 `json:"rows_affected,omitempty"`
}

ExecuteResult ...