database.Connect - Code Metrics - Inspection of "Update Structure" - memnix/memnix-rest - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( aca4ae...d38763 )

by Yume

created 2022-02-27 14:33 UTC

database.Connect A

↳ Parent: pkg/database/connection.go

Complexity

Conditions

Size

Total Lines	28
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	4
eloc	16
nop	0
dl	0
loc	28
rs	9.6
c	0
b	0
f	0

package database

import (
	"fmt"
	"log"
	"os"
	"strconv"
	"time"

	"github.com/joho/godotenv"
	"gorm.io/driver/postgres"
	"gorm.io/gorm"
)

var (
	// DBConn is a pointer to gorm.DB
	DBConn   *gorm.DB
	user     string
	password string
	host     string
	db       string
	port     string
)

func LoadVar() {
	// Load the .env file
	err := godotenv.Load()
	if err != nil {
		log.Fatal("Error loading .env file")
	}

	user = os.Getenv("DB_USER")         // Get DB_USER from env
	password = os.Getenv("DB_PASSWORD") // Get DB_PASSWORD from env
	host = os.Getenv("DB_HOST")         // Get DB_HOST from env
	db = os.Getenv("DB_DB")             // Get DB_DB (db name) from env
	port = os.Getenv("DB_PORT")         // Get DB_PORT from env

}

// Connect creates a connection to database
func Connect() (err error) {

	// Load var from .env file
	LoadVar()

	// Convert port
	port, err := strconv.Atoi(port)
	if err != nil {
		return err
	}

	// Create postgres connection string
	dsn := fmt.Sprintf("user=%s password=%s host=%s dbname=%s port=%d sslmode=disable", user, password, host, db, port)
	// Open connection
	DBConn, err = gorm.Open(postgres.Open(dsn), &gorm.Config{})
	if err != nil {
		return err
	}

	sqlDB, err := DBConn.DB()
	if err != nil {
		return err
	}
	sqlDB.SetMaxIdleConns(10)
	sqlDB.SetMaxOpenConns(50)
	sqlDB.SetConnMaxLifetime(time.Hour)

	return nil
}


1			package database
2
3			import (
4			"fmt"
5			"log"
6			"os"
7			"strconv"
8			"time"
9
10			"github.com/joho/godotenv"
11			"gorm.io/driver/postgres"
12			"gorm.io/gorm"
13			)
14
15			var (
16			// DBConn is a pointer to gorm.DB
17			DBConn *gorm.DB
18			user string
19			password string
20			host string
21			db string
22			port string
23			)
24
25			func LoadVar() {
26			// Load the .env file
27			err := godotenv.Load()
28			if err != nil {
29			log.Fatal("Error loading .env file")
30			}
31
32			user = os.Getenv("DB_USER") // Get DB_USER from env
33			password = os.Getenv("DB_PASSWORD") // Get DB_PASSWORD from env
34			host = os.Getenv("DB_HOST") // Get DB_HOST from env
35			db = os.Getenv("DB_DB") // Get DB_DB (db name) from env
36			port = os.Getenv("DB_PORT") // Get DB_PORT from env
37
38			}
39
40			// Connect creates a connection to database
41			func Connect() (err error) {
42
43			// Load var from .env file
44			LoadVar()
45
46			// Convert port
47			port, err := strconv.Atoi(port)
48			if err != nil {
49			return err
50			}
51
52			// Create postgres connection string
53			dsn := fmt.Sprintf("user=%s password=%s host=%s dbname=%s port=%d sslmode=disable", user, password, host, db, port)
54			// Open connection
55			DBConn, err = gorm.Open(postgres.Open(dsn), &gorm.Config{})
56			if err != nil {
57			return err
58			}
59
60			sqlDB, err := DBConn.DB()
61			if err != nil {
62			return err
63			}
64			sqlDB.SetMaxIdleConns(10)
65			sqlDB.SetMaxOpenConns(50)
66			sqlDB.SetConnMaxLifetime(time.Hour)
67
68			return nil
69			}
70

memnix / memnix-rest

Push — main ( aca4ae...d38763 )

database.Connect A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like