golang working with sql server

Golang ORM for Mssql server can be found here  (GORM) and here :-

Here is the code that i used to fetch data from a table called country which has just 2 columns which are :-

a) countryid

b) countryname

Here is the code that i used to access my sql server using GORM

	package main
	import (
	"log"
	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mssql"
	)
	func main() {
	db, _ := gorm.Open("mssql", "sqlserver://sa:P@ssword01@192.168.99.100:1433?database=pts")
	var (
	countryid int
	sqlversion string
	)
	rows, _ := db.Raw("select * from country").Rows() // (*sql.Rows, error)
	defer rows.Close()
	for rows.Next() {
	rows.Scan(&countryid, &sqlversion)
	log.Println(countryid, sqlversion)
	}
	defer db.Close()
	}

view raw gorm_orm_test.go hosted with ❤ by GitHub

Here is the code that i used to access my mssql server docker running on 192.168.99.100 and database called PTS.

	package main
	import (
	"database/sql"
	"fmt"
	"log"
	_ "github.com/denisenkom/go-mssqldb"
	)
	func main() {
	condb, errdb := sql.Open("mssql", "server=192.168.99.100;database=pts;user id=sa;password=P@ssword01;")
	if errdb != nil {
	fmt.Println(" Error open db:", errdb.Error())
	}
	var (
	countryid int
	sqlversion string
	)
	rows, err := condb.Query("select * from country")
	if err != nil {
	log.Fatal(err)
	}
	for rows.Next() {
	err := rows.Scan(&countryid, &sqlversion)
	if err != nil {
	log.Fatal(err)
	}
	log.Println(sqlversion)
	}
	defer condb.Close()
	}

view raw mssql_server_go.go hosted with ❤ by GitHub