bennAH/sqlutil

golang sql util functions

sqlutil

godoc.org

Takes a query and returns a list of results as a map. The map is a from the column name as a string to the value as a byte. Useful for debugging raw sql queries using an sql driver and possibly bulding an ORM.

golang sql util functions

Installation

Make sure that Go is installed on your computer. Type the following command in your terminal:

go get github.com/bennAH/sqlutil

Import package in your project

Add following line in your *.go file:

import "github.com/bennAH/sqlutil"

Raw Result Map Example

Saves needing to know columns to scan ahead of time.

import (
	. "github.com/bennAH/sqlutil"
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
)

func main() {
	db, _ := sql.Open("mysql", "user:pass@tcp(127.0.0.1:3306)/db")
	rows, _ := db.Query("select * from table")
	rrm := RawResultMap(rows)
	
	fmt.Println(rrm)
}

'rrm' -> a list of maps for each row result.

row result map -> string (column name) to []byte (column value)

More to come