Golang database/sql.DB.Begin and Close functions example
package database/sql
Begin starts a transaction. The isolation level is dependent on the driver.
Golang database/sql.DB.Begin function usage example
func openTestConnConninfo(conninfo string) (*sql.DB, error) {
datname := os.Getenv("PGDATABASE")
sslmode := os.Getenv("PGSSLMODE")
timeout := os.Getenv("PGCONNECT_TIMEOUT")
if datname == "" {
os.Setenv("PGDATABASE", "pqgotest")
}
if sslmode == "" {
os.Setenv("PGSSLMODE", "disable")
}
if timeout == "" {
os.Setenv("PGCONNECT_TIMEOUT", "20")
}
return sql.Open("postgres", conninfo)
}
db, err := openTestConnConninfo("user=usernametoaccessdb")
if err != nil {
t.Fatal(err)
}
defer db.Close() // <-- here
_, err = db.Begin() // <--- here
if err != nil {
t.Fatal("unable to start a transaction with database server")
}
References :
Advertisement
Something interesting
Tutorials
+7.3k Golang : alternative to os.Exit() function
+87.8k Golang : How to convert character to ASCII and back
+9.4k Golang : Terminate-stay-resident or daemonize your program?
+14.4k Android Studio : Use image as AlertDialog title with custom layout example
+22.9k Golang : Gorilla mux routing example
+8.7k Golang : How to join strings?
+21.8k Golang : Convert string slice to struct and access with reflect example
+11.2k Google Maps URL parameters configuration
+5.2k PHP : See installed compiled-in-modules
+26.8k Golang : Find files by extension
+19.4k Golang : Fix cannot download, $GOPATH not set error
+25.4k Golang : Convert long hexadecimal with strconv.ParseUint example