Go ORM(sqlx)

sqlx

github.com/jmoiron/sqlx is ORMapper for golang (Original documetaion says extension of database/sql.

From previous entry, let’s check sqlx example.

(Use table and sample from previous entry (Go MySQL).

To use this library,

go get "github.com/jmoiron/sqlx"

Don’t forget to use go get

Example

// go get "github.com/jmoiron/sqlx"
package main

import (
	"log"

	_ "github.com/go-sql-driver/mysql"
	"github.com/jmoiron/sqlx"
)

type Post struct {
	Id      int
	Content string
	Author  string
}

func main() {
	db, err := sqlx.Connect("mysql", "root:atmarkplant@/gosample")
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()
	post := []Post{}

	db.Select(&amp;post, "select * from posts")

	log.Println(post)
}

Result

2019/10/13 18:30:53 [{1 ABCDE Mumu-man} {2 teketeke Takeyan}]