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
+15.2k JavaScript/JQuery : Detect or intercept enter key pressed example
+7k Golang : How to call function inside template with template.FuncMap
+16.4k CodeIgniter/PHP : Create directory if does not exist example
+8k Golang : Get all countries phone codes
+5.7k Golang : Error handling methods
+36.5k Golang : Validate IP address
+5.9k AWS S3 : Prevent Hotlinking policy
+8.2k Golang : Find relative luminance or color brightness
+7.7k Golang : Mapping Iban to Dunging alphabets
+5.6k Fix fatal error: evacuation not done in time problem