mirror of https://github.com/vernonkeenan/lib
30 lines
604 B
Go
30 lines
604 B
Go
|
package app
|
||
|
|
|
||
|
|
import (
|
||
|
|
"database/sql"
|
||
|
|
|
||
|
|
// need this for SQL
|
||
|
|
_ "github.com/go-sql-driver/mysql"
|
||
|
|
)
|
||
|
|
|
||
|
|
// MyDB is the MySQL handler variable
|
||
|
|
var MyDB *sql.DB
|
||
|
|
|
||
|
|
// InitDB initializes the MySQL database using DSN information from the config file
|
||
|
|
//
|
||
|
|
func InitDB() {
|
||
|
|
var db *sql.DB
|
||
|
|
var err error
|
||
|
|
if GetDBMS() != "mysql" {
|
||
|
|
sugar.Fatalf("app.InitDB: 💣 ⛔ unknown DBMS: %s", GetDBMS())
|
||
|
|
return
|
||
|
|
}
|
||
|
|
db, err = sql.Open("mysql", GetDSN())
|
||
|
|
if err != nil {
|
||
|
|
sugar.Fatalf("app.InitDB: 💣 ⛔ Can't log on to DBMS host: %w", err)
|
||
|
|
return
|
||
|
|
}
|
||
|
|
MyDB = db
|
||
|
|
sugar.Debugf("app.InitDB: 👍 📤 %s", GetDBMS())
|
||
|
|
}
|