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(&post, "select * from posts") log.Println(post) }
Result
2019/10/13 18:30:53 [{1 ABCDE Mumu-man} {2 teketeke Takeyan}]
コメント