bom-d-van / sqlkungfu

A simple and interesting way to work with sql in Golang.

sqlkungfu

sqlkungfu is a very simple data binding package, built along with database/sql package. It doesn't assume fixed bindings between your structs and tables. Instead, it offers us the ability to avail ourself of the powerful combination of golang and SQL.

Unmarshal

common

select id, name, phone, sex from persons limit 1

var data struct{
	ID    uint
	Name  string
	Phone string
	Sex   string
}
sqlkungfu.Unmarshal(rows, &data)

var data []string
sqlkungfu.Unmarshal(rows, &data)

var data [4]string
sqlkungfu.Unmarshal(rows, &data)

var data map[string]interface{}
sqlkungfu.Unmarshal(rows, &data)

select id, name, phone, sex from persons limit 10

var data []struct{
	ID    uint
	Name  string
	Phone string
	Sex   string
}
sqlkungfu.Unmarshal(rows, &data)

var data [][]string
sqlkungfu.Unmarshal(rows, &data)

var data [10][4]string
sqlkungfu.Unmarshal(rows, &data)

var data []map[string]interface{}
sqlkungfu.Unmarshal(rows, &data)

schema

select 'num.id', 'num.age', 'text.name', 'text.phone', 'text.sex' from persons limit 10

var data []struct{
	Num struct{
		ID    uint
		Age uint
	}
	Text struct{
		Name  string
		Phone string
		Sex   string
	}
}
sqlkungfu.Unmarshal(rows, &data)

Insert/Update