database

Documentation

Overview

Package database provides database connection and configuration utilities. It includes database initialization, connection pooling, and query building.

Index

• Constants
• type DBConfig
• type Database
  • func NewDatabase(dbCnfg *DBConfig) (*Database, error)
  • func (d *Database) Close()

Constants

const (
	DriverName = "mysql"
	MaxDBConn  = 10
	MaxDBIdle  = 5
	DBTimeout  = 5 * time.Second
)

Types

type DBConfig

type DBConfig struct {
	Driver             string
	Host               string
	Port               string
	User               string
	Password           string
	DBName             string
	SSLMode            string
	MaxConn            int
	MaxIdle            int
	ConnectionTimeeout time.Duration
}

DBConfig holds the database configuration

type Database

type Database struct {
	DB *sqlx.DB
}

Database wraps the sqlx.DB instance

func NewDatabase

func NewDatabase(dbCnfg *DBConfig) (*Database, error)

NewDatabase initializes a new database connection

func (*Database) Close

func (d *Database) Close()

Close gracefully shuts down the database connection