2018-04-12 09:41:21 +00:00
|
|
|
package models
|
|
|
|
|
|
|
|
|
|
import (
|
2018-04-20 06:33:52 +00:00
|
|
|
"database/sql"
|
2018-05-08 08:19:51 +00:00
|
|
|
"fmt"
|
2018-04-12 09:41:21 +00:00
|
|
|
|
2018-05-08 08:19:51 +00:00
|
|
|
"git.trj.tw/golang/go-gallery/modules/config"
|
2018-04-12 09:41:21 +00:00
|
|
|
_ "github.com/lib/pq"
|
|
|
|
|
)
|
|
|
|
|
|
2018-04-20 06:33:52 +00:00
|
|
|
var x *sql.DB
|
2018-04-12 09:41:21 +00:00
|
|
|
|
|
|
|
|
// NewDB - db object
|
2018-04-20 06:33:52 +00:00
|
|
|
func NewDB() (*sql.DB, error) {
|
2018-04-12 09:41:21 +00:00
|
|
|
var err error
|
2018-05-08 08:19:51 +00:00
|
|
|
conf := config.GetConf()
|
|
|
|
|
connStr := fmt.Sprintf("user=%s host=%s sslmode=disable dbname=%s port=%d", conf.Database.User, conf.Database.Host, conf.Database.DBName, conf.Database.Port)
|
|
|
|
|
x, err = sql.Open("postgres", connStr)
|
2018-04-12 09:41:21 +00:00
|
|
|
return x, err
|
|
|
|
|
}
|
